Azure PowerShell - List Virtual Machine Sizes
Bradley Schacht is a Principal Program Manager on the Microsoft Fabric product team based in Saint Augustine, FL. Bradley is a former consultant, trainer, and has coauthored 6 SQL Server and Power BI books, most recently Learn Microsoft Fabric. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. Bradley gives back to the community through speaking at events such as the SQLBits, Fabric Community Conference, PASS Community Data Summit, SQL Saturdays, Code Camps, and user groups across the country including locally at the Jacksonville SQL Server User Group (JSSUG). He is a contributor on SQLServerCentral.com and blogs on his personal site, BradleySchacht.com.
You can also supply that parameter at runtime.
What if you don't want to go run this every time you need to look up a VM size? Once you see the options you can tell that they are pretty straightforward. Standard/Basic_VMSize is the basic format of the name. But it's helpful to know what is available and where it is available. So I thought, why not drop these out to a file so I can easily go filter by VM size or data center. I often have to figure out what VM size to recommend for customers and it is helpful to know what is available in the data center(s) that they are using. A few lines of PowerShell later and we are good to go! What I really want is the output from the Get-AzureRmVmSize cmdlet but with the location added to it. Having the list dropped to a file doesn't do me any good if I don't know what data center each section ties back to. Also, I don't want a bunch of duplicate headers in my file, so I'll want to make sure however I do this that I only get one set of headers. A few searches and trial and error later I had this piece of magic. (I don't do a lot of PowerShell, so there may well be a better way of doing this, but it worked and was more clean than the first 2 versions I had hacked together, so this is what the world gets!) Most of the time we only care about a couple of data centers. Let's say that you are building your main location in East US and East US 2 but you want to do DR in West US. You can use the first line of this script to filter down to just the data centers that you care about. Or you can comment out line 1 and un-comment line 2 to get the entire list. Just be aware that if you do this for all the locations it may take a little while. I also have a couple of lines at the beginning go reset some things as I was running the code over and over. If you are doing a run-once situation then those first two lines from my screenshot will be unnecessary. [code language="powershell"]$locations = Get-AzureRmLocation | Where-Object {$_.location -in "eastus2","eastus"} #$locations = Get-AzureRmLocation foreach ($l in $locations) { $vmSizes += Get-AzureRmVmSize -Location $l.Location | Select-Object @{Name="LocationDisplayName"; Expression = {$l.DisplayName}},@{Name="Location"; Expression = {$l.Location}},Name,NumberOfCores,MemoryInMB,MaxDataDiskCount,OSDiskSizeInMB,ResourceDiskSizeInMB } $vmSizes | Export-Csv -Path "AzureVmSizes.csv" -NoTypeInformation $vmSizes | ft[/code] 
Now you'll end up with a CSV file that can be opened in Excel, formatted as a table and is easily searchable and can be filtered. 
Want to know which data centers have those giant, fancy M128 VMs? Easy! 
You could filter the PowerShell output as well, but this just seems like a fun little project for a Monday afternoon.