Column Stores are a very powerful tool to handle large amounts of data. In this session Thomas guides you through the process of creating a column store, filling it with data and using it in queries. He will do so by taking you along on the journey filled with mistakes he made till he ended up with a well working design. This will help you start using column stores the way they should be used from day one.


Thomas Grohser, SQL Server Infrastructure Architect NTT DATA Americas

Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQL Saturdays, and user groups for 12 years.