Microsoft SQL Server 2016 (MSSQL 2016)

Eintrag zuletzt aktualisiert am: 04.07.2017

Microsoft SQL Server 2016 ist der Nachfolger von Microsoft SQL Server 2014.

Termine

CTP1-Version
CTP2-Version
CTP2.2-Version: 22.7.2015

Neue Features:

Always Encrypted
Stretch Database
Real-time Operational Analytics & In-Memory OLTP
Built-in Advanced Analytics, PolyBase and Mobile BI
temporal tables: SQL Server 2016 Community Technology Preview 2 (CTP2) introduces support for temporal tables as a database feature that provides built-in support for provide information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. Temporal is a database feature that was introduced in ANSI SQL 2011

Additional security enhancements for Row-level Security and Dynamic Data Masking to round out our security investments with Always Encrypted.
Improvements to AlwaysOn for more robust availability and disaster recovery with multiple synchronous replicas and secondary load balancing.
Native JSON support to offer better performance and support for your many types of your data.
SQL Server Enterprise Information Management (EIM) tools and Analysis Services get an upgrade in performance, usability and scalability.
Faster hybrid backups, high availability and disaster recovery scenarios to backup and restore your on-premises databases to Azure and place your SQL Server AlwaysOn secondaries in Azure.

mehr: https://msdn.microsoft.com/en-us/library/bb500435(v=sql.130).aspx