First a little background. I'm working on a large fact table that behaves itself as a slowly changing type 2…
I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had…
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server…
Note: not a SQL/BI related post like usual, but since it's a common issue I want to share my solution…
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 has been released and it is a mayor one! You can download it here.…
Since Power BI is all the rage right now, I was in need of some material to spice up my…
I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016.…
The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises…
In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my…