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

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

Not every SQL is created equal

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

SQL Bits is coming!

In case you missed it, in a few weeks, SQL Bits is happening. This year it's quite close to London in the town of Farnborough. This place keeps sticking in my head as Farnham leading to the song 'you're the voice'. But let's not digress. SQL Bits 2024! If you've never been to SQL Bits, … Continue reading SQL Bits is coming!

Speaking experiences at Fabric February, Oslo

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

Microsoft DP-600 exam (beta) experiences

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

Speaking experiences at MCT Summit Europe 2024

This week I was at the MCT Summit Europe in Rijswijk. An event quite close by for a change, which was quite nice. The event is for Microsoft Certified Trainers only which on one hand limits the amount of people being able to attend, on the other hand it gives a good insight in the … Continue reading Speaking experiences at MCT Summit Europe 2024

T-SQL Tuesday 170 write up: learning from abandoned projects

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