PASS BI VC: How to (not) torment your fellow SSIS developer?

On November 17th 2PM CET I will redo my SQL Server Days presentation How to (not) torment your fellow SSIS...

Overview of Published Articles – 2014Q3

Here is an overview of the articles I published in the third quarter of 2014.
INTENSE SCHOOL
MCSE Prep (SQL) – Using Parameters...

Beware the defaults! (in windowing functions)

Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the...

T-SQL Tuesday #59: My Hero

This month’s T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show).

Ada...

SQL Server Days 2014 – Slide deck

SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers!...

The Magic Alt Button

Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What...

Stupid me #4 – The login is from an untrusted domain

After quite a while it has finally returned: another Stupid Me™®©! A reminder:
Every time I do something “stupid”, which happens...

Tableau Data Visualization Cookbook – Review

After my review of Tableau Dashboard Cookbook, I read another book about Tableau, namely Tableau Data Visualization Cookbook by Ashutosh...

Modeling the Agile Data Warehouse with Data Vault – Review

A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a...

Creating a Matrix Infographic in SSRS

With “Matrix Infographic” I simply mean those infographics FiveThirtyEight (site | Twitter), the website of statistic revelation Nate Silver, uses to...