A technical analysis of missing features and wishlist for SQL Server Columnstore Indexes as of 2026, focusing on performance and functionality gaps.
Explores methods for copying data into Azure Synapse Analytics (SQL DW), focusing on the CTAS and new COPY INTO commands.
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.
Explores the availability and configuration of Columnstore Indexes across various Azure SQL Database tiers, including General Purpose, Serverless, and Hyperscale.
Announcement for a full-day workshop on SQL Server Columnstore Indexes at SQLSaturday Vienna 2020, covering practical techniques across multiple versions.
Explores compatibility of Columnstore Indexes with new features in SQL Server 2019, including Approximate Distinct Count and Scalar UDF Inlining.
Analyzes if Batch Mode on Rowstore eliminates the need for Columnstore Indexes in SQL Server, comparing performance and compression.
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.
