Clustered Columnstore Index really hates Updates

First a little background. I’m working on a large fact table that behaves itself as a slowly changing type 2...

Master Data Services Error – Missing Temp Directory

I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had...

SSIS Naming Conventions 2.0

People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server...

Problem where you can only browse Google websites

Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution...

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...