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

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

403 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

106 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

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

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

534 reads

SQL Server Development Best Practices – Webinar

• by Koen Verbeeck

• Koen Verbeeck

I’m delighted to announce I’ll be giving a webinar for MSSQLTips.com about SQL Server Development Best Practices. Aka writing T-SQL and stuff ?? The webcast is the 13th of...

2019-05-27

25 reads

Migrating SSIS to Azure – Slidedeck (Techorama 2019)

• by Koen Verbeeck

• Koen Verbeeck

Techorama 2019 is over and it was a blast, as usual. Neatly organised, great speakers and fantastic content. I delivered a session on Migrating SSIS to Azure (Data Factory)....

2019-05-25

28 reads

SSIS 2019 has arrived!

• by Koen Verbeeck

• Koen Verbeeck

It is not a joke: SSIS is available for Visual Studio 2019 as a preview. Whoa, hold on. SQL Server 2019 hasn’t been released yet? But there’s already an...

2019-04-25

1,934 reads