Connecting to Azure SQL Managed Instance
Azure SQL Managed Instance is a set of services hosted on one or more isolated virtual machines inside a virtual network subnet.
When we provision an Azure SQL Managed Instance, a virtual cluster is created. AÂ virtual cluster can have one or more SQL Managed Instances.
Applications connect to databases via an endpoint, <mi_name>.<dns_zone>.database. windows.net, and should be inside a virtual network, a peered virtual network, or an on-premises network connected via VPN or Azure ExpressRoute.
Unlike Azure SQL Database, Azure SQL Managed Instance supports Azure Virtual Network (VNet). An Azure VNet is a logical boundary or isolation that groups resources within a specified Azure region and enables secure communication between resources, the internet, and on-premises networks:
Figure 1.30: High-level connectivity architecture for SQL Managed Instances
Figure 1.30 shows a high-level connectivity...
