The idea behind this series is to serve as a good, high quality reference and to deliver a quick building block for anyone building their scripts library or even doing some automation.
We are primary focusing on the most common tasks, with the first group of posts focusing on the SQL Managed Instance Service Discovery, but with the time more functional and more advanced topics will be landing in this series soon.
You can find and reference the whole series with the following link http://aka.ms/sqlmi-howto which will lead you precisely to this very post.
The how-tos themselves will be grouped below according to the functionality, such as Service Discovery, Quick-Fixes, Performance Optimization, between others, and not in the chronological order in which they are published.
Service Discovery:
Service Tier basic details - SQL MI Service Tier details (Service tier, Hardware Generation)
Number of CPU vCores - SQL MI Number of CPU vCores (with different permission requirements)
Total amount of RAM - SQL MI total & available amounts of RAM
Reserved and Available Disk Space - SQL MI reserved and available Disk Space
High Availability:
The timestamp of the last failover - the timestamp of the last SQL MI failover
Failover Group configuration - SQL MI Failover Group configuration
HA Replicas Details - SQL MI Failover Group and HA Replicas Details
Monitor Databases & Replicas - monitor SQL MI Failover Group & Replicas
Quick-Fixes:
Sync Agent Jobs and Logins in Failover Groups - Sync Agent Jobs and Logins in Failover Groups
Performance:
Find out addressable Disk Space & Files Number - Addressable Disk Space & Files Number on General Purpose service tier
Improving data loading performance on General Purpose service tier - Improving data loading performance on General Purpose service tier
Improving data loading performance on Business Critical service tier - Improving data loading performance on Business Critical service tier
Connectivity:
Failover group connectivity between SQL Managed Instances - Failover group connectivity between primary and secondary SQL MIs
Test TCP connectivity from a SQL Managed Instance - Test TCP connectivity from a SQL Managed Instance
Check if global virtual network peering is supported on the virtual cluster - How to check if global virtual network peering is supported on the virtual cluster for SQL MI
Business Continuity:
Restore across different SQL Managed instances when using TDE with Customer Managed Keys - Restore across different SQL Managed instances when using TDE with Customer Managed Keys
Take secure, on-demand backups on SQL Managed Instance - How to take secure, on-demand backups on SQL Managed Instance
As we progress with the new how-tos, this post will be constantly updated to keep with the up-to-date information on the newest additions.