Overview
This course focuses on the post-migration/upgrade step in SQL Server migration, particularly from older versions to modern versions like SQL Server 2017/2019. The goal is to reconcile data accuracy, address completeness issues, and optimize query performance on the newer Database Engine. Participants will learn the recommended upgrade process to minimize risks and leverage features like Query Store, Automatic Tuning, and QTA for automation. The course is designed for SQL Server professionals looking to enhance their skills in database migration and optimization.
Syllabus
SQL Server Migration: The Last Mile - Pedro Lopes
Taught by
PASS Data Community Summit