Koen Verbeeck

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

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)

807 reads

T-SQL Tuesday #121: Gifts received for this year

• by Koen Verbeeck

• Koen Verbeeck

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

2019-12-24 (first published: 2019-12-10)

222 reads

Refresh Power BI Dataset using Logic Apps

• by Koen Verbeeck

• Koen Verbeeck

A recent blog on the Power BI website announced the availability of a preview component in Microsoft Flow, which allows to easily refresh a specific dataset. This is good...

2019-10-24

94 reads

Cool Stuff in Snowflake – Part 10: RATIO_TO_REPORT

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

2019-10-10 (first published: 2019-10-02)

425 reads

Restarting SQL Server after adding a new SQL login

• by Koen Verbeeck

• Koen Verbeeck

At a project, we asked if we could get a SQL Server login/user so we could make a connection from an Apache Airflow pipeline to the SQL Server instance....

2019-09-24

112 reads

Speaking Engagements End 2019

• by Koen Verbeeck

• Koen Verbeeck

Currently I have two conferences in the pipeline. The first is our local DataMinds Connect, the biggest Microsoft data platform conference of the BeNeLux. I’ll be giving a session...

2019-09-12

4 reads

What’s in the pipeline for Power BI?

• by Koen Verbeeck

• Koen Verbeeck

If you’re interested in Power BI (or the Power platform in general), you might be interested in checking out the release overview guides of “2019 release wave 2” for...

2019-09-02

158 reads

The Azure-SSIS IR Startup Time

• by Koen Verbeeck

• Koen Verbeeck

If you want to run SSIS packages in Azure Data Factory, you need the Azure SSIS Integration Runtime (quite the mouthful), which is basically a cluster of virtual machines...

2019-07-09 (first published: 2019-06-19)

310 reads

Cool Stuff in Snowflake – Part 9: ILIKE

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

2019-07-02 (first published: 2019-06-18)

545 reads