Niko Neugebauer is a Data Professional. A SQL Server MVP with over 20 years of experience in IT, he is passionate about Data Platform and Community. 
Founder of the Portuguese SQL Server User Group, the organiser of the first SQLSaturday outside of North America – #78 Portugal, Niko presented at a lot of events such as PASS Summit, SQLRally, SQLBits, SQLSaturdays around the world.
He loves sharing and is an author of blog series with 130+ posts on the Columnstore Indexes.
Niko Neugebauer has submitted 6 sessions for SQLBits 2020, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Columnstore Indexes were launched in SQL Server 2012 and greatly enhanced in 2014 & 2016 - but if you thought that Microsoft was done with them - you are missing a lot of important improvements that were added.
With the grow of the SQL Graph surface in 2017-2019 (incl. the ShortestPath() function) we have a chance to do some pretty exciting calculations and start analysing different types of Networks such as the Social ones.
Even though Azure SQL Database/Managed DB are offered as a PaaS, you should consider monitoring your database for a lot of good reasons. Discover how to monitor & audit the cloud offers efficiently.
Columnstore Indexes were launched in SQL Server 2012 and greatly enhanced in 2014 & 2016 - but if you thought that Microsoft was done with them - you are missing a lot of important improvements that were added.
With the grow of the SQL Graph surface in 2017-2019 (incl. the ShortestPath() function) we have a chance to do some pretty exciting calculations and start analysing different types of Networks such as the Social ones.
Even though Azure SQL Database/Managed DB are offered as a PaaS, you should consider monitoring your database for a lot of good reasons. Discover how to monitor & audit the cloud offers efficiently.

Sessions

Previous Sessions

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.
Learn in just a bit over an hour how to use CISL (open source Columnstore Indexes Library) for getting deep insights on the Columnstore Indexes and how to use its maintenance solution for keeping Columnstore Indexes performing at their maximum speed.
Have you ever considered a situation where Columnstore Index can be quite the opposite of what one expect from it? A slow, wasteful source of painfully slow queries, lagging the performance, consuming irresponsible amount of resources ...
With increasing speed in relational query execution classical analytical solutions get challenged more and more. Why loose time for processing data into multi-dimensional databases? Why analyze outdated data if you can have fresh data instead?
Learn in 75 Minutes what Batch Execution Mode is, when & how it will affect your workloads (in upcoming SQL Server 2019 & Azure SQLDB) on the traditional Rowstore Indexes.
Niko_Neugebauer310927.jpg