ColumnStore Index in SQL Server 2016 and Azure SQL Database

The updateable clustered columnstore in Microsoft SQL Server 2016 offers a leading solution for your data warehouse workload with order of magnitude better data compression and query performance over traditional B-Tree based schemas. This session assumes that you understand columnstore technology basics. We will do a deep dive into (a) strategies to load data leveraging minimal logging with concurrency (b) identifying/solving performance issues with queries (c) real-world best practices of keeping columnstore humming along.

Presenter Sunil Agarwal is a seasoned professional with 30+ years of industry experience in databases, Sunil has worked as a developer/lead in the relational database engine technology, a tool designer/lead building backup/restore tools, and as an application developer/manager enabling B2B commerce and e-learning. He has been in his role as a Principal Program Manager for SQL Server for the last 12+ years. Sunil has authored many technical white papers/blogs and has co-authored two books in SQL Server and presented database technologies in numerous national/international conferences. He enjoys teaching and has taught introductory programming courses at the University of Rhode Island and the University of Colorado.

[LinkMassing]

Sunil, I have studied a handful of your demos and you explain things

[andrewp]

Good video, but no wonder not many people explain it or use them as it its rather confusing with lots of gotchas. I learned quite a bit watching that, but only enough to want to know more as am now just dangerous with my loaded column store gun! lol

[kentmaxwell]

Hi! I really enjoyed this video. Where can I find the source code mentioned in the video? Did Sunil ever do the second presentation? If so, where can I find it?