Azure SQL Data Sync is commonly used to keep selected tables synchronized between a hub database and one or more member databases. In some cases, you may discover a data “gap”: a subset of rows that ...

Transparent Data Encryption (TDE) in Azure SQL Database encrypts data at rest using a database encryption key (DEK). The DEK itself is protected by a TDE protector, which can be either: A service...

Recently, I worked on an interesting customer case involving intermittent query failures while fetching reporting data from a read replica. The customer was running their database on the Azure SQL ...

Applies to: Azure SQL Database (Change Tracking enabled) Recap (Part 1) In Part 1, we covered how to detect “orphaned” records in Change Tracking (CT) side tables — rows whose sys_change_xdes_id ...

Applies to: Azure SQL Database Scenario: Change Tracking (CT) side tables grow unexpectedly, and “orphaned” rows appear after switching between auto-cleanup and custom/scheduled manual cleanup. Th...

Issue While enabling CDC at the database level on Azure SQL Database using: EXEC sys.sp_cdc_enable_db; GO the operation fails. Error The customer observed the following failure when runni...

Why this matters: Under the EU Digital Operational Resilience Act (DORA), many financial entities are strengthening requirements around ICT risk management, third‑party risk oversight, and—critically...

Security and compliance teams often ask for “offline backups” and “immutable backups” as part of ransomware resilience, audit readiness, and recovery strategy. In Azure SQL Database, these terms map ...

Issue An issue was brought to our attention recently by a customer where we noticed that the cx DB was Inaccessible. On further investigation, it was concluded that the database was encrypted with ...

When Change Tracking (CT) is enabled, SQL Server (and Azure SQL Database) stores lightweight change metadata so applications can query “what changed since version X?”. Under the hood, CT maintains: ...