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
Yes I know, clickbaity cheesy title. This blog is a bit like that, but maybe you'll learn something as well. Issue In short, what I was facing today was a trial migration from System A to System B. Which means that data has to flow from one system to the other. System A is a … Continue reading Not every SQL is created equal
Every now and then a special event comes up where you can’t help but think “I really, really want to be there”. This happened to me with Data Moshpit in Berlin and again with Fabric February. When the first information dropped, I was waiting for both the call for speakers and the ticket sales. There … Continue reading Speaking experiences at Fabric February, Oslo
Today I took the Implementing Analytics Solutions Using Microsoft Fabric exam and in this blogpost I'll write about my experiences and feelings. There are other blogposts out there for you to read and compare experiences. Remember that all of these are personal views on the exams and opinions can differ. Preparation There's no way you'll … Continue reading Microsoft DP-600 exam (beta) experiences
If you've been having fun with Microsoft Fabric, chances are you've been playing around with the F64 capacity trial. This one is given to you by Microsoft for free but, since the GA data, the timer attached to it is counting down the days until you need to buy your own. Most blogs I've read … Continue reading Microsoft Fabric, comparing the F2 with the preview F64
It's the end of the year and we've all been bombarded with lists. From november on, things like Spotify wrapped started appearing (even though the year hadn't ended yet). It feels like the last month doesn't count anymore, even though there's a lot that can be done in december. That's why I'm waiting until the … Continue reading 2023 in review, 2024 in preview
Or maybe I should say, with some complications. Or challenges. When I got the job to restore a bacpac file, I didn't think much of it. Because it's quite easy. Get the bacpac and restore it with Azure Data Studio or Sql Server Management Studio. Get coffee, done. Then I got these requirements: The bacpac … Continue reading Restoring a bacpac file, but differently.
Or, how SQL Server behaved differently than I expected but managed to process quite a lot of rows before giving up. Let's begin We have a customer that would like to see the actual value of their stock in a table. They buy their stock at different times and at different prices. Calculating the stock … Continue reading SQL Server Common Table Expressions, a tale.
Last week the big announcement came at Microsoft Ignite, Fabric is GA. Very cool, a lot of noise again for this shiny toolbox, but do we need to abandon everything and focus solely on the new toys? Before I'll answer that question, let's look at a few moving parts of Fabric. Integration The most important … Continue reading Microsoft Fabric GA, and now?
In my previous blogpost (Click here to read) I wrote about a query that just wouldn't go parallel. This sparked some discussion and interest from a few people who were very kind and helpful with their suggestions and even deep dives into the query plans, execution statistics etc. To make one thing very clear, this … Continue reading Why won’t you go parallel, part 2
Reitse's blog 