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

7 thoughts on “What is New in SQL Server 2016 Management Studio

Leave a Reply to Mohammed Iftequar Ahmed Cancel reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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.