SQL Operations Studio is the new cross platform tool from Microsoft which can run on Windows, MacOS or Linux and allow you to connect to your database instance. It is free, lightweight and extremely customizable – since it is built on top of Visual Studio Code.
The initial January release insiders build focuses on bug fixes and minor feature improvements. One thing which caught my attention was the ‘SQL Editor Tab Color‘ to differentiate between query tabs inside the IDE.
Using Custom Color to differentiate between environments is one of my favorite feature inside SQL Server Management Studio. The color is displayed in the SSMS status bar, at the bottom. Hence when you connect with a particular environment, it uses the same assigned color. This presents a visual indication of the environment in which you are running your scripts. Lot of 3rd Party tools from RedGate and ApexSQL also has their own versions of setting different colors while connecting to different environments.
You can read my blog to find out how to configure custom colors in SSMS —
SQL Operations Studio now has the same feature built into the IDE – with a slight variation to SSMS implementation. When you save the database connection you can associate it to a ‘Server Group’. I really like this feature since it lets you organize the various database connections. Based on the database environments, you can assign a color to your Server Groups – which will help you to visually identify a group.
Inside my SQL Ops IDE, I have set up Server Groups and assigned them colors accordingly —
Once you do that, anytime you open a connection to a database within that Server Group, the SQL Query Editor Tab Color will have the same color as the Server Group. Isn’t that cool?
This serves as a nice visual indication to which Server Group you are connected to. Please see the screenshot below where I opened 5 query tabs connecting to 5 different server groups. You can easily identify which server you are connected to with a single glance.
Yet another nice feature built into SQL Ops Studio. As a developer, I have almost shifted from SSMS to this new IDE since a month and have been loving it. Have you tried SQL Ops Studio yet?
Read my other posts about SQL Operations Studio –
Categories: SQL Server