Identifies five common causes for sudden SQL Server slowdowns and explains how to diagnose them effectively.
March 2026 update for SQL Server First Responder Kit adds AI-powered index advice and automated code review fixes.
![[Video] Office Hours, Standing in the Ocean Edition](https://allblogs.blob.core.windows.net/alldevblogs/thumbs/article-d4626251b58f-full-d0df0a7f.webp)
A Q&A video covering SQL Server topics like stats maintenance, XE, certifications, upgrades, and database management.
![[Video] Office Hours: Back in the Bahamas Edition](https://allblogs.blob.core.windows.net/alldevblogs/thumbs/article-485d424b228f-full-9ec268b8.webp)
SQL Server expert Brent Ozar answers community questions on database administration, tuning, and AI tools in a video from a cruise ship.
Updated SQL Server diagnostic queries for March 2026, including versions for various SQL Server editions and Azure SQL.
Updates to the SQL Server First Responder Kit and Consultant Toolkit, including new AI-powered query tuning and long-term performance tracking features.
A SQL expert details the strategy for designing an interactive conference session on solving query performance differences between development and production databases.
Updated SQL Server diagnostic queries for February 2026, with fixes and improvements for various SQL Server and Azure versions.
A developer details optimizing a PHP script to process 11 million database rows in seconds, focusing on SQL query batching and moving logic to PHP.
Updated SQL Server diagnostic queries for January 2026, covering multiple versions and Azure services for performance and configuration analysis.
A developer reflects on the rarity of challenging frontend performance work in React projects and the industry's bias towards high-powered devices.
Explains how hardware performance depends on software selection and tuning, using a three-stage rocket analogy for tech leaders.
Updated SQL Server diagnostic queries for November 2025, including new columns and query hints for performance analysis.
A review of the book 'Troubleshooting Java,' covering debugging, profiling, and performance tuning for Java applications.
Explains how Kubernetes API server concurrency controls like --max-requests-inflight work to manage performance and prevent overload.
Updated T-SQL diagnostic queries for SQL Server (2005-2025) and Azure SQL to analyze instance configuration and performance.
Deep dive into sizing the central request queue for Java 25's new CPU-time profiler, balancing performance and memory usage.
Updated T-SQL diagnostic queries for SQL Server (August 2025) to analyze instance configuration and performance across versions.
Author's updated SQL Server diagnostic queries for July 2025, covering multiple versions and Azure services for performance and configuration analysis.
A guide for Oracle DBAs on PostgreSQL query tuning, covering the pg_stat_statements extension and the PostgreSQL planner's cost model.
