SQL
Server 2016 is the biggest leap forward in Microsoft data platform
history. There is a lot of buzz around SQL Server 2016. Gain real time insights
across your transaction and analytical data with a salable database platform
that has everything built in, from unparalleled in-memory performance, new
security innovations and high availability, to advanced analytics that make
mission-critical applications intelligent.
Always Encrypted - SQL
Server 2016 has introduced new feature that is Always Encrypted. If this feature
is enabled in your SQL Server then all data would be in encrypted mode always.
By this feature all the confidential data would be save and we can apply proper
access control of data in proper mode.
Dynamic Data Masking - This
is very interesting feature of SQL Server 2016 edition. If you want to hide
some part of any data to be hidden by for some one and some part to be shown to
some one then easily you can make this done using this feature. e.g. you have
mobile number stored in database and you want to hide all digits except last 2
digits then easily you can perform this using Dynamic
Data Masking feature.
JSON Support - JSON
stands for Java Script Object Notation. Now using this feature of SQL Server
2016 you can easily interchange the data in JSON format.
TempDB Database Files - During setup, you can configure the number of tempdb database
files, initial size, auto growth and directory placement using the new UI input
control on the Database Engine Configuration - TempDB section of SQL Server
Installation Wizard.
Query Store - If you are into examining execution plans than you will like the
new Query Store feature. Currently in versions of SQL Server prior to 2016 you
can see existing execution plans by using dynamic management views (DMVs). But,
the DMVs only allow you to see the plans that are actively in the plan cache.
You can’t see any history for plans once they are rolled out of the plan cache.
With the Query Store feature, This is a great addition and will allow you to
now track execution plans performance for your queries over time.
Row Level Security - You can apply row level security in SQL Server 2016