Select Page

Top 3 SQL Server Management Studio Enhancements with SQL Server 2016

Author: Eric Russo | | July 13, 2016

My journey working with various versions of SQL Server has me looking more scrupulously at each new release that hits the shelves. When SQL server 2016 was introduced with the first CTP bits and later the RC bits, I was surprised to see a number of things added that caught my eye. This blog is dedicated to the feature that caught my eye first: the new SQL Server Management Studio look and feel.

On the outset, it looks very similar to the Visual Studio shell. If you’ve never used them, a lot of things will look fresh, but to those of us who have, the interface is very familiar. The integration of VS Shell makes this new version powerful for SQL developers. In this blog we will discuss some of the other neat capabilities that I also found powerful.

First, it is easy to see that once you open up a large script file, the cursor location is nicely highlighted using a grey marker. This is quite subtle but gives a neat highlighter to the solution; it’s tough to miss. Here’s how it looks:

The next notable feature added as part of SSMS is the ability to know what is going on in a big script. If you right-click the right scroll bar and open the options, you will be able to get a narrow view of your entire script file. The best part is, it highlights different areas in different colors. “Yellow” markers indicate that there is code that is not yet saved. “Red” markers show we have some syntax errors and so on.

If you hover over these markers, as featured below, you can look at the actual code that is causing that error in the tool tip window (right arrow). And if we click on it, it will take us to the actual code block too. This will look like:

I personally feel these are powerful and interesting capabilities with the SQL Server Management Studio 2016. If you are looking at the Scroll bar settings, the options include:

Try to play around with each of the check boxes – you will be surprised to see all the different flavors. Go ahead and optimize and customize the experience to your own preferences.

Do let me know if you changed any of these. Do you feel these are interesting additions? I would love to get your thoughts as I felt these were fresh additions to SSMS.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.

Vijay Muthu | February 4, 2021

Using Nulls in DB2

If a column “value” can be null, it can mean one of two things: the attribute is not applicable for certain occurrences of the entity, or the attribute applies to all entity occurrences, but the information may not always be known.

Craig Mullins | April 6, 2015

How To Fix Log Shipping Failure Errors In SQL Server

Learn how to fix common Log Shipping Failure errors in SQL Server. Includes step-by-step instructions, screenshots, and software script.

Eric Russo | August 10, 2016

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.