Columnstore Indexes: Practical Solutions & Techniques (Niko Neugebauer)

Learn practical Columnstore Indexes tips and tricks such as which type to use, how and when to use Disk-Based vs. In-Memory or Clustered vs. Nonclustered, how to load data into Columnstore in the most efficient way, and how to get the best performance possible out of the Batch Execution Mode.

With a nod to each of the available SQL Server versions (2012, 2014, 2016, 2017, 2019 and the Azure SQLDB), this full day session focuses on practical solutions and applications of Columnstore Indexes and the Batch Execution Mode. We also review the limitations of both and learn how to solve some of those limitations.

Covering all available relational engines supporting Columnstore Indexes (including parts of the SQL DataWarehouse), this pre-conference will give you insight on why and when to use Columnstore Indexes, and when to take a step back and use a different type of technology.

Presented by:

Niko Neugebauer, Data Platform Consultant, Claranet

Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.