Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy

Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the...

Drop a temporal table

Speaking at SQL Server Days 2015

I have the great pleasure to announce I’m speaking for the 5th time at the Belgian SQL Server Days! The...

Power BI Confusion

Just a quick post on some Power BI material that I believe should reach as many people as possible. I get...

Thoughts on Power Query and SSIS

Recently I received a very interesting question on Twitter from Jeremy (blog | twitter):
@jmarx definitely yes
— Koen Verbeeck (@Ko_Ver) July 10,...

100th post

This is my 100th blog post here at LessthanDot!

(I’m not lying, check for yourself)

I started blogging at the end of...

Reblog: What’s the deal with Excel and SSIS?

SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to...

Doing a Full Outer Join in Power Query

A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities...

Overview of Published Articles – 2015Q2

Here is an overview of the articles I published in the secondt quarter of 2015.
INTENSE SCHOOL
Book Review: Query Tuning & Optimization by...

Hello world!

Hi there!
Although this looks like my first blog post, it actually isn’t. This is the new place for my blog,...