Calculate a semi-additive average in DAX

A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure...

SQL Server 2016 service pack 1 is here!

SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here.

Why,...

Book Review – Power Pivot and Power BI

Since Power BI is all the rage right now, I was in need of some material to spice up my...

Master Data Services – Database Error has Occured when Publishing Business Rule

I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016....

First thoughts on Power BI on premises

The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises...

Master Data Services error – Cannot read configuration file due to insufficient permissions

In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my...

What’s new in SSRS 2016 – Session Contents

The 2016 edition of the Belgian SQL Server Days is over. It was a blast – as usual – and it was...

My thoughts on Recertifying your MCSE through Microsoft Virtual Academy

A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in...

Overview of Published Articles – 2016Q3

Here is an overview of the articles I published in the third quarter of 2016.
What’s New in SQL Server Integration Services...

Upcoming Webinars: What’s New in SSRS and MDS 2016

I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features...