Learn Live - SQL Migrations - Part 1 - Discovery, Assessment and Remediation

Follow on Microsoft Learn:


In this session, you will learn how to discover and assess your SQL Server environment as well as remediate issues before migrating to Azure. With many tools, services and options available, the presenters will draw upon their experience of working with hundreds of organisations to provide you with the latest and most efficient options to bring your SQL workload to Azure.

---------------------

Learning objectives

- Understand what tools to use to discover and assess a SQL Server workload.
- Learn how to approach the remediation of migration blocking issues.
- Learn how to right size your environment prior to migrating to Azure SQL.

---------------------

Chapters
--------
00:00 - Welcome
02:51 - SQL Migration 'Collection'
03:51 - Learning Objectives
06:44 - Introduction
13:46 - What is Azure SQL
19:34 - Choosing a target
28:16 - Discovery & Assessment
31:02 - Discovery Tools
31:21 - Demo: MAP Toolkit
36:28 - Demo: Data Migration Assistant (DMA)
47:30 - Demo: Choosing a SKU
54:52 - Demo: Azure Data Studio
1:06:06 - Remediation
1:15:30 - Summary

---------------------

Presenters

Ben Harding
FastTrack for Azure Engineer
Microsoft

Kruti Mehta
Senior Customer Engineer for FastTrack for Azure
Microsoft

Moderators

Nathan Widdup
Senior FastTrack Engineer
Microsoft


Osamu Hirayama
Principal Customer Engineer
Microsoft

[dataArtists]

Great summary of the Azure SQL migration tools available. Highly appreciate the centralization into the GitHub repository for the outline of process and links to more in-depth resources. Now must watch 2nd part, digest and practice, practice, practice! 👍

[TravisCBarker]

Enjoyed, but a lot of repetition. Could have been more focused and structured.