Sometime you would need to know how many Managed Instance you have created in Azure cloud. Although you can find all information about the Azure SQL Managed Instances in Azure portal or API (ARM, PowerShell, Azure CLI), sometime it is hard to list all instances and search them using some criteria. In this post you... Read more

https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/10/01/analysing-inventory-of-managed-instances-using-t-sql/