patternsqlModerate
Trick to remember which instance I am working with
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?
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
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.