Datawarehouse Lightning Performance with Columnstore!

12/04/2018 - Microsoft
Leonardo Da Vincilaan 3

During this session we will be talking about Columnstore Indexes and how to use them. We will be showing you tips & tricks on how to get the performance you want out of Columnstore.

We will show you the concepts on how to efficiently load data to your Columnstore tables, how to get your Columnstore properly created and some dangers with performance you might face when working with Columnstore Indexes as seen in the field!

After this session things like segment elimination, auto adjust buffer size, Delta Store, … will no longer be a mysterious concept for you and you will be ready to start implementing the different flavors of Columnstore Indexes in your environment.

Speakers

Stijn Wynants

Data Platform Consultant

Stijn is an independent Data Platform Consultant & DataMinds (Belgian Data Platform User Group) core member. He is also one of the organisers of the local user group sessions & the yearly event called DataMinds Connect (SQL Server Days). He spents his days tuning SQL Servers & solving problems with the data platform. He is primarily a DBA consultant, but has also done various BI & ETL projects. He gets his kicks out of Columnstore indexes & tuning queries but shivers at the sight of an SSAS cube.

When Stijn is not working with SQL Server, you can probably find him enjoying the local cuisine & local beers or enjoying time with his wife and his dog.