For system, network and cloud administrators
In order to view all SKUs that contain Standard_D2s in their name, for example, type:
az vm list-skus -o table --query "[?contains(name,'Standard_D2s')].name"
If you need to know all available SKUs that contain a pattern in a specific location, just add the –location westeurope, for example.