I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you…
UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post.…
UPDATE: IT SEEMS THE BUG HAS NOW BEEN FIXED. THREE HOORAYS FOR THE POWER BI TEAM! Recently I stumbled across…
I'm using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is…
Here is an overview of the articles I published in the first quarter of 2016. R Services series: SQL Server 2016…
A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing…
The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially…
Recently it was announced that Power BI would now support the SSAS display folders in "exploration mode". Exploration mode is…
I recently came across the following error message when I tried to look at the batches in the Integration Management…
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016. The title is SQL Server BI Best Practices and…