Learn how to effectively use Microsoft Fabric to create alerts for specific thresholds in your data platform.

Learn about recent updates in Microsoft Fabric, including features like ALTER TABLE, IDENTITY, and the ANY_VALUE aggregate function.

BAD LUCK! THAT'S MY JOB! I'M A STANDUP COMEDIAN, I'M MEANT TO CHALLENGE PEOPLE! IF YOU DON'T LIKE BEING CHALLENGED, DON'T WATCH MY SHOWS! WHAT'S THE MATTER, GUYS? TOO CHALLENGING FOR YAH? WINNER OF…

Find answers to your SSIS questions in our comprehensive SSIS FAQ guide. Explore integration services and enhance your skills.

Explore Microsoft Fabric Warehouse Query Insights to troubleshoot performance issues in data warehouse operations effectively.

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge - microsoft/sql-server-samples

The slides for my session "The €100 data warehouse on the Azure data platform" can be found on GitHub. It was a calm event, probably because of the good weather outside :)

Explore our SQL Server Integration Services FAQ for insights on SSIS features, licensing, and frequently asked questions.

A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited the community the blog about the idea of what would happen if we would need to go back on-premises, after a good decade of clou...

Alt: A cartoon of two sailors with shovels standing each at the side of a pile of money in front of a burning furnace. They are shovelling the money into the furnace with furious intent. An analogy to the current rage and money fueled haste of the tech industry to burn as much money as possible in the name of some sort of progress. I am not sure if the sailors know where the ship is going, but it doesn't matter, does it? What matters is to shovel as much money as possible into the furnace.

This month the invitation from Koen asks what would happen if we came back from the cloud. Back to On-Prem. Cloud solutions have sliders which magically reduce downtime, performance issues, and acc…

This month’s T-SQL Tuesday topic is a bit of a thought experiment from Koen Verbeeck (blog | bluesky) where he asks us to consider “what would happen if suddenly your company or your cl…

Find answers to common questions in our SSIS FAQ. Learn about Integration Services and its role in data integration.

This month we have a very interesting invitation from Koen Verbeeck. He has hosted once before, and agreed to help me out this month by tackling another topic. We’ve shared a few beers in the EU, though not in some time, so I hopefully will get the chance to buy him a pint and thank him for this month’s invite.

For T-SQL Tuesday #199, Koen Verbeeck posed an excellent question: if your company moved up to the cloud, but after migrating, had to come back on-premises, what would be the big problems? I've had clients in this exact situation! Here are some of my favorite gotchas from those experiences. Buying hardware is really hard right now. AI companies have sucked up all of the available cheap hardware, and the remaining stuff is expensive, hard-to-get, and often delayed.

Happy T-SQL Tuesday! Our host this month is Koen Verbeeck (see his T-SQL Tuesday invitation here) Koen asks an interesting question: So, dear reader, I want you to think about what would happen if suddenly your company or your client asks to build everything on-prem again (or maybe a hybrid architecture). My first reaction to this sentence was: Oh look, he assumes that everyone is in the cloud…

This month, Koen Verbeeck invites the blogging community to write about their thoughts on returning to on-premises. What could be struggles, things we have to re-learn, etcetera. When I read the invite, it immediately sparked inspiration, because there are increasing rumours around cloud exits. People musing about 'what if'. Some clients reference these questions, but so far no one has directly asked me one with the intent of moving forward with it.

It's the second tuesday of the month, which means T-SQL Tuesday time! This month's topic is chosen by myself, and it's inspired by a blog post of Alexander Arvidsson. In a nutshell, I'm asking what we...

It's time for T-SQL Tuesday again! And we're almost to number 200! T-SQL Tuesday is a monthly community blogging event started by Adam Machanic in 2009. Each month a host picks a topic, participants w...

A while ago we suddenly had an error while trying to deploy one Fabric workspace to another using fabric-cicd. The issue was with a GraphQL object and the following error was returned: Failed to pu...

Find answers to your questions with our Azure Data Factory FAQ. Learn about features and limitations of ADF today.

Get answers to your questions in our Azure Data Factory FAQs and learn about data pipelines and integration services.

I'm doing a small series on indexing basics for SQL Server, and on May 14th I'll be presenting the third part which is about columnstore indexes. You can watch the webinar for free, but registration i...

Learn how to improve performance issues in Microsoft Fabric Warehouse and leverage cloud-based data analytics effectively.

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I've managed to run into, twice. I've set up mirroring by creating a connection using a service principal ...

Find answers to your questions in our Microsoft Fabric FAQs. Learn about features and capabilities of this powerful data platform.

I'm starting a webinar series about SQL Server indexing with the fine folks of MSSQLTips.com. Each "episode" will be about 30 minutes long and will feature a certain topic of indexes in SQL Server (or...

Understand how to use DATE_BUCKET SQL command to group dates and calculate averages in T-SQL for your sales data analysis.

LinkedIn is full of absolute trash these days. Just flat out bullshit garbage. (Oh yeah, that - this post should probably come with a language disclaimer, because this stuff makes me mad.) People wanna look impressive without actually putting in the work to gain real knowledge. They're asking ChatGPT to write viral "expertise" knowledge posts for them, and they're publishing this slop without so much as testing it.

A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you're wondering, this is the helpful error message th...

Discover new features of SSIS in SQL Server 2025 and learn if an upgrade makes sense for your on-premises solutions.