Friday, 29 June 2018

Upcoming event - PowerBI Days

Just got my session confirmed for Power BI Days 2018 - Belgium on the 23rd of September.


Should be an epic event.


More info at http://www.powerbidays.com/

Wednesday, 27 June 2018

Sunday, 24 June 2018

Oh my Gawd I can't believe that I missed that!!

Iv'e been working on this customer data take-on procedure this whole weekend (last 36h with 3h sleep)
and there is this one part that was just taking forever.. 

The efficient delete... that now had become ULTRA inefficient...


Below is a Video on how I solved it and what the actual problem was, so if you are interested in solving SQL problems take a look:




Monday, 18 June 2018

How to create Delta Load Patterns in SSIS

Below is a video tutorial on how to create a Delta incremental pattern in SSIS

Source code for the demo is in the video description.

Saturday, 16 June 2018

How to avoid Pagelocks in large deletes

Here is a video I made about Deleting data from large tables, code samples in the video description.




Friday, 15 June 2018

Using PowerBI Desktop as an IDE

Its been a while since i posted anything here, but here goes nothing, below is a Video that I made as a DevOps / IDE tutorial for PowerBI, Enjoy.