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.
Explains how to configure the number of History service shards in Temporal for optimal performance, balancing contention and resource use.
A developer shares the value of SQL Server Profiler for debugging and performance analysis, offering tips for creating effective custom trace templates.
How Twitter built LongTermMetrics (LTM), a system that identified and shipped millions in cost savings by analyzing JVM metrics.
Announcing a full-day SQL workshop on optimizing data warehouses using Columnstore Indexes, from basics to advanced tuning, at SQLSaturday Madrid 2018.
Announcing two full-day SQL Server workshops at SQLSaturday Lisbon 2018, featuring Query Store troubleshooting and performance tuning.
A guide to optimizing PHPStorm's performance through VM options, disabling unused plugins, and managing project indexing.
A guide to using Java 9+'s unified logging architecture with the -Xlog option to configure JVM internal messages.
A guide on how to disable Intel Hyper-Threading Technology on Amazon Linux EC2 instances for specific workloads like HPC.
A deep dive into troubleshooting performance issues with SQL Server's natively compiled stored procedures, focusing on unexpected preemptive waits and memory contention.
A technical guide detailing the challenges and solutions for running Linux on a Samsung Chronos 7 laptop, focusing on performance and heat management.
