Azure, SQL Server and related stuff. Some Powershell as well.
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
Blog Alert! Arun Ulag shared some neat new developments on #MicrosoftFabric at the keynote. Here are my first thoughts on them! #mvpbuzz #FabCon
When I thought of this subject last year, I was really on the fence if it would work or not. Part of me was convinced it would elicit some response from the community, part of me was convinced people would be looking for a 'happy' start of the year and might not want to think … Continue reading T-SQL Tuesday 170 write up: learning from abandoned projects
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.
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
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
This month, Erik Darling (T | L | B) asks us to write about code that made us feel a way. Rule is, it can't be your own code. That's good, because that usually makes me a bit sad when I review it. The moment I write it, I think it's brilliant though ;). Most … Continue reading T-SQL Tuesday #164: Code that made you feel a way
I was teaching a class and during an interesting discussing an attendee told me that views with a filter took a long time to produce results, even if the result set itself was quite small. I wanted to test this out for myself to see what was happening. I'll take you along this short journey … Continue reading View with a where clause
Reitse's blog 