SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Columnstore Indexes - from basics to optimised analytics
Description
Learn Columnstore Indexes in just 1 day starting with basics of the structure and stepping into the internal details, learning how to load data into them and finishing with advanced concepts of Batch Mode processing and performance tuning.
Microsoft added first implementation for the Columnstore Indexes in SQL Server 2012 with Nonclustered Columnstore, and SQL Server 2014 brought us updatable Clustered Columnstore Indexes, while SQL Server 2016 is adding 2 new areas with the updatable Nonclustered Columnstore Indexes - Operational Analytics and Operational Analytics InMemory.
The first addition relates to the traditional row-based storage, while the Operational Analytics InMemory focuses on the integration with the InMemory technology in SQL Server (also known as Hekaton).
This training day is all about differences in implementations, their advantages and limitations and how to get the best out of the all types and incarnations of the Columnstore Indexes.
Microsoft added first implementation for the Columnstore Indexes in SQL Server 2012 with Nonclustered Columnstore, and SQL Server 2014 brought us updatable Clustered Columnstore Indexes, while SQL Server 2016 is adding 2 new areas with the updatable Nonclustered Columnstore Indexes - Operational Analytics and Operational Analytics InMemory.
The first addition relates to the traditional row-based storage, while the Operational Analytics InMemory focuses on the integration with the InMemory technology in SQL Server (also known as Hekaton).
This training day is all about differences in implementations, their advantages and limitations and how to get the best out of the all types and incarnations of the Columnstore Indexes.
Learning Objectives
Previous Experience
Tech Covered
performance, Analytics