A developer reflects on 20 years of blogging about tech topics like Columnstore Indexes, Vector Indexes, AI, and Product Management.
Explores the integration of new Vector data types and Vector Indexes with Columnstore Indexes in SQL Server 2025 for similarity search and RAG.
Analyzes the lack of data replication support for Clustered Columnstore Indexes in SQL Server, covering features from 2012 to 2025.
A technical analysis of missing features and wishlist for SQL Server Columnstore Indexes as of 2026, focusing on performance and functionality gaps.
Announcing two technical sessions at the virtual PASS Summit 2020: migrating SQL Server to Azure VMs and using Columnstore Indexes.
Announcement of a technical workshop on SQL Server Columnstore Indexes, covering versions, features, and practical techniques.
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.
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.
Explores the preview feature of ordered Clustered Columnstore Indexes in Azure SQL Data Warehouse, testing syntax and performance benefits.
Author shares excitement about presenting two technical sessions on SQL Server Columnstore Indexes and Batch Execution Mode at the PASS Summit 2019 data platform conference.
A database expert reviews their 2018 speaking engagements and blog output, focusing on Columnstore Indexes, Graph Databases, and Batch Execution Mode.
Announcing a new YouTube channel focused on SQL Server Columnstore Indexes and Batch Execution Mode, featuring technical videos and interviews.
Analyzes if Batch Mode on Rowstore eliminates the need for Columnstore Indexes in SQL Server, comparing performance and compression.
Explores SQL Server 2019's improved DBCC CLONEDATABASE command for automatically extracting Columnstore Index statistics into a cloned database.
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.
