Have you ever wished there was an easier way to tell at a glance what server a particular Management Studio query window was connected to by, say, colouring the query window? Well it turns out there is a way to do this baked into Management Studio, it’s just fairly well hidden. Here’s how you do it:
- Open Management Studio and press Ctrl + Alt + G to open the Registered Servers window.
- Right-click the ‘Local Server Groups’ folder and select ‘New Server Registration’.
- In the popup dialog, on the ‘General’ tab, enter the login information and give the registered server a name (e.g. ‘Production’).
- To to the ‘Connection Properties’ tab, the tick the ‘Use Custom Color’ box. Click ‘Select’ to the right of it.
- Choose a colour for this server (I like to use green for Test, blue for SIT/UAT and red for Production).
- Finally, click ‘Save’.
That’s it! The next time you connect to the server you’ll see that the bottom information bar of the query window is now whichever colour you chose. I know this won’t be for everyone, but for me it makes it much easier to see at a glance which server I’m connected to.
visit https://adatis.co.uk/blog/ to read our other blogs!
How Artificial Intelligence and Data Add Value to Businesses
Knowledge is power. And the data that you collect in the course of your business
May
Databricks Vs Synapse Spark Pools – What, When and Where?
Databricks or Synapse seems to be the question on everyone’s lips, whether its people asking
1 Comment
May
Power BI to Power AI – Part 2
This post is the second part of a blog series on the AI features of
Apr
Geospatial Sample architecture overview
The first blog ‘Part 1 – Introduction to Geospatial data’ gave an overview into geospatial
Apr
Data Lakehouses for Dummies
When we are thinking about data platforms, there are many different services and architectures that
Apr
Enable Smart Facility Management with Azure Digital Twins
Before I started writing this blog, I went to Google and searched for the keywords
Apr
Migrating On-Prem SSIS workload to Azure
Goal of this blog There can be scenario where organization wants to migrate there existing
Mar
Send B2B data with Azure Logic Apps and Enterprise Integration Pack
After creating an integration account that has partners and agreements, we are ready to create
Mar