Disclaimer: Currently I am employed by Microsoft, but my views and thoughts are still my own. The reason I joined Microsoft was, the work Microsoft have been doing for last couple of years in Open Source Space. Today I am a advocate for Open Source representing Microsoft.
If I remember it right, Azure SQL was launched back in October 2018. Back then, for it was more for answer to the need of migrating an existing SQL Server 2008/R2 database to Azure PaaS, with little to none changes.
In a year, the Managed Instance offering has come a long way. Today Azure SQL Managed Instance is more then just for simple lift and shift of a on-prem instance to Azure PaaS. Today it is viable option if you want to:
- Have a near 100% compatibility to your on-prem database with PaaS.
- Don't have to worry about underlying infrastructure.
- Be able to utilize the cloud capabilities to scale it (nearly) infinitely.
- Need to have a database instance lock behind a firewall, with only private endpoints.
In the session me and my colleague talked about how you can leverage Azure SQL Managed Instance for your businesses needs.