SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default…
I'm delighted to announce that I'll be giving a session at this year's ITPROceed. For those who don't know this…
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…