Convert Local Datetime to UTC (pre-SQL Server 2016)

3 years ago

Recently I was working with a client who was still on SQL Server 2012. Support issues aside, there are some…

Speaking at SQLBits 2022

3 years ago

I'm delighted to announce I'll be speaking at the SQLBits conference in March 2022! I'm not delivering one session, but…

Happy 2022

3 years ago

Or is it April 2020? Not sure. Anyway, I'd like to extend my best wishes for the upcoming year. I…

New Argument for STRING_SPLIT Function

3 years ago

A new (optional) argument has been added to STRING_SPLIT: enable_ordinal. Setting it to 1 will add an output column with…

T-SQL Tuesday #143 – Short code examples

3 years ago

It's this time of the month again! T-SQL Tuesday is a monthly blogging party on the second Tuesday. This month's…

Speaking at PASS Data Community Summit

3 years ago

I'm delighted to announce that I've been selected to speak at the (revamped) PASS Data Community Summit. Alas, PASS is…

Webinar – Improve SQL Server Data Quality in SSIS

3 years ago

On the 5th of October 2021 I'll be giving a webinar about improving data quality of contact data (names, addresses,…

Cool Stuff in Snowflake – Part 13: Row-Pattern Recognition

3 years ago

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight…

Speaking at dataMinds Connect 2021

4 years ago

In October I'll be speaking at the dataMinds Connect conference. This event is very dear to me, because it's a…

Upcoming Webinar – Intro to SSIS – Advanced Topics

4 years ago

On July the 22th at 9PM CET I will give the second part of the "Introduction to SSIS" webinar series…