T-SQL Tuesday #176: one piece of advice you wish past you had.

It's that time of the month again where all of us bloggers (new, senior and everyone in between) get a new topic to write about. This month Louis Davidson asks us to write about what current me would give as advice to past me when I was starting in the data platform world. So let's … Continue reading T-SQL Tuesday #176: one piece of advice you wish past you had.

Understanding Cross Workspace Data Transfer in Microsoft Fabric

When you open Fabric, the first thing you need to do is choose a so-called workspace. This serves as a container for all your Fabric items. You can have one or more workspaces and the design is entirely up to you. From one workspace to rule them all to one workspace for each set of … Continue reading Understanding Cross Workspace Data Transfer in Microsoft Fabric

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