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

YouTube

Modernizing SQL Server the Right Way

PASS Data Community Summit via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore the process of modernizing SQL Server in this comprehensive conference talk from the PASS Data Community Summit. Learn when to upgrade, how to certify databases, and understand compatibility levels and deprecated functionalities. Discover three essential free Microsoft tools for simplified upgrades: Microsoft Assessment and Planning Toolkit (MAP), Database Migration Assistant (DMA), and Database Experimentation Assistant (DEA). Gain insights into post-migration steps and the Query Tuning Assistant. Delve into topics such as database compatibility level behavior, functional change protection, and reliable upgrade strategies. Understand the breakdown of modernization tools and prepare for a smooth transition to SQL Server 2017 or 2019.

Syllabus

Intro
Modernizing SQL Server The Right Way
Winter is coming...
Is it the right time to modernize?
Database Compatibility Level behavior Supported
Functional change protection Clarifying the caveats
Reliable Upgrades
Discover with MAP Toolkit
Assess & Convert with DMA
Test & Optimize with DEA
Upgrading DB Compat until recently
Modernization Tools Breakdown

Taught by

PASS Data Community Summit

Reviews

Start your review of Modernizing SQL Server the Right Way

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.