Are you thinking about migrating to Microsoft SQL Server 2016 but want to know its benefits? If so, you have reached the right place! This latest edition of Microsoft’s database server delivers end-to-end data management and business analytics and includes mission-critical intelligence from complex workloads. With each version, Microsoft adds yet another layer to the already-rich feature set.
Here are the top 4 features added to SQL Server 2016:
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.