Recent Blogs
Testing suggests that blob names containing the literal % character require special attention when used with SQL OPENROWSET (BULK). In the tests below, a file name containing a literal % was not acce...
Jul 02, 2026 This week I worked on a service request where our customer needed to understand how an Azure SQL Database had grown over time. This information can be useful for capacity planning, cost analysis, and...
Jun 29, 2026 Author: Mohamed Baioumy Technology: Azure Database for PostgreSQL (Flexible Server & Single Server) Category: Connectivity | Performance | Application Design
Introduction
Connection pooling is ...
Jun 26, 2026
2 MIN READ
Automatic Plan Correction is one of the most useful capabilities in Azure SQL Database when dealing with plan regressions. It uses Query Store to identify when a query starts using a worse execution ...
Jun 26, 2026
2 MIN READ
Recently I have worked on cases where it is observed that data sync fails with deadlock error.
Error:
Database re-provisioning failed with the exception 'Transaction (Process ID ##) was deadlocke...
Jun 22, 2026
Introduction Overview steps for configuration of Mirroring between Azure SQL Database to Fabric Mirrored Database over Private Endpoint and Public Connectivity Disabled on source.
Prerequisites ...
Jun 21, 2026 Introduction
Azure SQL Data Sync is a popular solution for synchronizing data across multiple Azure SQL Database instances. It uses Change Tracking to identify and propagate data modifications betw...
Jun 18, 20263 MIN READ
In this lesson learned, I would like to share an interesting scenario working on a service request where our customer was running a high-volume data load process in Azure SQL Database Hyperscale. The...
Jun 17, 2026
2 MIN READ
Sometimes you’ll notice many sessions showing the command VDI_CLIENT_WORKER in Azure SQL Database—often around scaling, replica/copy workflows, or internal seeding operations. These sessions can ...
May 28, 2026 Why This Behavior Is by Design
When migrating an Azure SQL Database from Business Critical (BC) to Hyperscale using a manual cutover, some customers notice unexpected Point-in-Time Restore (PITR) b...
May 14, 2026