In my previous blogpost (Click here to read) I wrote about a query that just wouldn't go parallel. This sparked some discussion and interest from a few people who were very kind and helpful with their suggestions and even deep dives into the query plans, execution statistics etc. To make one thing very clear, this … Continue reading Why won’t you go parallel, part 2
With an unsatisfying end. Intro So what's up this time. Our client has moved to Azure in classic lift and shift scenario. Well, almost. They've deployed new VM's and installed SQL Server 2019 Standard in nice DTAP setting. The VM's are standard E16-4as-v4 SKU. 4 vcpus and 128 GB memory. The disks are Premium SSD … Continue reading Why won’t you go parallel, a curious case of a stubborn query.
Have you seen the adverts in your social media about pip decks and wondered what it's all about? I have, I have fallen for it and I will share my impressions. As a full disclosure, I have bought the decks and am in no way sponsored by or affiliated with the Pip decks company. I've … Continue reading Pip Decks Storyteller Tactics, an opinionated review
This monday, I was lucky enough to attend the Fabric level 300 precon at dataMindsConnect. If you ever have the chance to go there, do it! It's very well organised, the sessions are amazing and so are all the people there. But that's not what this blog is about; today a Twitter thread started on … Continue reading Microsoft Fabric, capacity usage and a design
About two weeks ago I had the immense pleasure of speaking in Berlin for the first time. Now, I'm used to regular events like data saturday's and SQL Bits or dataMinds Connect as outliers because they're larger and different events. But speaking at this one is on a whole different level. As you might gather … Continue reading Speaking experiences at Data Moshpit (Berlin, Germany)
This next blog won't be a long one and will probably serve most as a reminder for myself where to find the settings for the Spark compute pool. When you create a workspace, you get the default starter pool and it has taken me way longer than I care to admit to find where to … Continue reading Microsoft Fabric: setting your spark compute pool size
It's a bit of a challenge to keep up with all the changes, updates and all the new stuff coming out for Fabric. As I'm not really invested in the PowerBI part of the data platform (yay pie charts ;)), some things that are very common for the PowerBI community are very new to me. … Continue reading Microsoft Fabric, deployment pipelines
This blog has been seriously overdue but I wanted to share my experiences on speaking at this event. Beforehand, I heard a few stories of this being a nice, cozy and well-organised event. When confirmation came of my session being selected, it was quickly followed by an email that contained answers to all the questions … Continue reading Speaking experiences at Data Saturday Rheinland (Bonn, Germany)
Now this is something completely different. I've never used Power Automate before and would never have thought to use it if it hadn't been for the 101 session by Alexander Klein at datasaturday Gothenburg. Issue For some reason, people like to invite me to meetings. That's OK if I can add to the fun, but … Continue reading Building an auto deny on meeting requests in Power Automate
Now, that's a title with a lot of terms. Github Actions You'll probably know Github as the website where you can store your code, be agile with all sorts of branches, merges etc and keep track of your issues. There are also actions which are roughly the same as Azure DevOps pipelines. Written in Yaml … Continue reading Using Github Actions to deploy Azure resources with Terraform
Reitse's blog 