SQL Server upgrades

In this module, you will:

• 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

In this module, you will:

• 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

In this module, you will:

• 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

In this module, you will:

• 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

In this module, you will:

• 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

• Introduction
• Decide if an upgrade is right for your task
• Discover your database landscape
• Assess and convert your databases
• Test your migration
• Knowledge check - upgrade SQL Server versions
• Tune queries post migration
• Knowledge check - upgrade SQL Server tools
• Summary

• Introduction
• Decide if MAP is right for your task
• Install the MAP toolkit
• Collect and assess inventory data
• Exercise - Install the Microsoft Assessment and Planning Toolkit
• Exercise - Collect and assess inventory data
• Summary

• Introduction
• Decide if the Data Migration Assistant (DMA) is right for your task
• Install the DMA
• Identify compatibility issues
• Upgrade a database
• Create Azure SQL virtual machine
• Exercise: Install the Data Migration Assistant (DMA)
• Exercise: Identify compatibility issues
• Exercise: Upgrade a database
• Summary

• Introduction
• Decide if DEA is right for your task
• Install DEA
• Configure a new capture
• Review a trace analysis report
• Exercise - Install the Database Experimentation Assistant
• Exercise - Configure a new capture with DEA
• Exercise - Review a trace analysis report in DEA
• Summary

• Introduction
• Decide if QTA is right for you
• Get started with QTA
• Tune queries with QTA
• Knowledge check - Use the SQL Server Query Tuning Assistant
• Summary