Modernize your applications on Azure SQL Managed Instance Q&A
summary
Azure SQL Managed Instance supports near-full Enterprise feature parity and migration tooling: use Azure Data Studio’s SQL Migration extension for assessment and online/offline moves, Managed Instance Link for continuous replication and consolidation, and TDE key migration via the migration tool or PowerShell. Business Critical uses a four-node availability-group model with a readable secondary; General Purpose uses shared compute with remote storage. Roadmap items include double log write speeds in Business Critical (soon) and 100 databases per instance limit under review.
AI-written summary · about
chapters (19)
- 0:00Introduction
- 1:58Azure SQL
- 3:25SQL Managed Instance
- 5:43QA Introduction
- 6:12Log Speeds
- 7:11Limitations
- 7:28Are you giving anything up
- 8:58When will we go beyond 100 databases per instance
- 9:31How do we make the decision
- 10:48High availability
- 15:34Best Practices
- 19:48Best Tools
- 21:58Polybase
- 24:22Mlink
- 25:37VM vs Managed Instance
- 31:18StartStop
- 33:48Online Question
- 35:09Index Maintenance
- 36:24Snapshots
related talks
52mAzure Sql DB Managed instance, a different sql server?
44mSQL Managed Instance: Fully managed SQL Server in Azure
50mAzure SQL Managed Instance Roadmap
50mAdvancing the DBA's Role in the Cloud: In the Cockpit of Azure SQL Managed Instance
50mManaged Instance Link - Seamless migration to Azure- 50mManaged Instance Link - Seamless migration to Azure
44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance- 44mThe Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance