Exploring SQL Server 2016, Part 2: Performance Enhancements

with expert Thomas LeBlanc

Enhancements in performance are an important reason to upgrade to SQL Server 2016. Learn about changes in manageability features and execution, as well as query plans with live query statistics before taking a look at Powershell and integration with automation, and discovering 3 new groups of commandlets. Continue your exploration with a focus on in-memory table improvements, columns store index changes, and the new temporal tables, then learn about some additional improvements including enhancements of optimizer, cloud first development, and testing in the cloud.

Course Outline