SQL Managed Instance - A Fully Managed SQL Server in the Cloud

Explore the advantages and best practices of migrating SQL Server workloads to the cloud with SQL Managed Instance in this comprehensive conference talk from PASS Data Community Summit. Learn about the latest enhancements, simplified networking and security setup, and new purchasing options that make SQL Managed Instance an attractive choice for cloud migration. Discover how to increase productivity and achieve cost savings through managed cloud services. Gain insights into cloud migration best practices, service tier comparisons, architecture options, disaster recovery strategies, and the step-by-step database migration process. Understand the benefits of instance pools, reserved capacity, and Azure Hybrid Benefit to maximize cost savings. By the end of this talk, you'll be equipped with the knowledge to confidently plan and execute your SQL Server migration to the cloud using SQL Managed Instance.

Intro
Agenda
Azure SQL Managed instances
Why Azure SQL DB Managed Instance?
Service Tier Comparison
General Purpose Architecture
Business Critical Architecture
Business Critical – Instance Resize
Disaster Recovery Architecture
Isolation and connectivity
Instance Pools (preview)
Save up to 80% with SQL Database reserved capacity combined with AHB
Migration to Cloud
Database Migration Assessment
Solution Migration Assessment
Database migration process overview
Pre-migration
Migration - Best Practice
Easy Database Migration