Microsoft Fabric: setting your spark compute pool size

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

Microsoft Fabric, deployment pipelines

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

Speaking experiences at Data Saturday Rheinland (Bonn, Germany)

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)

Building an auto deny on meeting requests in Power Automate

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

Using Github Actions to deploy Azure resources with Terraform

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

Notebook exit code 137. Cause and solution

Yes, I've been at it again with Microsoft Fabric, and as I'm trying to find the limits of this new cool toy, the limits sometimes get angry with me and throw an error. Most of the time this error is caused by me and I can usually figure out what's happening, but not always. Exit … Continue reading Notebook exit code 137. Cause and solution

Microsoft Fabric, Notebook logs

Captains log, stardate... No, wrong opening. I reported an issue yesterday with Microsoft Support and during the following call today (they're really quick to set up an initial meeting), the support engineer showed me where I can find a lot of logging information.Suppose you've got a notebook that has been run a few times. The … Continue reading Microsoft Fabric, Notebook logs

Getting on-premises data into Microsoft Fabric using the data gateway

In a blog from a few weeks ago, I wrote about getting data from your on-prem SQL Server into Fabric. At the time, the only option for a copy dataflow was using a direct connection over the internet. It still is, but now you can also use the PowerBI Data Gateway to get data from … Continue reading Getting on-premises data into Microsoft Fabric using the data gateway

Microsoft Fabric: shortcuts and table clones

A few days ago, I heard the term table clone for the first time, it's preview release date was to be confirmed and I had no idea what it was about. Two days later, a video emerged where the table clone was explained on a high level. At that point, I started to wonder what … Continue reading Microsoft Fabric: shortcuts and table clones

T-SQL Tuesday #164: Code that made you feel a way

This month, Erik Darling (T | L | B) asks us to write about code that made us feel a way. Rule is, it can't be your own code. That's good, because that usually makes me a bit sad when I review it. The moment I write it, I think it's brilliant though ;). Most … Continue reading T-SQL Tuesday #164: Code that made you feel a way