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.
It's the end of the year, a time to reflect, look back and, as Kay Sauter asked, thank people. As it's easy to forget in our hectic days, a topic like this one is great to take a step back and think about it. I also find it quite difficult (perfectionist) as I don't want … Continue reading T-SQL Tuesday 169 – Thank you
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
With an unsatisfying end. Intro So what's up this time. Our client has moved to Azure in classic lift and shift scenario. Well, almost. They've deployed new VM's and installed SQL Server 2019 Standard in nice DTAP setting. The VM's are standard E16-4as-v4 SKU. 4 vcpus and 128 GB memory. The disks are Premium SSD … Continue reading Why won’t you go parallel, a curious case of a stubborn query.
Have you seen the adverts in your social media about pip decks and wondered what it's all about? I have, I have fallen for it and I will share my impressions. As a full disclosure, I have bought the decks and am in no way sponsored by or affiliated with the Pip decks company. I've … Continue reading Pip Decks Storyteller Tactics, an opinionated review
This monday, I was lucky enough to attend the Fabric level 300 precon at dataMindsConnect. If you ever have the chance to go there, do it! It's very well organised, the sessions are amazing and so are all the people there. But that's not what this blog is about; today a Twitter thread started on … Continue reading Microsoft Fabric, capacity usage and a design
About two weeks ago I had the immense pleasure of speaking in Berlin for the first time. Now, I'm used to regular events like data saturday's and SQL Bits or dataMinds Connect as outliers because they're larger and different events. But speaking at this one is on a whole different level. As you might gather … Continue reading Speaking experiences at Data Moshpit (Berlin, Germany)
Reitse's blog 