Scenario:

if you want to cancel updating database pricing tier. this can be due to mistake, or long running scale Operation.

Resolution:

1. open Azure cloud shell or use your local Azure CLI installation.

   Related Articles

   Microsoft Cloud Gaming: Where Imagina…
   Key Tips for Renting an Electric Vehi…
   Huawei Nova 12s Pre-Sales Commence in…
   Another Appliance Company Now Files A…
   Understanding the Software and Apps o…
   

2. edit the following command with your database details and execute the script

$ResourceGroupName = ""
$ServerName = ""
$DatabaseName = ""
#----------------------------------------
$OperationName = (az sql db op list --resource-group $ResourceGroupName --server $ServerName --database $DatabaseName --query "[?state=='InProgress'].name" --out tsv) 
if(-not [string]::IsNullOrEmpty($OperationName)) 
    {
        (az sql db op cancel --resource-group $ResourceGroupName --server $ServerName --database $DatabaseName --name $OperationName) 
        "Operation " + $OperationName + " has been canceled"
    }
    else
    {
        "No in progress operation found"
    }

3. review the output to confirm operation has been canceled.