TIP – SSMS : Color Code your Server

If you are a DBA and deal with lots of servers, especially, production servers, you need to be very careful on applying code changes or configurational changes. Any execution by mistake may lead you trouble, infact a very BIG trouble.

Here is a small TIP, you can follow while you connect to server – a color code method.

Step 1: While you connect the Server, select option .

Step 2: Go to Connection Properties and “Use custome color”.( I use RED for Production Servers, it is a personal choice anyway)

Once you connected with this option enabled, then whenever you connect to the server it uses RED color as the background for status bar.


This tip was very useful for me for a long time, hope you will also enjoy…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s