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.
Analyzes the current state and future of SQL Server's In-Memory OLTP technology, highlighting new features in SQL Server 2019 and persistent limitations.
Explores SQL Server's Memory-Optimized TempDB Metadata feature, which reduces contention by moving system tables into memory, with a performance test demonstration.
Explores compatibility of Columnstore Indexes with new features in SQL Server 2019, including Approximate Distinct Count and Scalar UDF Inlining.
Explains how to implement server-side projections in MongoDB.Driver for C# to improve performance by fetching only required document fields.
Explores the preview feature of ordered Clustered Columnstore Indexes in Azure SQL Data Warehouse, testing syntax and performance benefits.
Explains the index INCLUDE clause in SQL databases, covering its purpose, how it works with B-tree indexes, and when to use it for performance.
A guide to optimizing Django dashboard performance using SQL grouping sets for advanced aggregation, including a cautionary note.
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.
Explores Microsoft's new Columnstore compression estimation in SQL Server 2019, comparing it to a custom system stored procedure.
Announcing a full-day SQL workshop on optimizing data warehouses using Columnstore Indexes, from basics to advanced tuning, at SQLSaturday Madrid 2018.
A personal reflection on the author's 5-year journey writing a blog series about SQL Server Columnstore Indexes, from initial posts to becoming an expert.
Explores Microsoft's Resumable Online Index Creation feature in Azure SQL DB, detailing its benefits for managing large databases without downtime.
Introduces a custom stored procedure for estimating compression savings for SQL Server Columnstore Indexes, filling a gap in native tooling.
