Make sure you spend the whole day learning about the most important technology Microsoft has launched since the beginning of SQL Server - Columnstore Indexes. We will investigate how you can optimise your BI & DataWarehousing solutions and take the advantage of the modern Columnstore Architecture significantly boosting your query performance and analytics reporting.
Learn how to get the very best out of your existing database environments and how you can monitor, optimise, implement and solve many Columnstore Indexing problems.
Discover how to take the full advantage of the Batch Processing mode for Columnstore Indexes, which can significantly accelerate your query processing by hundreds of times, and learn about its limits.
Through the use of Dynamic Management Views, Extended Events and Traceflags we shall analyse traditional Rowstore tables and turn them into highly-performing modern Columnstore tables that will provide the best query performance possible with the current technology on offer. Using different advanced optimisation techniques we shall boost the performance of Columnstore Indexes further by clustering them into adaptive structures using better Segment Partitioning and lowering their memory requirements.
During the full day workshop we shall consider many different scenarios such as :
- When Columnstore Indexes should be applied on Fact tables.
- When Columnstore Indexes can be applied on the Dimension tables.
- Which conditions we can apply Clustered Columnstore Indexes even for the OLTP scenarios.
- When not to use Columnstore Indexes.
- Design Patterns for the Columnstore Indexes tuning.
If you are serious about SQL Server query performance and want to learn when, how and why you should utilise this exiting new technology then this session is for you!
||Thursday 10th September
||300 – Normal (attendees may require a working knowledge)
||Business Intelligence Professionals, Data Warehouse Professionals, Software Architects & DBAs supporting BI/DWH solutions or Developers who are dealing with Big Reporting Solutions.
||Ranging from £100.00 (Super-Early Bird) to £140.00 (Late Bird) + booking fee + VAT
||Cambridge City Hotel, Downing St, Cambridge. England CB2 3DT.
Basic knowledge of the traditional SQL Server architecture.
A general understanding of Execution Plans, DMVs & Extended Events will provide an advantage.
Niko Neugebauer works at OH22 as a BI Consultant and is a well respected and popular SQL Server MVP with over 20 years of experience in IT and an expert in SQL Server Columnstore technology having most recently authored his Columnstore blog series which currently numbers over 50 posts on the subject.
He is passionate about Data Platform and Community and is the founder & the leader of the Portuguese SQL Server User Group, the organiser of the first ever SQLSaturday outside of North America – #78 Portugal.
Niko has previously presented at many conferences around the world including the PASS Summit, SQLRally Nordic & Amsterdam, SQLBits and numerous SQLSaturdays.