I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar will be an introduction to columnstore indexes, which have gained quite some importance since you can now use them in Standard Edition of SQL Server 2016 SP1 or higher.
Title: Supercharge Your SQL Server Data Warehouse with Columnstore Indexes
Abstract:
Thanks to SQL Server 2016 service pack 1, columnstore indexes are now available in Standard Edition. But what are those indexes exactly? What do they do and how can my system benefit from those indexes? In this webcast, Koen will walk you through the basic concepts of these indexes. You’ll learn which types of columnstore indexes there are, how you can integrate them into your data warehouse and what performance gains you can expect. Join this webinar to get up to speed with this amazing technology.
You can register over here.
I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…
You can find the slides for the session Building the €100 data warehouse with the…
I was asked to do a review of the book Microsoft Power BI Performance Best…
This is a quick blog post, mainly so I have the code available if I…
Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…
This book was making its rounds on social media, and the concept seems interesting enough…