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.
Explores SQL Server 2019's session context functions and their unexpected impact on query parallel execution plans.
Explains limitations of ONLINE rebuild for Rowstore indexes on tables with Columnstore Indexes in older SQL Server versions (2016, 2017).
Announcement of a pre-conference workshop on SQL Server Columnstore Indexes at SQLSaturday Cincinnati, covering versions, batch mode, and Azure Synapse features.
A technical guide on creating and managing Materialized Views in Azure SQL Data Warehouse, focusing on practical implementation and limitations.
Introduction to Materialized Views in Azure Synapse Analytics, explaining their purpose as a caching mechanism for data warehouse optimization.
Announcement for a full-day workshop on SQL Server Columnstore Indexes at SQLSaturday Vienna 2020, covering practical techniques across multiple versions.
