You can find the slides and SQL scripts for my session “Spice up your SQL – Intro to window functions” at GitHub.
Tag: syndicated
DataSaturday Rheinland – Slides
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 🙂
T-SQL Tuesday #199: Roundup
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 cloud computing. What would you need to do? How do you plan for this? What are the […]
T-SQL Tuesday #199: Back to the on-prem
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 would do if we need to move our data platforms back to on-prem, after a good decade of cloud […]
T-SQL Tuesday #199 Invitation: Back to on-prem?
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 write about it on the second Tuesday of the month (9th of June), and the host posts a recap with links […]
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
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 publish GraphQLApi ‘my_graphql’: Operation failed. Error Code: DatasourceInvalidStoredProcedure. Error Message: Only those stored procedures whose metadata for the first result set […]
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my DataGrillen session Building the €100 data warehouse with the Azure Data Platform to Github. If you have questions, post a comment or send me a message on LinkedIn and I’ll try to help you out. edit: in my €100 session I […]
Fabric Mirroring doesn’t start copying Rows
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 and this principal has the proper permissions on the source database. Configuring the replication was without issues, and the […]
Webinar Series – SQL Server Indexing
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 related database engines). The target audience are people new to SQL Server or new to the concepts of indexing. So […]
ADF Pipeline Debugging Fails with BadRequest – The Sequel
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 that you get: In that blog post, the issue was that there were some lingering user properties that were configured incorrectly and […]