Koen Verbeeck

Reading a SharePoint List with Azure Logic App

• by Koen Verbeeck

• Koen Verbeeck

Sometimes in life you have to do things you really don’t like to do. Such as extracting data from a SharePoint List. Usually I use SSIS and the OData...

2020-04-07

Quickly Editing Data in SSMS

• by Koen Verbeeck

• Koen Verbeeck

WARNING: do not do this in production. A quick blog post on a SSMS trick: how to quickly edit data. Sometimes you directly want to manipulate data without having...

2020-04-02

16 reads

SUMX returns incorrect results with duplicates

• by Koen Verbeeck

• Koen Verbeeck

Okay, the title of this blog post could also have been “SUMX returns unexpected results with duplicates”. The results only seem incorrect because an incorrect assumption might have been...

2020-03-02 (first published: 2020-02-27)

414 reads

Cool Stuff in Snowflake – Part 11: RESULT_SCAN

• by Koen Verbeeck

• Koen Verbeeck

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

2020-02-04

27 reads

Cool Stuff in Snowflake – Part 11: RESULT_SCAN

• by Koen Verbeeck

• Koen Verbeeck

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

2020-02-04

1 reads

Author of the Year 2019 Nomination at MSSQLTips

• by Koen Verbeeck

• Koen Verbeeck

This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...

2020-01-27 (first published: 2020-01-21)

205 reads

Author of the Year 2019 Nomination at MSSQLTips

• by Koen Verbeeck

• Koen Verbeeck

This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...

2020-01-21

Cloudbrew 2019 – Slides

• by Koen Verbeeck

• Koen Verbeeck

Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session there were a lot of attendees, which I found...

2019-12-19

12 reads

Cloudbrew 2019 – Slides

• by Koen Verbeeck

• Koen Verbeeck

Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session there were a lot of attendees, which I found...

2019-12-19

Book Review: T-SQL Window Functions by Itzik Ben-Gan

• by Koen Verbeeck

• Koen Verbeeck

A couple of years back Itzik Ben-Gan (the T-SQL guru) wrote the book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. It’s has been one of my most...

2020-01-01 (first published: 2019-12-19)

883 reads