Reblog: The shaky bug in SSIS

SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this...

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

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