How to Set Status Bar Color in SSMS for Different SQL Server Instances - SQL Server / TSQL Tutorial Part 6

Scenario:

Let's say you are working as DBA or Developer and you can connect to different development servers, UAT Servers and Productions Servers and have permission to execute scripts. You always check the server name in SSMS before you run the script. Mistakes can happen. SSMS provide us an extra feature that we can use to color the Status Bar to make sure we are in correct environment.

Solution:

Let's say we want to color status bar to green for our development servers, yellow for SIT/QA, Orange for UAT and Red for Production.

Step 1:
Let's say we are configuring SSMS for our development server. Open SQL Server Management Studio (SSMS) and provide SQL Server Instance and then click on options as shown below.

How to change Status Bar Color in SQL Server Management Studio- SQL Server Tutorial


Step 2:
Go to User Custom Color, then hit Select button and choose the color you like. In our case we are choosing green color and then hit connect.
How to change Status color in SQL Server Management Studio- SQL Server Tutorial

Step 3:
Now once you open New Query, you will see Status Bar color will be green. You can close the SSM and reopen, setting is saved and every time you will connect to this server, status bar will be green.

Perform the above Steps for Other servers you like to connect.




5 comments:

  1. This is great!! Now I see you have plenty of room to in the columns of the status bar to display the server information. I have little room for that, and WAY too much room for the 'Executing query...' column. How do I adjust the column width? thank you

    ReplyDelete
  2. Wow! This could be one of the most useful blogs we have ever come across on thesubject. Actually excellent info! I’m also an expert in this topic so I can understand your effort. colorize a picture

    ReplyDelete
  3. I want to learn more about the possibilities of custom business software development. What advantages can it provide and how to choose a reliable company to implement such a project?

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Flutter is a popular platform for building cross-platform mobile apps, and finding experienced Flutter developers is key to success in this field. SO if you need to hire flutter developers I would recommend starting with Binary Studio https://binary-studio.com/hire-flutter-developers/. They have a unique approach to hiring and training engineers by assessing their skills using over 50 different metrics and providing the best candidates with an intensive educational course.

    ReplyDelete