Description

• Module 1: Introduction to Upgrading SQL Server

  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
  • Module 2: SQL Server Discovery using MAP

    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
    • Module 3: Assess and convert SQL Server databases using the Data Migration Assistant (DMA)

      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
      • Module 4: Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)

        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
        • Module 5: Use the SQL Server Query Tuning Assistant

          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