Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

In SQL Server 2017, automatic plan correction was added, which allows for the database engine to automatically use the "last known good plan" for a query that has suddenly regressed in performance.

Every release of SQL Server promises increased performance, better security and improved business intelligence. You get all of that with SQL Server 2016, plus other strategic options such as cloud ...