- Module 1: Introduction to Upgrading SQL Server
- Identify databases for upgrade to a newer version of SQL Server
- Document the databases in your environment
- Choose the appropriate method for upgrading a database
- Test a database following an upgrade
- Tune queries after migration to maintain performance
- Module 2: SQL Server Discovery using MAP
- Decide if MAP is the best tool to use for a given administration task
- Install MAP on your client machine
- Connect to instances of SQL Server
- Automate the collection of inventory data about your database landscape
- Module 3: Assess and convert SQL Server databases using the Data Migration Assistant (DMA)
- Decide if the DMA is the best tool to use for a given administration task
- Install the DMA on your client machine
- Identify compatibility issues prior to upgrade
- Upgrade a database using the DMA
- Module 4: Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)
- Decide if DEA is the right tool for your workload testing
- Install DEA on your client machine
- Test a typical workload on an upgraded database
- Review the results of a trace analysis report
- Module 5: Use the SQL Server Query Tuning Assistant
- Decide if QTA is the right solution for them.
- Use the Query Store to assess query performance.
- Understand how QTA works to find regressing queries.
- Tune queries after migration to maintain performance
In this module, you will:
In this module, you will:
In this module, you will:
In this module, you will:
In this module, you will:
