未加星标

Top 10 exciting new features in SQL Server Management Studio 2016

字体大小 | |
[数据库(mssql) 所属分类 数据库(mssql) | 发布者 店小二03 | 时间 2016 | 作者 红领巾 ] 0人收藏点击收藏
[This article was originally posted in CodeProject ] 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


Top 10 exciting new features in SQL Server Management Studio 2016
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”


Top 10 exciting new features in SQL Server Management Studio 2016
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-


Top 10 exciting new features in SQL Server Management Studio 2016

However, you can also check manually for updates availability.

Tools - “Check for Updates…”


Top 10 exciting new features in SQL Server Management Studio 2016

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.


Top 10 exciting new features in SQL Server Management Studio 2016
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


Top 10 exciting new features in SQL Server Management Studio 2016
Top 10 exciting new features in SQL Server Management Studio 2016
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”


Top 10 exciting new features in SQL Server Management Studio 2016
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.


Top 10 exciting new features in SQL Server Management Studio 2016
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"


Top 10 exciting new features in SQL Server Management Studio 2016
Example:

Executed following query by unchecking the checckbox.

Hide Copy Code

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

The output while copying to notepad was as follows-

Hide Copy Code

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

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

Hide Copy Code

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 asyou 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 showTooltip 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..."


Top 10 exciting new features in SQL Server Management Studio 2016
Top 10 exciting new features in SQL Server Management Studio 2016

To know rest of the features , please visit my original article on CodeProject

Thanks for reading. Awaiting your feedback

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

分页:12
转载请注明
本文标题:Top 10 exciting new features in SQL Server Management Studio 2016
本站链接:http://www.codesec.net/view/480064.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(37)