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

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

T-SQL Tuesday #68: Just say No to Defaults

It’s the second tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know...

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

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

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

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

How to drop a Temporal Table

No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or...