My first SQL Server 2016 POC

8 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

8 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

8 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

8 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

8 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

8 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”

8 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

8 years ago

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

8 years ago

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

SSIS Trick: Adding Multiple Packages to a Project

8 years ago

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