Azure SQL Database Managed Instance is new data service in Azure cloud that exposes fully-managed SQL Server Instance that is hosted in Azure cloud and placed in customer VNET. Here you can see some of the key new features that are available in Managed Instance.
Azure SQL Database Managed Instance is fully-managed SQL Server instance that is running in Azure cloud. This service started public preview in March 2018. Managed Instance has many instance-level features that are not available in classic Database as a Service model, such as SQL Agent, CLR, etc.
In this short demo you can see what is Managed Instance, and some key features that are enabled:
- Native backup/restore
- Service Broker/Query Notifications
- Cross database queries and linked servers
- CLR/Regular expressions
- SQL Agent
Demo is available on Azure SQL Database YouTube channel.
Source: Microsoft Blog – SQL Server Storage Engine – Demo – Azure SQL Database Managed Instance in action