[Video] Office Hours: Back in the Bahamas Edition
SQL Server expert Brent Ozar answers community questions on database administration, tuning, and AI tools in a video from a cruise ship.
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.
Updated SQL Server diagnostic queries for June 2025, covering multiple versions and Azure services for performance and configuration analysis.
PostgreSQL 18 will improve EXPLAIN output by showing fractional row counts with two decimal digits for better query plan accuracy.
A guide to using Releem, a tool for MySQL performance tuning and monitoring, including installation and configuration steps.