Functional change protection Clarifying the caveats
11
Minimize Risk with the Database Migration Guide
12
Reliable Upgrades
13
Discover with MAP Toolkit
14
Assess & Convert with DMA
15
Test & Optimize with DEA
16
I moved the data, am I done?
17
Upgrading DB Compat until recently
18
Query Tuning Assistant (QTA) Workflow
19
Modernization Tools Breakdown
20
Session takeaways
Description:
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.