SSRS and MDX: Think about Cell Properties

I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you...

Power BI Service error: “This visual has unrecognized fields”

Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power...

Dynamic Security in Power BI

UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post.
In...

Loading Data into Clustered Columnstore Index with SSIS

I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is...

Overview of Published Articles – 2016Q1

Here is an overview of the articles I published in the first quarter of 2016.
R Services series:
SQL Server 2016 R Services:...

SSIS Trick: Adding Multiple Packages to a Project

A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing...

SQLSaturday Belgium: slidedeck

The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially...

Nested Display Folders in SSAS

Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is...

Reblog: MDS – A Database Error Has Occurred

I recently came across the following error message when I tried to look at the batches in the Integration Management...

Webinar – SQL Server BI Best Practices

I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.

The title is SQL Server BI Best Practices and its...