How to list Azure MS SQL Database SKUs List With PowerShell

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.

PowerShell

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:

Connect-AzAccount

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