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.
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.
