1. Row Level Security
One native feature that SQL Server has lacked is Row Level Security. This feature has been available in other database offerings for some time now, so it is good to see Microsoft has finally included this. The initial implementation does have some limitations, but Microsoft is sure to improve the feature over time.
2. More CPU
By offering support for up to 24 cores of processing power, you are able to process data quicker and more efficiently. And with intuitive management tools, SQL Server 2016 will help reduce storage cost, simplify networking, and extend security.
3. Stretch Database
The growth of public cloud platforms has also increased the demand for balancing application workloads between on-premise environments and those in the public cloud. The Stretch Database feature provides the best of both worlds, in a sense. For instance, you can now move some parts of your tables to the Azure SQL Database in the cloud. When you query those tables, the query optimizer splits the workload between the local data and the data in the cloud.
4. JSON Support
SQL Server 2016 adds support for one of the most commonly used languages in web applications today: Java Script Object Notation (JSON). As the use of JSON has grown, so to has the support for it in most database servers. To allow for quick movement into tables, Microsoft utilized the same format for JSON as they did for XML support.