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.
Introduces a custom stored procedure for estimating compression savings for SQL Server Columnstore Indexes, filling a gap in native tooling.
Author shares excitement about being selected to speak at PASS Summit 2018 on SQL Server Columnstore index selection.
A deep dive into SQL Server Columnstore Index wait types, explaining their groups and providing setup for analysis.
Columnstore Indexes are now available on the Standard Tier of Azure SQL Database, enabling better compression and performance for data warehousing.
A deep dive into SQL Server's In-Memory technologies, including Columnstore Indexes and In-Memory OLTP, presented at a tech conference.
