Exploring SQL Server 2016, Part 2 of 5: Performance Enhancements

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.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.