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

YouTube

Modernizing SQL Server

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 about free Microsoft tools designed to ensure successful SQL Server upgrades. Discover the benefits of database compatibility level-based certification, understand functional change protection, and minimize risks using the Database Migration Guide. Delve into reliable upgrade strategies, including the use of MAP Toolkit for discovery, DMA for assessment and conversion, and DEA for testing and optimization. Gain insights into the Query Tuning Assistant workflow and understand key modernization tools. Walk away with valuable takeaways to streamline your SQL Server modernization efforts.

Syllabus

Intro
Technical Assistance
Thank you to our Presenting Sponsors
Winter is coming...
Is it the right time to modernize?
Database Compatibility Level based certification
Key Benefits
Microsoft stands by DB Compat based certification
Database Compatibility Level behavior
Functional change protection Clarifying the caveats
Minimize Risk with the Database Migration Guide
Reliable Upgrades
Discover with MAP Toolkit
Assess & Convert with DMA
Test & Optimize with DEA
I moved the data, am I done?
Upgrading DB Compat until recently
Query Tuning Assistant (QTA) Workflow
Modernization Tools Breakdown
Session takeaways

Taught by

PASS Data Community Summit

Reviews

Start your review of Modernizing SQL Server

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.