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
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
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
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
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
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
I was teaching a class and during an interesting discussing an attendee told me that views with a filter took a long time to produce results, even if the result set itself was quite small. I wanted to test this out for myself to see what was happening. I'll take you along this short journey … Continue reading View with a where clause
In my previous blogs, I've written about Fabric and all the cool things it can do. Thing is, my load tests were based on files. Either CSV or Delta. But in reality, a lot of data comes from an on-premises database server. In reality, you might connect to a SQL 2008 instance or maybe even … Continue reading Microsoft Fabric, connect to your on-premises SQL Server
Reitse's blog 