Explores creative PostgreSQL optimization techniques beyond standard indexing and query rewriting, focusing on constraint exclusion and function-based indexes.
A technical analysis of missing features and wishlist for SQL Server Columnstore Indexes as of 2026, focusing on performance and functionality gaps.
Explores how metadata in Parquet files improves data efficiency and query performance, covering file, row group, and column-level metadata.
Explains the differences between MongoDB's $match operator and find() method, including performance benchmarks and use cases.
Analyzes how medium-sized text fields impact PostgreSQL query performance through the TOAST storage mechanism.
Explores SQL Server 2019's session context functions and their unexpected impact on query parallel execution plans.
Explains the internal workings of SQL databases, covering data structures like tables, indexes, rows, and pages for both storage and querying.
Explores compatibility of Columnstore Indexes with new features in SQL Server 2019, including Approximate Distinct Count and Scalar UDF Inlining.
Explores the preview feature of ordered Clustered Columnstore Indexes in Azure SQL Data Warehouse, testing syntax and performance benefits.
A proposal for a new "Optimize for Analytics" database configuration option in SQL Server and Azure SQL Database to enhance performance for data warehousing workloads.
Announcing a new YouTube channel focused on SQL Server Columnstore Indexes and Batch Execution Mode, featuring technical videos and interviews.
A guide to using Extended Events (XEvents) for advanced tracing and diagnostics in Azure SQL Database, covering setup and specific use cases.
Explains how to use PostgreSQL expression and functional indexes to optimize queries using built-in functions or custom JavaScript functions.
