T-SQL Tuesday roundup on warning signs of bad SQL queries, including WHILE loops, cursors, functions, and DISTINCT.
Learning practical tips for running SQLite in production, including ANALYZE for query performance and handling cleanup operations.
Techniques for achieving partition pruning in PostgreSQL when filtering by non-partition key columns.
A Rails performance audit report for the Organization for Transformative Works and Archive of Our Own, focusing on optimization and technical debt reduction.
A guide on diagnosing SQL Server performance issues, emphasizing the importance of defining the problem precisely before analyzing data.
A SQL expert details the strategy for designing an interactive conference session on solving query performance differences between development and production databases.
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.
Explores creative PostgreSQL optimization techniques beyond standard indexing and query rewriting, focusing on constraint exclusion and function-based indexes.
A developer details optimizing a server-side analytics system, reducing processing time for 11 million rows from hours to minutes.
Explores the new JSON data type and JSON Index in SQL Server 2025, focusing on their compatibility and limitations with Columnstore Indexes and Batch Execution Mode.
Explores the integration of new Vector data types and Vector Indexes with Columnstore Indexes in SQL Server 2025 for similarity search and RAG.
A technical analysis of missing features and wishlist for SQL Server Columnstore Indexes as of 2026, focusing on performance and functionality gaps.
A guide to using Releem, a tool for MySQL performance tuning and monitoring, including installation and configuration steps.
Explains how different database systems rewrite date/time range queries to enable efficient index usage for functions like EXTRACT(YEAR FROM ...).
Explains Azure SQL Database's AI-powered Automatic Tuning feature, detailing how it optimizes performance and provides a step-by-step tutorial.
A technical guide on freeing 70GB+ of database space by identifying and removing unused indexes and bloat, focusing on PostgreSQL optimization techniques.
Analyzes how medium-sized text fields impact PostgreSQL query performance through the TOAST storage mechanism.
Explains how to use NHibernate's future results feature to batch database queries, reducing network traffic and improving performance.
A developer discusses fixing an N+1 query bug and handling tricky date logic in a Django app, part of a SaaS building series.
Announcement of a technical workshop on SQL Server Columnstore Indexes, covering versions, features, and practical techniques.
