Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Server Migration - The Last Mile

PASS Data Community Summit via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.

Syllabus

SQL Server Migration: The Last Mile - Pedro Lopes

Taught by

PASS Data Community Summit

Reviews

Start your review of SQL Server Migration - The Last Mile

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.