SQL Managed Instance: Fully managed SQL Server in Azure
summary
Azure SQL Managed Instance positions itself between SQL on VM and single-db SQL Database and emphasizes compatibility and modernization. Recent additions: preview of distributed transactions with server trust groups and .NET coordinator support; machine learning services for R/Python in-db; SSRS catalog hosting; and a log replay API for near-zero-downtime migrations. Performance: instance log throughput cap rises to 120 MB/s (GP) and BC to 96 MB/s, yielding 2–4x gains in TPCC and ingestion. Networking adds global vnet peering and private endpoints; backups gain LTR up to 10 years and new redundancy choices.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 1:41Requirements
- 3:09Team Management
- 8:08Integration Options
- 10:49Updates
- 15:16Distributed Transactions
- 19:00Global Peering
- 20:38Security Compliance
- 25:17Private Link
- 27:26Performance Improvements
- 32:47Cost Optimizations
- 34:42Monitoring and Management
- 40:26Service Deployment
- 42:07Enhanced Instance Management
related talks
52mAzure Sql DB Managed instance, a different sql server?
39mModernize your applications on Azure SQL Managed Instance Q&A
50mAzure SQL Managed Instance Roadmap
50mManaged Instance Link - Seamless migration to Azure
51mFly at Mach-speed with Azure SQL Managed Instance- 51mFly at Mach-speed with Azure SQL Managed Instance
48mSQL Server 2022 - the most Azure-enabled SQL Server yet- 50mManaged Instance Link - Seamless migration to Azure