-
Generally Available: Immutability to the most recent seven days of backups on Azure SQL Database and Azure SQL Managed Instance
Azure SQL Database and Azure SQL Managed Instance now automatically enforce immutability on the latest seven days of backups, ensuring data protection without additional configuration.
-
How to build an Oracle AWR-equivalent diagnostics stack in PostgreSQL (step-by-step guide with code)
This guide demonstrates building an Oracle AWR-equivalent diagnostics stack in PostgreSQL using extensions like pg_profile, pg_wait_sampling, and pg_stat_statements, with runnable SQL for snapshot history, wait event sampling, Top SQL analysis, and buffer cache inspection.
-
Top 10 Performance Optimization Techniques for Azure Database for PostgreSQL Flexible Server
This article outlines ten effective methods such as choosing appropriate compute SKUs, enabling Query Store, utilizing PgBouncer connection pooling, consulting Azure troubleshooting resources, monitoring autovacuum, and optimizing storage and IOPS to boost the performance and reliability of Azure Database for PostgreSQL Flexible Server.
-
SQL Server Deadlock: Build One With Your Own Hands
This SQL Server article demonstrates how to manually create a deadlock between two transactions by updating competing tables in opposite orders.
-
SQL Server Performance Office Hours Episode 71
In Episode 71, Erik Darling discusses travel preferences, conference locations, ClickUp overview, an Azure VM issue, and a table variables discussion during SQL Server Performance Office Hours.
-
Faster, Safer Version Upgrades for Databases with Large Objects
Azure Database for PostgreSQL now handles large-object metadata more efficiently during major version upgrades, reducing memory pressure and enabling successful upgrades of databases with up to 500 million large objects.
-
Announcing Automatic Backup Immutability for Azure SQL Database and Azure SQL Managed Instance
Azure SQL Database and Managed Instance now automatically protect up to seven days of recent point-in-time restore backups with immutability, defending against ransomware and accidental changes without configuration.
-
T-SQL in SQL Server 2025: REGEXP_LIKE
SQL Server 2025 adds REGEXP_LIKE and four related functions to provide native regular expression support for advanced pattern matching in T-SQL.
-
HostNameInCertificate changes in Azure SQL Managed Instance affecting client connectivity
Azure SQL Managed Instance will reduce SAN versions in instance certificates starting August 1, 2026, which may break client connections using VNet-local endpoints and the HostNameInCertificate parameter if not updated.
-
MySQL vs PostgreSQL: spatial data types, functions, and migration pitfalls explained
This guide explains how MySQL and PostgreSQL handle spatial data differently, with PostGIS offering more advanced GIS capabilities for location-aware applications while MySQL’s recent enhancements have narrowed the performance gap.
-
Two Insert Exec Problems
The video demonstrates how Insert Exec can cause blocking issues and prolonged lock contention on tables using a stored procedure that deletes and inserts data while waiting five seconds.
-
Lessons Learned #551: Azure SQL Connection Timeouts: Three Things to Check
Azure SQL connection timeouts may hide token acquisition or DNS resolution delays instead of indicating database problems; diagnose by capturing full error details and timing each connection phase.
-
Nine Unusual Ways My Clients Use AI With SQL Server
This article reveals nine unconventional ways real database teams leverage AI with SQL Server, including extracting business rules from legacy code and reverse engineering closed vendor schemas.
-
AI-assisted Oracle-to-PostgreSQL schema conversion in Visual Studio Code
The new AI-assisted schema conversion feature in Visual Studio Code’s PostgreSQL extension simplifies migrating Oracle databases to Azure Database for PostgreSQL by handling discovery, translation, validation, and review within a single project workflow, reducing manual effort and ensuring compatibility with complex Oracle constructs.
-
Free SQL Server Performance Monitoring: Where Things Are And Where Things Are Going
The free SQL Server Performance Monitoring tool now includes a storage growth tab that shows which database objects are expanding fastest, helping administrators right-size servers and optimize costs.
-
Database Animations: Why Big Columns May Not Affect Logical Reads
This article explains that adding many columns or wide data types increases row length without affecting single-row logical reads but may impact performance when reading multiple rows, shown through database animations comparing seek and scan methods.
-
From 20+ seconds to 2 - faster SQL Database Project .dacpac deployments are finally here (preview)
The new DacFx 170.5.60-preview release cuts SQL Database Project deployment time from over 20 seconds to about 2 seconds by caching model checksums and skipping redundant schema validation steps.
-
How to ensure replication stability in PostgreSQL (fix/prevent lag, bloat, and bottlenecks)
Ensuring replication stability in PostgreSQL involves tuning configuration settings, managing table bloat with regular VACUUM operations, and handling large DDL changes safely to prevent lag, network issues, and performance bottlenecks.
-
mssql-django 1.8.0: Django 6.1 Support within 48 Hours of Django 6.1 GA
mssql-django 1.8.0 rolled out Django 6.1 support within 48 hours of its general availability, enabling seamless upgrades for SQL Server, Azure SQL, and Fabric users with a single pip command.
-
mssql-python 1.13.0: Arrow Bulk Copy, Smarter Tokens, Slimmer Wheels
mssql-python 1.13.0 adds an Apache Arrow bulk copy feature streaming data directly to SQL servers with no Python overhead, supports Azure Identity credentials, and relocates ODBC driver binaries to a separate package for smaller files and easier updates.