SQL Server Migration - The Last Mile

Explore the critical post-migration and upgrade process for SQL Server databases in this comprehensive conference talk. Learn how to reconcile data accuracy and completeness, and uncover query performance issues when upgrading from older versions like SQL Server 2008/2008R2 to modern versions such as SQL Server 2017/2019. Discover the recommended upgrade process that minimizes risk and leverages the latest query optimization features. Delve into automated tools and features like Query Store, Automatic Tuning, and QTA that streamline this crucial step. Gain insights on handling potential workload regressions due to Query Optimizer changes over the years. As part of the Modernizing with SQL Server 2019 Learning Pathway, this session provides valuable knowledge for database administrators and developers seeking to optimize their SQL Server migration strategies.

SQL Server Migration: The Last Mile - Pedro Lopes