What Are The Key Differences Between SQL Server On A VM And Azure SQL Managed Instance?
Managed Instance benefits from being always-up-to-date in the cloud, which means that some features in on-premises SQL Server may be either obsolete, retired, or have alternatives.
Below are some key differences:
Built in High-availability
Automated backups and point in time restore.
Support for Azure Active Directory authentication as an alternative to Windows authentication.