I found something extremely useful whilst perusing the MSDN forums the other day – The fact that you can change the colour of the connection bar in SSMS based on the instance of SQL Server you’re connected to!
It’s extremely easy to implement, but helps differentiate which server you’re looking at when working with multiple servers in multiple tabs. This means you can have one colour for a local server, another for a development testing server, and another for a live environment.
To start using a colour, open up SSMS.
From the Connect to Server dialogue box, click “Options >>” to expand the window.
On the Connection tab, select the instance you’d like to configure.
Go to the Connection Properties tab, and tick “Use custom color” – this while make the “Select” button on the same line available. Click “Select”, and choose a colour you’d like to associate with this instance – note that you can change this as much as you like.
Now click “Connect” to connect to your chosen instance, and you should notice that the bar towards the bottom of the screen is colour you picked in the last step.