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

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: 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

Microsoft Fabric, impact on my daily work

In my previous four blogposts, I've shared some first impressions and small things I discovered since the preview release. Again, the preview release. New features are added, bugs are fixed and additions are released. When I asked if there's a GA release date, there was no answer. And I can guess why, it's hard to … Continue reading Microsoft Fabric, impact on my daily work

Microsoft Fabric, Data Warehouse first impressions

When Fabric released, there was a lot of noise around it. Many people have written blogs, created YouTube video's and all kinds of other interesting things to share the love of this new tooling. Well, new? Especially when you look at Fabric data warehouse, it's more of an iteration over Synapse Analytics Serverless Pools. As … Continue reading Microsoft Fabric, Data Warehouse first impressions

Microsoft Fabric, connect SQL Server Management Studio, Azure Data Studio or Windows Explorer to your OneLake

Whilst working on a blogpost on Fabric Data Warehouse, I started wondering if I could work around the SQL web interface and connect to my OneLake with SSMS and/or ADS. As it turns out, you can! Find the connection-string To be honest, this was the hardest part as the connection-string is somewhat hidden. In your … Continue reading Microsoft Fabric, connect SQL Server Management Studio, Azure Data Studio or Windows Explorer to your OneLake

Microsoft Fabric, fooling around with TPC-H data

In my previous blog, I wrote about some first impression working with Fabric and mostly following the Lakehouse tutorial provided by Microsoft. Well structured as this one may be, the sizes are not like the sizes I'm seeing in the wild. So I decided to give Fabric a bit more of a challenge by letting … Continue reading Microsoft Fabric, fooling around with TPC-H data

Microsoft Fabric, first impressions

This Week, Microsoft released the new Fabric resource on Azure. It's been hard to miss as many MVP's were tweeting, Mastodoning and sending messages on LinkedIn that Build should not be missed this year. So yeah, it was clear something huge was going to happen. When the announcement came, I was outside. My kid had … Continue reading Microsoft Fabric, first impressions

Learning ADF Part 6

It's been some time since my last post on Azure Data Factory, but I had some fun this week and wanted to share the learnings. This blog will cover how I read files from an sFTP site, use the copy activity if the file hasn't been processed yet and write some data into a table … Continue reading Learning ADF Part 6