What's New in SQL Server 2016

Below is the summary of SQL Server 2016 new features. 

SQL SERVER 2016

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

10 comments:

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

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

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

    ReplyDelete
  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

    ReplyDelete
  5. Infycle Technologies, the best software training institute in Chennai offers the leading Python course in Chennai for tech professionals, freshers, and students at the best offers. In addition to the Python course, other in-demand courses such as Data Science, Cyber Security, Selenium, Oracle, Java, Power BI, Digital Marketing also will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.

    ReplyDelete
  6. Infycle Technologies, the top software training institute and placement center in Chennai offers the Best Digital Marketing Course in Chennai | Infycle Technologies for freshers, students, and tech professionals at the best offers. In addition to Digital Marketing, other in-demand courses such as DevOps, Data Science, Python, Selenium, Big Data, Java, Power BI, Oracle will also be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.

    ReplyDelete
  7. Infycle Technologies, the No.1 software training institute in Chennai offers the Selenium course in Chennai for tech professionals, freshers, and students at the best offers. In addition to the Selenium, other in-demand courses such as Python, Big Data, Oracle, Java, Python, Power BI, Digital Marketing, Cyber Security also will be trained with hands-on practical classes. After the completion of training, the trainees will be sent for placement interviews in the top companies. Call 7504633633 to get more info and a free demo.

    ReplyDelete