Overview of Published Articles – 2016Q2

9 years ago

Here is an overview of the articles I published in the second quarter of 2016, which were all focused on the…

Slidedeck ITPROceed – Power BI Status Update

9 years ago

I uploaded my slidedeck from the ITPROceed event to Onedrive. For the abstract, see the blog post Speaking about Power…

My first SQL Server 2016 POC

9 years ago

Very, very recently I did my first Proof Of Concept (POC) with SQL Server 2016. At an actual client of…

Conditional Formatting and Quick Calcs in Power BI Desktop

9 years ago

There's a new update out of Power BI Desktop (May 2016), but at the time of writing there's no official…

Reblog: Unexpected result with the File System Task

9 years ago

SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default…

Speaking about Power BI @ ITPROceed 2016

9 years ago

I'm delighted to announce that I'll be giving a session at this year's ITPROceed. For those who don't know this…

SSRS and MDX: Think about Cell Properties

9 years ago

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

Dynamic Security in Power BI

9 years ago

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

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

9 years ago

UPDATE: IT SEEMS THE BUG HAS NOW BEEN FIXED. THREE HOORAYS FOR THE POWER BI TEAM! Recently I stumbled across…

Loading Data into Clustered Columnstore Index with SSIS

9 years ago

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