-
Generally Available: PG18 support for Azure Database for PostgreSQL elastic clusters
Azure Database for PostgreSQL elastic clusters now support PostgreSQL 18, enabling developers to use advanced features like logical decoding and enhanced partitioning.
-
Generally Available: New and improved troubleshooting guides for Azure Database for PostgreSQL
The updated Azure Database for PostgreSQL troubleshooting guides offer detailed steps to diagnose and resolve common issues like high CPU, memory usage, IOPS limits, excessive temporary files, and inefficient autovacuum operations.
-
Generally Available: Logical replication slot sync status metric for Azure PostgreSQL Flexible Server
The new Azure Monitor metric lets you track logical replication slot sync status in real time, improving reliability for Azure PostgreSQL Flexible Server workloads.
-
Public Preview: PostgreSQL skills and MCP plugin for Azure Database for PostgreSQL
The new Azure Database for PostgreSQL plugin integrates AI coding assistants to enhance developer productivity with context-aware guidance and direct database actions.
-
Public Preview: Azure SQL updates for mid-September 2026
Azure SQL introduces a new soft delete feature that preserves logical servers during deletion, allowing them to be restored within a configurable timeframe when accidentally removed.
-
Preview PG18 for Elastic Clusters of Azure Postgres
Azure previews PostgreSQL 18 for flexible server's elastic clusters adding managed horizontal scaling with Citus 14 for distributed SQL, sharding, and sub-second CDC latency up to 100 million rows.
-
Automating Azure SQL DB index and statistics maintenance using Elastic Jobs.
Automating Azure SQL DB index and statistics maintenance with Elastic Jobs reduces manual effort, ensures optimal performance, and integrates seamlessly with Azure Automation for scheduled execution.
-
How a Microsoft-signed SQL Server stored procedure lets sysadmins bypass disabled xp_cmdshell
A new SQL injection flaw in the internal `sys.sp_MSdeletefoldercontents` procedure allows running `xp_cmdshell` despite its disablement, circumventing crucial security settings.
-
August 2026 Recap: Azure Database for PostgreSQL
Azure Database for PostgreSQL introduces Adaptive autovacuum to automatically adjust vacuum processes based on workload signals, reducing bloat and maintenance overhead without manual tuning.
-
SQL Server Performance Office Hours Episode 79 – Dang is it hot again
In Episode 79, Erik Darling addresses persistent TempDB contention issues and explains how forced query plans can cause serial execution on multi-core machines due to optimizer costing.
-
Postgres Skills: Give Your AI Agent PostgreSQL Expertise
PostgreSQL Skills provides AI coding agents with 32 expert sub-skills to generate accurate, context-aware SQL for any PostgreSQL deployment, including Azure Database for PostgreSQL and HorizonDB, ensuring reliable execution through live database access.
-
Should your SQL Server database use foreign key constraints?
Foreign key constraints in SQL Server help prevent bad data but some teams avoid them due to perceived performance issues and development convenience, potentially overlooking integrity risks especially in multi-application environments.
-
Recovering TPS After a Cross-Database Migration
PostgreSQL performance drops after migration because the planner fails to convert NOT IN subqueries into anti-joins, forcing a costly materialization that is fixed by using NOT EXISTS instead.
-
Your Index Rebuild Maintenance Plan Is Rebuilding Indexes Nobody Uses
A weekly index rebuild may not improve performance as it often updates statistics without fixing fragmentation, causing extra logging, bigger backups, and wasted effort.
-
Automating Azure Managed Redis capacity acquisition with bounded retries
The Azure Managed Redis capacity poller safely creates capacity in approved regions and SKUs until a successful deployment occurs without risking infinite retries.
-
SQL Server Performance Office Hours Episode 81 – A Slightly Disordered Release Schedule
In Episode 81, Erik Darling covers SQL Server performance topics including key lookups, lock escalation, Query Store issues, latch contention vs. locking, and detecting worker thread starvation.
-
Database Change Management - Azure Database for PostgreSQL, GitHub Actions and Liquibase OSS
Liquibase automates schema migrations by treating database changes as version-controlled code, enabling automated rollbacks and drift detection within GitHub Actions pipelines.
-
What happens when your AI coding agent starts a database on its own (building an app with AI, part six)
In this sixth installment of Grant Fritchey’s series, Claude generates prompts to iterate on dbRosetta's app interface, enabling users to input a term and its data platform while receiving translations for multiple platforms including PostgreSQL, MySQL, Oracle, and SQL Server.
-
Query Store Cleaning And Mysterious Broker Tasks
SQL Server background processes labeled BRKR TASK often mask intensive Query Store cleanup operations that consume significant CPU resources.
-
mssql-django 2.0: Now with mssql-python
mssql-django 2.0 adds the mssql-python driver for enhanced datetimeoffset support and Entra ID auth with backward-compatible alias configurations.