Microsoft SQL Server 2016 ist der Nachfolger von Microsoft SQL Server 2014.
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.