New features are available in SQL Server 2016

First of all, Microsoft has still not released any version of this product to date, and has just introduced some of its features at its 2014 and 2015 sessions. In this tutorial, I’m going to look at some of the new SQL Server 2016 capabilities in performance or performance improvements. I would like to point out that some of these features are based on Windows Azure which, unfortunately, is not possible due to sanctions and … in Iran.

But these 7 new features are available in SQL Server 2016

1- Increase the In-Memory OLTP power using the NonClustered Column Store Index

2- Query Store

3. Support JSON in SQL Server 2016

4- Temporal Database

5. Support for Windows Server 2016

6. Improved Cache

7. Create Load Balancer for secondary pairs in Always-ON

To hear the full description of these seven new features, download the link below the free and farsi audio file