You can find the slides and SQL scripts for my session “Spice up your SQL – Intro to window functions” at GitHub.
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 […]
Free Webinar about Columnstore Indexes
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 is required. The webinar is only 30 minutes long and will focus on the basics. In the demo scripts 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 […]