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: ...

PRIVATE ENDPOINT – SQL MANAGED INSTANCE Where PE can be located? Key points Connections only in one direction, from PE to SQL MI and traffic in port 1433 When using PE, there’s no ...

Co‑authored with angesalsaa​  Case Overview A customer attempted to deploy Azure Database for PostgreSQL – Flexible Server using private networking (VNet injection + Private DNS). The deployme...

  You noticed an event showing up while reviewing activity logs. SQLDBControlPlaneFirstPartyApp explained The SQLDBControlPlaneFirstPartyApp is an internal Azure application used by the Az...

A common scenario when using Mirroring in Fabric for Azure SQL Database is when everything appears healthy, yet no data is actually replicated. In this situation: The Fabric portal shows the mi...

When trying to Import .bacpac file via Azure Portal, it fails with below error:     'code': 'ImportExportJobError',   'message': 'The ImportExport operation with Request Id '' failed due to '...

While configuring Auditing settings for Azure SQL, the deployment may fail and following error is encountered:   Failed to save Auditing settings for server. The client has permission to perf...

Azure SQL Database failover groups are a business continuity capability that helps you manage geo-replication and coordinated failover of one or more databases from a primary Azure SQL logical server...

A few scenarios where sequencing is useful: Generating Unique Identifiers: When you need a unique sequential number for each new row (e.g., order numbers, invoice numbers). Unlike identity co...

Co‑authored with HaiderZ-MSFT​  Case Overview A customer attempted to increase storage for their Azure Database for PostgreSQL Flexible Server but was unable to exceed 32 TiB. Investigation confi...