What is New in SQL Server 2016 Management Studio

05 Nov

Hello my followers today i will speak in very good Point in SQL Server 2016 all we are working on SSMS (SQL Server Mangment Studio) and we should now the options in this tools and what is the new on it so today we will show the new features in SQL Server 2016 Management Studio then later will explain deeply this features if it needed

  • In the installation you find new tape for Tempdb Configuration 
  • Check for Update : ( Now we can update the SQL Server Management Studio alone you will find it under tools )
  • 1- SSMS Update
  • Save Open Queries in SQL Server Management Studio (Tools > options > Query Execution > Prompt to save unsaved T-SQL Query Windows on Close)

Save unsaved T-SQL

  • New Default Databases ( Now after installing SQL Server 2016 CTP 2.4 you can find new 3 Databases)

1. DWConfiguration
2. DWDiagnostics
3. DWQueue

Under this database you will find some tables started with Prefix (pdw_) this table related to Polybase New Features

new Deafult Databases

  • EXTERNAL TABLE { now under tables you will find new Category EXTERNAL TABLE before we have (System tables , File table ) EXTERNAL TABLE related to Polybase New Features For more information click here.

Excternal Tables

  • Always Encrypted Key in SQL Server 2016 : Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to SQL Server. For more information Check this link
  • Always Encrypted key
  • SECURITY POLICY : it is related to the new Feature Row level Security For more information go here

Always Encrypted key

this not all the new Features in SSMS we have another Features but need to be enabled Like Query Store .

Follow Us :

LinkedIn Slideshare ,Youtube Channel.MSDN POSTS ,Facebook WHO WE ARE


Posted by on November 5, 2015 in SQL Server 2016


Tags: , , , , , ,

7 responses to “What is New in SQL Server 2016 Management Studio

  1. Diaa Alsalehi

    November 5, 2015 at 6:18 PM

    Many thank for you for this information
    Waiting for more information about SSMS 2016

    • Mustafa EL-Masry

      November 5, 2015 at 6:35 PM

      Thanks Diaa for your valuable comment and for your follow sure I will write lot of posts in Sql server 2016 in the new features follow me specially this weekend I will publish good posts

  2. Mohammed Iftequar Ahmed

    November 9, 2015 at 12:33 AM

    Thanks it’s really gud information.

  3. Vasa

    November 12, 2015 at 1:19 AM

    Many thank for you for this information

    • Mustafa EL-Masry

      November 12, 2015 at 1:27 AM

      Welcome Vasa in our Sql server community keep following us to know more features and restrictions in SQL SERVER 2016


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.