Recently, I worked on a performance investigation in which several queries were identified by their query hashes. The hashes helped us discuss the workload, but the customer still needed to answer a ...

When a critical production incident starts, the first message we often receive is something like: “The database is down.”  At that moment, everything suddenly becomes urgent. Engineers open mon...

Using as a reference of this article. Automating Azure SQL DB index and statistics maintenance using Azure Automation | Microsoft Community Hub To provide complete solution to maintain you Azure SQ...

BCP is one of those SQL Server tools that many of us have been using for years. It is simple, reliable, and extremely fast when we need to move large amounts of data. We execute it, and millions of r...

Problem Statement Customer trying to mograte SQL Server database to Azure SQL Database by restoring a .bak file to a jump server, exporting it to a .bacpac, and importing that .bacpac to Azure SQL ...

When a Microsoft Entra server login is deleted from the logical master database in Azure SQL Database, any login-based database users mapped to that login become orphaned. These orphaned principals s...

Recently, I reviewed a customer case where an application intermittently reported: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set. The issue occurred durin...

In one of our support cases, a customer reported higher-than-expected connection times when connecting from SQL Server Management Studio (SSMS) to Azure SQL Database using Microsoft Entra authenticat...

By Tanayankar Chakraborty & Sukhwant Kaur  Issue  A customer recently reported that their Azure App Service intermittently cannot establish a TDS connection to its Microsoft Fabric SQL database w...

Azure SQL Data Sync is a powerful service that enables data synchronization across multiple Azure SQL Databases. Traditionally, Data Sync relied on SQL Authentication, requiring administrators to man...