Export (0) Print
Expand All

What's New in SQL Server 2016

Updated: June 24, 2015

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

This topic provides links to info about the new features in SQL Server 2016 Community Technology Preview 2 (CTP2).

Benefits of this release:

  • Enhanced in-memory performance provides up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics.

  • New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes.

  • Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes.

  • Built-in advanced analytics provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database.

  • Business insights through rich visualizations on mobile devices with native apps for Windows, iOS and Android.

  • Simplify management of relational and non-relational data by querying both with T-SQL using PolyBase.

  • Faster hybrid backups, high availability and disaster recovery scenarios to back up and restore your on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure.

For more info about SQL Server 2016 Community Technology Preview 2 (CTP2), or to download the SQL Server 2016 Community Technology Preview 2 (CTP2) data sheet, see SQL Server 2016 Preview.

Microsoft SQL Server 2016 data sheet
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft