This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.
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
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.