What's New in SQL Server 2016

Below is the summary of SQL Server 2016 new features. 


What’s New?

1-     Query Store
a)      Captures queries, query plans, runtime statistics, etc.
b)      Can enforce polices to direct SQL Server Query processor to execute in specific manner
c)      Contains query work load history
d)      Helps system-wide or database level performance analysis and troubleshooting
e)      New system views are added to support Query store
2-     Live Query Statistics
a)      Live Query plans with system resources consumption such as CPU, memory for all running queries in the plan
b)      You can drill down further into live running queries from its query plan
c)      Helps you watch change of statistics during query execution
3-     Native JSON Support
a)      Language - Independent data-interchange format
b)      Modern Web and Mobile Applications are using it
c)      Alternate XML
d)      Parsing done via Standard JavaScript function
e)      Easier and faster than XML parsing
f)       Several new T-SQL constructs introduced to facilitate JSON
4-     Temporal Database support
a)      Keep track data in the database (Current and historical)
b)      Provides ability to query the table snapshot for any point in time
c)      Data can be restored to any known state without downtime
d)      Help regulate compliance and audit
e)      Help implementing slowly changing dimension
5-     Always Encrypted
a)      Encrypted data at rest and in motion
b)      Encryption master key resides at Application
c)      No application change required (Simple SSIS Package convergence)
6-     Row Level Security
a)      Security can be defined on a complete row
7-     Column Store
a) Column store index on your in-memory table for higher throughput
8-     Polybase
a) Querying relational and non-relational data
b) Example: SQL + Hadoop  (With the help of external table)
9-     Advance Analytics
a)      Data Scientists can get model or templates from MS Azure where others are sharing and    
hook it up with their real time data for data examining
10-  BI on Mobile Devices
a)      All BI on Mobile: (New) – DataZen App
                                               I.          Windows
                                             II.          iOS
                                            III.          Android
                                            IV.          HTML5

11-  Data Stretch to MS Azure
a)      Stretch the data to the cloud (Turn the feature on and it works with Always Encrypted)
a.      Remote data archive (DBA)
b.      Stretch tables into Azure
c.      Power BI Scenarios with SSIS
b)      Enhanced Backup/restore for stretched databases

12-  SSDT (All in One)

What's new in SQL Server 2016


  1. Thanks for Sharing This Article.It is very so much valuable content. oracle training in chennai

  2. Thanks for giving me good information. This blog is very beneficial for me.
    tutorials on java
    java fundamentals tutorial

  3. Infycle Technologies offers the Best Data training in chennai and is widely known for its excellence in giving the best Data Science Certification course in Chennai. Providing quality software programming training with 100% placement & to build a solid career for every young professional in the software industry is the ultimate aim of Infycle Technologies. Apart from all, the students love the 100% practical training, which is the specialty of Infycle Technologies. To proceed with your
    career with a solid base, reach Infycle Technologies through 7502633633.

  4. Did you want to set your career towards Oracle? Then Infycle is with you to make this into reality. Infycle Technologies gives the combined and best Oracle course in Chennai, which offers various stages of Oracle such as Oracle PL/SQL, Oracle DBA, etc., along with 100% hands-on training guided by professional tutors in the field. Along with that, the mock interviews will be given to the candidates to face the interviews with complete confidence. Apart from all, the candidates will be placed in the top MNC's with an excellent salary package. To get it all, call 7502633633 and make this happen for your happy lifeBest Oracle Course in Chennai | Infycle Technologies