There and back again: SQL Server 2022 - Managed Instance

on YouTube ↗19m

" summary

Demo shows a working Mi Link that establishes near real-time replication from SQL Server (2016–2022) to Azure SQL Managed Instance, seeding a full DB, creating an AG/DAG automatically, and presenting the secondary as read-only for Power BI. It supports a manual planned or force failover, and a preview bidirectional online failover between SQL Server 2022 and Managed Instance that switches replication to sync, validates LSNs, and does round trips successfully. Limits: up to 100 databases per MI, network bandwidth/latency, and a five‑year compatibility guarantee.

AI-written summary · about

" chapters (9)

1. 0:00SQL Server 2022 Managed Instance intro
2. 1:01Managed Instance Link overview
3. 2:49Demo: Managed Instance Link setup
4. 5:15Data read/write across instances
5. 8:05Power BI with read-only replicas
6. 9:54Minimal downtime Azure migration
7. 12:42Failback scenarios
8. 14:48Bi-directional failover demo
9. 19:04Resources and closing

" related talks

• 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed InstanceDani Ljepava · SQLBits 2023
• 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed InstanceDani Ljepava · SQLBits 2019
• 23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DRDjordje Jeremic, Dani Ljepava · SQLBits 2024
• 50mManaged Instance Link - Seamless migration to AzureHaider Raza, Manish Kumar · SQLBits 2019
• 48mSQL Server 2022 - the most Azure-enabled SQL Server yetchuck heinzelman, Ajay Jagannathan · SQLBits 2023
• 50mDiscover what's new in Azure SQL Managed Instance through an exciting Demo Party!Niko Neugebauer, Dani Ljepava, Nevena Nikolic, Uros Milanovic · SQLBits 2024
• 50mAzure SQL Managed Instance RoadmapNiko Neugebauer · SQLBits 2023
• 23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DRDjordje Jeremic, Dani Ljepava · SQLBits 2019