In this blog post, we’ll walk through the steps to list Azure MS SQL database SKUs list with PowerShell.
If you’re working with Microsoft Azure and SQL databases, you may need to list the SKU (Stock Keeping Unit) of your databases for various purposes, such as monitoring, reporting, or cost analysis. PowerShell is a powerful tool that can help you achieve this task easily and efficiently.
If you don’t have it, you can install it by running the following command in an elevated PowerShell session:
Install-Module -Name Az -AllowClobber
Next, you need to connect to your Azure subscription using PowerShell. Run the following command to log in to your Azure account:
To get the list of SKUs, run the following cmdlet with the Azure region you are planning to deploy the DB.
Get-AzSqlServerServiceObjective -Location australiaeast