Niko Neugebauer is a BI Consultant for OH22. A SQL Server MVP with over 15 years experience in IT, he is very passionate about Data Platform and Community. He is a founder and a leader of the Portuguese SQL Server User Group, SQLPort (http://www.sqlport.com). His passion about SQLSaturday led him to organise the first SQLSaturday outside of North America – SQLSaturday #78. Niko has presented at SQLBits, PASS Summit, SQLRally Nordic, and SQLSaturdays all around the world.
In the ideal world, all information and structures are static, but in the real world almost everything is dynamic, and changes are constant. This session reviews different methods for generating MSBI content (SSIS, SSRS) dynamically.
Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes. Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance.Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!
Dive deep into Columnstore Indexes and discover their advantages and some of the limitations.
Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode & Query Processing with another depth.
If you work with an amazing visualisation plugin NodeXL you might have asked yourself the question - how do I get my custom data for getting those great visualisation for analysis.
This session will show you a couple of ways of how to get it done.