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

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

SQL Server 2016 CTP 2.1 has been released

Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and...

My first SQL 2016 bug

A little while back SQL Server 2016 CTP2 was announced and I have spent some time playing with it (read: spent...

Demystifying Power BI – slidedeck

ITPROceed has come to an end and what a great event it was. Kudos to the organizers and all the...