Advancing the DBA's Role in the Cloud: In the Cockpit of Azure SQL Managed Instance
summary
Maps on‑prem DBA tasks to Azure SQL Managed Instance and names exactly what stays with the DBA versus what Microsoft handles: automatic backups (full/diff/log) with retention 1–35 days and optional LTR up to 10 years, tier choice GP vs BC and start/stop + instance pools for cost control, zone redundancy and failover groups for DR, read‑only replicas on BC for offloading reads, TDE impacts (no instant file init so files are zeroed), and savings paths (reserved capacity and hybrid benefit up to large discounts).
AI-written summary · about
chapters (8)
- 0:00DBA role in Azure
- 11:20Microsoft’s Azure SQL MI duties
- 19:31Shared responsibilities
- 22:40Security and compliance
- 32:25On-premises to Azure DBA
- 37:42Azure DBA learning paths
- 40:48Cost optimization
- 47:13AI and automation for DBAs
related talks
52mAzure Sql DB Managed instance, a different sql server?
39mModernize your applications on Azure SQL Managed Instance Q&A
44mSQL Managed Instance: Fully managed SQL Server in Azure
50mAzure SQL Managed Instance Roadmap
49mEverything you always wanted to know about HA/DR for SQL Server on Azure VMs but were afraid to ask
22mFlight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit
56mMigrate Databases to the Cloud - Why, How and Best Practices
54mDesigning Azure Data Disaster Recovery Strategies