SQL SSMS TRICKS: Customizing the Status Bar for each SQL Server SSMS Connection

#SQL #SQLTRICKS #CKOLA #Chandrasekkhar #SSMS #ETL #Shorts #YoutubeShorts

Almost every DBA has to manage more than one instance of SQL Server. If you are administering production, test and development servers then there are probably databases with similar names and structures in each of these instances. The scenario becomes more complicated when you are working with multiple logins in each instance at the same time. Chances increase to run a script on an instance other than on which it was intended to run. Although every query pane in SSMS includes information such as server instance and user this information is not always displayed prominently and it takes a bit of effort to note the details from tab to tab. In this tip, I will show an option in SSMS (SQL Server Management Studio) to identify instances and users using customized status bars.

Click on the "Connection Properties" tab
Check "Use custom color"
Click the "Select..." button
Select a color from the color chart
Select "OK"