It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the past year. So what do I have to be thankful for? A couple of quick thoughts: Power BI Desktop finally has included the decomposition tree visualization! It was the last piece of the puzzel: PerformancePoint […]
Category: Varia
Cool Stuff in Snowflake – Part 5: Finding Previous Non Null Value
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 something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. Sometimes you need to find the […]
Cool Stuff in Snowflake – Part 4: Aliasing all the things
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 something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. In this post I’ll talk about […]
Cool Stuff in Snowflake – Part 3: SPLIT and FLATTEN
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 something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. Let’s start with SPLIT. […]
Cool Stuff in Snowflake – Part 2: LISTAGG
I’m starting a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. This blog post talks about the […]
Happy 2019!
As I’m writing this it’s actually still 2018, so this is both my last blog post of the year and the first blog post of the new year 🙂 I’d like to take the opportunity to wish everyone a great start in this new year, and that everything you wish for – professionally and personally […]
T-SQL Tuesday #100!
The monthly blog party is back and we’ve reached the mythical number 100. The host of this month is the Creator himself: Adam Machanic (blog | twitter). The topic is the future: what will the world be like when it’s T-SQL Tuesday #200? The very first T-SQL Tuesday was over eight years ago, which was […]
dataMinds Connect 2017 – And The Winner Is?
Last week I had the privilege to host a little contest to give away one free ticket to dataMinds Connect 2017, the biggest Microsoft Data Platform conference in the Benelux. There was a prize question you had to answer: How many versions of SQL Server have I worked with? The answer is: 7 different versions. […]
Microsoft Professional Program in Data Science – The Road So Far
I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open Online Course), all provided through the edX platform. You are free to participate, but for a verified certificate you will need to pay (and Microsoft/edX has bumped up the price from $49 to $99 for some […]
Microsoft Data Platform MVP Award
I’m very pleased, humbled, surprised and overall gleeful to announce I’m awarded the Microsoft Data Platform MVP 2017 Award. This is a great honor and I’m grateful for all the support I’ve received of Microsoft, my peers and the SQL Server community over the past years. I’d like to take this moment to thank you […]