What is New in SQL Server 2016 Management Studio

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 )
• 
• Save Open Queries in SQL Server Management Studio (Tools > options > Query Execution > Prompt to save unsaved T-SQL Query Windows on Close)

• 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

• 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.

• 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
• 
• SECURITY POLICY : it is related to the new Feature Row level Security For more information go here

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