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