Welcome to another blog post about SQL Server! In this article, we will be discussing some of the changes that have been made to SQL Server Management Studio (SSMS) in the 2016 version.
One of the notable changes in SSMS is the switch to using Visual Studio 2015 shell. While this change brings several improvements and new features, some users may prefer certain settings to remain as they were in the older versions, such as SQL Server 2000.
One particular setting that has caught the attention of many users is the color coding used for system object names in the text editor. The default color scheme in SSMS 2016 may cause strain on the eyes, especially when dealing with DMVs and system objects.
Fortunately, changing the text editor color scheme is a simple process. To do this, follow these steps:
- Open SSMS and navigate to “Tools > Options”.
- In the Options window, select “Environment” and then “Fonts and Colors”.
- Under “Show settings for:”, choose “Text Editor”.
- Scroll down and find “SQL System Table” under “Display Items”.
- Change the “Item foreground” from “Lime” to “Default”.
After making this change, you will find that the text editor is much easier on the eyes. It’s important to note that the test was conducted on SQL Server 2016 Management Studio RC3 (Version 13.0.14000.36), and it’s uncertain if Microsoft will change the default color scheme by the final release.
These changes in SSMS are just a glimpse of the interesting updates coming to SQL Server. We would love to hear your thoughts and experiences with these changes. Have you made any adjustments to the default settings? Let us know!