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!
Introduction to Data Wrangler in Microsoft Fabric
What is Data Wrangler? A key selling point of Microsoft Fabric is the Data Science
Jul
Autogen Power BI Model in Tabular Editor
In the realm of business intelligence, Power BI has emerged as a powerful tool for
Jul
Microsoft Healthcare Accelerator for Fabric
Microsoft released the Healthcare Data Solutions in Microsoft Fabric in Q1 2024. It was introduced
Jul
Unlock the Power of Colour: Make Your Power BI Reports Pop
Colour is a powerful visual tool that can enhance the appeal and readability of your
Jul
Python vs. PySpark: Navigating Data Analytics in Databricks – Part 2
Part 2: Exploring Advanced Functionalities in Databricks Welcome back to our Databricks journey! In this
May
GPT-4 with Vision vs Custom Vision in Anomaly Detection
Businesses today are generating data at an unprecedented rate. Automated processing of data is essential
May
Exploring DALL·E Capabilities
What is DALL·E? DALL·E is text-to-image generation system developed by OpenAI using deep learning methodologies.
May
Using Copilot Studio to Develop a HR Policy Bot
The next addition to Microsoft’s generative AI and large language model tools is Microsoft Copilot
Apr