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
Great Article
ReplyDeleteIEEE Projects on Information Security
Project Centers in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
ReplyDeleteThank you for your guidance to with upgrade information. Keep posting...!
Pega Training in Chennai
Pega Developer Training
Advanced Excel Training in Chennai
Linux Training in Chennai
Power BI Training in Chennai
Tableau Training in Chennai
Graphic Design Courses in Chennai
Oracle Training in Chennai
Oracle DBA Training in Chennai
Social Media Marketing Courses in Chennai
Spark Training in Chennai
Thanks for Sharing This Article.It is very so much valuable content. oracle training in chennai
ReplyDeleteThanks for giving me good information. This blog is very beneficial for me.
ReplyDeletetutorials on java
java fundamentals tutorial
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.
ReplyDeleteInfycle 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.
ReplyDeleteInfycle 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.
ReplyDeleteInfycle Technologies offers couples for care and technology in addition to Python Training in Chennai, 100% of the internship class will be prepared. After completing the training, the participants will be sent to the upper MNCs interviews. Call 750633333 to get more information and get a free display.
ReplyDeleteAwesome blog. Thanks for sharing such a worthy information....
ReplyDeleteDOT NET Training in Bangalore
Dot Net classes in Pune