Speaking at DataMinds Connect 2020

• by Koen Verbeeck

• Koen Verbeeck

I’m delighted to announce I’ll be speaking again at DataMinds Connect this year, one of the greatest and best Microsoft Data Platform conferences on the European mainland. Due to...

2020-08-04

5 reads

New Management Hub in Azure Data Factory

• by Koen Verbeeck

• Koen Verbeeck

I wanted to manually start an Azure-SSIS Integration Runtime in ADF, so I went to the edit section and then to connections. But instead of showing me my linked...

2020-06-25 (first published: 2020-06-11)

229 reads

Cool Stuff in Snowflake – Part 12: IS DISTINCT FROM

• 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-05-13 (first published: 2020-04-29)

446 reads

Speaking at GroupBy Conference – Spring 2020

• by Koen Verbeeck

• Koen Verbeeck

I’m excited to announce I’ll be speaking at the virtual GroupBy conference this year. Thanks everyone who voted! I’ll be speaking at the European day on May 12th at...

2020-05-06

8 reads

Switching between different Azure Data Factory environments

• by Koen Verbeeck

• Koen Verbeeck

When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately,...

2020-04-21 (first published: 2020-04-08)

272 reads

Vote for GroupBy Conference May 2020

• by Koen Verbeeck

• Koen Verbeeck

GroupBy is a virtual conference, for the community and by the community. Content is focused on the Microsoft Data Platform. Speakers can submit sessions for two events: GroupBy Europe...

2020-04-14

13 reads

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

460 reads

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

19 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)

437 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

67 reads