Share via

SQL Server 2016: What's New

  • Article
  1. Isolation level Support:

Transactional consistent analytics queries with no locks is enabled. Columnstore indexes support Snapshot isolation level (RCSI) and snapshot isolation (SI) is supported.

  1. Stretch Database

This new technology allows you to dynamically stretch your warm and cold transactional data to Microsoft Azure, so your operational data is always at hand, no matter the size, and you benefit from the low cost of Azure.  You can use Always Encrypted with Stretch Database to extend data in a more secure manner for greater peace of mind.

In progress ...