Click here to Skip to main content
12,689,801 members (24,525 online)
Click here to Skip to main content
Add your own
alternative version

Stats

5.9K views
6 bookmarked
Posted

Top 10 exciting new features in SQL Server Management Studio 2016

, 23 Aug 2016 CPOL
Rate this:
Please Sign up or sign in to vote.
Introduction of new useful features in SSMS 2016

Introduction

This article is an effort to list out few exciting improvements those has been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work and more convenient to use the SSMS.

1. Color Theme

With SSMS 2016, now you can choose your preferred color theme, a feature similar to that in Visual Studio. For now, you can choose one from 2 available color themes – Blue or Light, Blue being the default theme.

Tools - Options - Environment - General - Color theme

https://www.codeproject.com/KB/Articles/1120200/1.png

2. Hide Save Query Window Prompt

In earlier versions of SSMS, you can’t ignore the save query windows prompt that comes when you want to close either an unsaved query window or the SSMS itself. While this restriction is actually meaningful to have in SSMS but with SSMS 2016, you can now customize to hide those prompts as per your preference.

Tools - Options - Query Execution - SQL Server - General - “Prompt to save unsaved T-SQL query windows on close”

https://www.codeproject.com/KB/Articles/1120200/2.png

3. Update from SSMS Menu

SSMS 2016 automatically checks for any updates available when it is online and a toast notification comes when there is an update available something as following screenshot-

https://www.codeproject.com/KB/Articles/1120200/6.png

However, you can also check manually for updates availability.

Tools - “Check for Updates…”

https://www.codeproject.com/KB/Articles/1120200/3.png

You can disable automatic checking for updates by unchecking the checkbox in the popup window that appears when you click "Check for Updates..." as described above.

https://www.codeproject.com/KB/Articles/1120200/4.png

4. Search Options

Confused with so many new features and steps to open the window to configure them? Don’t worry, SSMS now has the Search Options which is one of much requested feature. You can search with the feature name or a keyword.

Tools - Options

https://www.codeproject.com/KB/Articles/1120200/7.png

https://www.codeproject.com/KB/Articles/1120200/8.png

5. Highlight Current Line

How many of the times you feel lost while modifying an existing huge query or stored procedure in SSMS? The problem occurs when your SQL statements are very long and you haven’t configured text editor to wrap words automatically and then when you use the horizontal scrollbar to scroll the content, it becomes difficult to identify which the line you wanted to modify or check. Now, with SSMS 2016, an outline will follow your cursor where ever you placed it. That makes easy to identify the line you are currently working with. The best part is, it can be configured.

Tools - Options - Text Editor - General - “Highlight current line”

https://www.codeproject.com/KB/Articles/1120200/9.png

6. Scroll & Zoom Execution Plan Window

There are also few improvements done on the Execution Plan window. Now you can zoom the content of this window using shortcut CTRL + Scroll. You can also scroll the content of the window by dragging the content with mouse.

https://www.codeproject.com/KB/Articles/1120200/10.png

7. Retain Carriage Return and Line Feeds on Copy or Save

It may seem to you as a weird default behavior. In SSMS 2016, if you copy any result from the Result Grid and paste it in a notepad or any text editor, you will notice that the carriage return and line feeds are not in place. However, this can also be configured.

Tools - Options - Query Results - SQL Server - Results to Grid - "Retain CR/LF on copy or save"

https://www.codeproject.com/KB/Articles/1120200/11.png

Example:

Executed following query by unchecking the checckbox.

SELECT 'This is a demo text
for test purpose only' AS demotext

The output while copying to notepad was as follows-

demotext
-------------------
This is a demo text  for test purpose only

Now, executed the same query after checking the mentioned checkbox and got result as -

demotext
------------------
This is a demo text
for test purpose only

 

8. Advanced Scroll Bar

If you have used Visual Studio, then probably you are already aware of such feature. With SSMS 2016, you can use "bar mode" or "map mode" for the vertical scroll bar in the query window. 

  • Bar Mode : This is the default and normal vertical scroll bar same as you can see in the previous versions.
  • Map Mode: This is new and source overview can be viewed on the scroll bar which can again be configured as -
    • Off : Source Overview will not be visible
    • Narrow: Overview with minimum width
    • Medium: Wider than previous
    • Wide: Widest scrollbar with overview

You can also configure to show Tooltip on hover or scroll using checkbox "Show Preview Tooltip"

Tools - Options - Text Editor - All languages - Scroll Bars - Behavior

You can also open the configuration window by right clicking on the vertical scroll bar and then clicking "Scroll Bar Options..."

https://www.codeproject.com/KB/Articles/1120200/12.png

https://www.codeproject.com/KB/Articles/1120200/13.png

9. Mapped Zooming in Query & Messgage Window

With SSMS 2016, the zooming of the Query Window content and Message Window content are now mapped while zooming. For example, if we zoom the content of the query window to 200% then the content of the messge window will automatically zoom to 200%. With previous versions of the SSMS it was possible to zoom them individually. It seems to be not yet available for configuration. Not sure if everybody is going to accept this change.

https://www.codeproject.com/KB/Articles/1120200/14.png

10. Quick Launch

Again this is something already available in Visual Studio. You can quickly launch your tasks through a panel at the top right of the SSMS window. It looks like a search tool but it is far more than that. You can open any tasks from available in Menu as well as Options. The task can be anything like creating new project, opening new query window, opening configuration window for any setting etc.

https://www.codeproject.com/KB/Articles/1120200/15.png

https://www.codeproject.com/KB/Articles/1120200/16.png

https://www.codeproject.com/KB/Articles/1120200/17.png

 

Conclusion

Hope, these tips will help you developing your applications faster. Will love to hear from you :)

History

24th Aug 2016: First Publish

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Suvendu Shekhar Giri
Software Developer
India India
With more than 4 years of experience in Microsoft Technologies like C#, ASP.Net, SQL Server and various web technologies like HTML, CSS, Javascript, JQuery etc.

I have a Master’s Degree in Computer Science and also a Microsoft Certified Professional in “Programming in HTML5 with JavaScript and CSS3”.

I always encourage learning and sharing of ideas because I believe “An idea is of no worth if it dies inside you”. Active member in various community sites and activities.

You may also be interested in...

Pro
Pro

Comments and Discussions

 
Praise5 Pin
Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)29-Aug-16 22:30
protectorTadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)29-Aug-16 22:30 
GeneralRe: 5 Pin
Suvendu Shekhar Giri30-Aug-16 9:18
mvpSuvendu Shekhar Giri30-Aug-16 9:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170113.4 | Last Updated 24 Aug 2016
Article Copyright 2016 by Suvendu Shekhar Giri
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid