What's New in SQL Server 2016
Check this out. Below
is the summary of SQL Server 2016 new features.
1
Query Store
a)
It contains query work load history .
b) It can enforce polices to direct SQL Server Query processor to
execute in a specific manner
c) Captures
queries, query plans, runtime statistics, etc.
d)
New system views are added to support Query store
e) Helps
system-wide or database level performance analysis and troubleshooting
2 Column Store
a) Column
store index on your in-memory table for higher throughput
b) Columnstore indexes achieve up to 10x greater data compression
than row store indexes. This greatly reduces the IO required to execute
analytics queries and therefore improves query performance
3
Live Query Statistics
a) Live
Query plans with system resources consumption such as CPU and memory for all
running queries in the plan
b) It helps
you watch change of statistics during query execution
c) You can drill down further into live running queries from its
query plan
4 Row Level Security
a) Security can be defined on a complete row based on the characteristics of the user executing a query (e.g. group membership or
execution context)
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 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
7 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
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
- Windows
- IOS
- Android
- HTML5
11 Data Stretch to MS Azure
a) Stretch
the data to the cloud
- Remote data archive (DBA)
- Power BI Scenarios with SSIS
- Stretch tables into Azure
b) Enhanced
Backup/restore for stretched databases
12 SSDT (All in One)
This is a well-researched article which you have shared here about SQL server. This is a very informative and useful article. This type of advice is not easy to find so, thanks for this information. Unmetered Server
ReplyDeleteVery interesting. Your article is so convincing that I can never stop myself from saying anything about it. You are doing a great job, thanks for sharing such a great blog. vps server
ReplyDelete