Co‑authored with angesalsaa​  Symptoms Portal Upgrade action fails or the precheck reports that upgrading with password authentication from 11 isn’t allowed.  Users still authenticate with le...

Co-authored with HaiderZ-MSFT​   Issue Summary The customer attempted to change the server configuration from Standard_D4ds_v5 (non-Confidential Compute) to Standard_DC4ads_v5 (Confidential Comp...

Working on a case with a huge number of columns I needed to dump records as one line per field. Happy to share this script that it was useful. For example, I would like to have the data in this way. ...

Co-authored with angesalsaa​  The issue occurred when the server’s storage usage reached approximately 95% of the allocated capacity. Automatic storage scaling was disabled.   Symptoms included...

Issue We recently received an end user case where the customer complained of fluctuations in size of an Azure SQL DB.   Error The cx noticed this on their Azure Portal Monitoring screen, the ...

Errors are an inherent part of any application. As a database professional managing an Azure SQL Managed Instance, you may be interested in understanding when specific errors occur and how to leverag...

We had the opportunity to share our experience in several community sessions how SSMS Copilot can help across multiple phases of troubleshooting. In this article, I would like to share a set of promp...