Microsoft Fabric Dataflow Gen2: In-depth Performance Evaluation and Capacity Insights

In my previous blogs, I've been hammering Fabric with data from some different angles. Either with the Copy dataflows, notebooks, Pipelines, Data Warehouse SQL scripts or in PowerBI.This time, I'm going to make the dataflow Gen2 work for it's money. As usual, I'm using the F2 capacity as it's the one that should break the … Continue reading Microsoft Fabric Dataflow Gen2: In-depth Performance Evaluation and Capacity Insights →

Fabric Lakehouse Data Ingestion: CSV vs. SQL Scenarios

This blog will be a quite short one compared to the other blogs as it's more of an overview to show you the capacity of Fabric ingesting CSV files in their native format into a Lakehouse and ingesting SQL data into a table structure inside the Lakehouse. Simple, straightforward stuff without any form of modification. … Continue reading Fabric Lakehouse Data Ingestion: CSV vs. SQL Scenarios →

Testing Microsoft Fabric Capacity: Data Warehouse vs Lakehouse Performance

I just can't seem to stop doing this, checking the limits of Microsoft Fabric. In this instalment I'll try and find some limits on the data warehouse experience and compare them with the Lakehouse experience. The data warehouse is a bit different compared to the Lakehouse, so I'll be digging into that one first. Then … Continue reading Testing Microsoft Fabric Capacity: Data Warehouse vs Lakehouse Performance →

Speaking experiences at Data Saturday Stockholm 2024

After the amazing experience speaking and attending Data Grillen, this event came quite quickly. Run by Daniel Hutmacher and his amazing wife Ewa, it's the yearly get together of data people in Stockholm This year the event was extra special for me as I was in a co-presenter role. Together with Valerie Junk, we submitted … Continue reading Speaking experiences at Data Saturday Stockholm 2024 →

Attending and speaking at Datagrillen 2024

I've just returned from Lingen, Germany after the DataGrillen event. This year, I wasn't only attending (which you should do as it is one of the best events) but for the first time, I was also selected as a speaker. Speaker dinner The evening before the event, there was the speaker dinner. It was a … Continue reading Attending and speaking at Datagrillen 2024 →

T-SQL Tuesday 174 – My favorite job interview question

For this month, Kevin Feasel asked us what our favourite job interview question is. And I'll be honest, it isn't a question. Because answering questions is all fun and games but is it really that much more? I can dig myself deep into a lot of books, prepare myself for the interview and, like an … Continue reading T-SQL Tuesday 174 – My favorite job interview question →

Mind your collation!

Blog alert! My colleague recently came to me with a fun challenge: why is their SQL Server Hashbytes conversion not working as expected? After some digging, I discovered significant differences between text data types when converting them. Check out my latest blog post to learn more about this interesting topic. #SQL #datahashing #techtalk #SqlServer #Microsoft

Fabric Conference key note first thoughts

Blog Alert! Arun Ulag shared some neat new developments on #MicrosoftFabric at the keynote. Here are my first thoughts on them! #mvpbuzz #FabCon

MVP Summit 2024 experience

If you're active on any form of social media, you've probable seen that a lot of MVP's (Microsoft Most Valuable Professional) have been connecting with the mothership in Redmond, Washington. As I was awarded this january, it's my first time at the Microsoft headquarters and coincidentally also my first time in the United States. Flying … Continue reading MVP Summit 2024 experience →

Loadtesting Fabric part 2, bringing Pain to Powerbi

In my previous blog on Fabric and loadtesting, I ended with not really knowing how PowerBI would respond to all these rows. After creating and presenting a session on this subject, it's time to dig into this part of Fabric as well. There were questions and I made promises. So here goes! This blog will … Continue reading Loadtesting Fabric part 2, bringing Pain to Powerbi →