
Modernize Your SQL Server Estate to Azure SQL is a hands-on workshop that equips database professionals with the skills to assess, migrate, optimize, and modernize SQL Server workloads on Azure. Participants learn how to evaluate migration readiness, analyze compatibility and costs, select the appropriate Azure SQL destination, and implement migration strategies using Microsoft-native tools and services. Through practical labs, learners design resilient, cost-optimized solutions, implement security and governance controls, and explore AI-ready Azure SQL capabilities including vector search and embeddings, enabling a secure, scalable, and future-ready data platform.
MS Course ID: 02025
Last Updated: Oct 5, 2026
Database Administrators, Database Developers and Infrastructure Engineers
Working knowledge of SQL Server and Transact-SQL,Azure fundamentals
Module 1: Review Azure Solution Assessment Results
Module 2: Migration Tooling and Best Practices
Lab 1: Assess migration readiness for a SQL Server Estate
Lab 2: Select the Right Azure SQL Destination
Lab 3: Design a migration strategy
Lab 4: Estimate Azure migration costs
Module 3: Azure SQL Destination Prioritization
Module 4: Business Continuity, Disaster Recovery, and Cost Optimization
Lab 5: Deploy Azure SQL migration targets
Lab 6: Migrate databases to Azure SQL database
Lab 7: Migrate Databases to Azure SQL Managed Instance
Lab 8: Configure business continuity and optimize costs
Module 5: AI-Native Data Platform Design
Module 6: Governance, Security, and Operations
Lab 9: Secure Azure SQL workloads
Lab 10: Implement governance and data protection
Lab 11: Enable AI-Ready capabilities in Azure SQL