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.
PostgreSQL 18 will allow dynamic adjustment of autovacuum_max_workers without a server restart, improving database maintenance flexibility.
Final guide in a series covering performance tuning and best practices for optimizing Apache Parquet files in big data workflows.
Analyzing Twitter's container CPU throttling issue, its causes, and potential solutions for significant performance and cost savings.
Explains how to reduce memory usage for multiple .NET services on a single machine by disabling server garbage collection.
