HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlModerate

Trick to remember which instance I am working with

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
trickrememberwithworkinginstancewhich

Problem

I work as a BI developer and always switch between different instances on a same server. However, sometimes I forget the right instance and for example may cause to truncate a table on the other.
I know this is not a technical question but rather experimental. I would be so thankful if you , dear DBAs, could tell me what do you do to always work on the right instance?

Solution

You can colour code the status bar in SQL Server Management Studio
Easiest if you use the Registered Servers or Central Management Servers feature and then allocate colours at a group level i.e. Dev (Green) / Test (Yellow) / Prod (Red)

https://documentation.red-gate.com/sp/ssms-tab-management/working-with-ssms-tab-management-quick-ref

btw You may need to spell it color to get a match

Context

StackExchange Database Administrators Q#286266, answer score: 14

Revisions (0)

No revisions yet.