In part one, I covered the basics of your Data API Builder setup. Now, it's time to get into the real stuff :). For the demo, I'm using the Stack Overflow 2013 database on an Azure SQL General Purpose Serverless 8-core database. It's not a very large dataset (making it less expensive to host on … Continue reading SQL and MCP, Azure SQL Edition
This three-part series of blog posts will take you along my first experiments, trials and errors using the MCP Service for SQL. This first blog will focus on the technology behind it; part 2 will focus on Azure SQL options; and the last part will dig a bit deeper into running this on your local … Continue reading SQL, Azure SQL and MCP, the Introduction
This blog can also be known as 'The Sequel', not to be confused with SQL, even though Fabric SQL will be mentioned in this blog. Anyway, I digress and don't call me Shirley. For those of you who have been following this blog for a long time, you may have read the posts on Fabric … Continue reading Loadtesting Microsoft Fabric, part II
Every now and then, I have the pleasure of presenting at a new event. This time, it was at the Data Community Day Austria, held at the Jufa hotel in Vienna. Before getting into the details, at the time of writing, I'm not fully OK. It's not a full burnout, but dangerously close. I wrote … Continue reading Speaking experiences at Data Community Day Austria
"tap tap tap". Your attention please, we're going to orchestrate our ETL/ELT process! Yes, it's time to unleash your inner Herbert von Karajan and make sure your BI orchestra performs at its best. Why? Well, unless you enjoy waking up every night to start your Extract-Transform-Load (ETL) process and manually running each process to do … Continue reading DP-700 training: Orchestration
I'm guessing you've seen posts, blogs and social media activity in the last year on both Fabric SQL databases and rumours around SQL Server 2025. Today, Microsoft announced that both of these are Generally Available (GA). This means it's now fully supported by Microsoft. You can read all about this, and more, in the Ignite … Continue reading Ignite announced SQL Server 2025 and Fabric SQL GA
Today was a very interesting day at a customer's site, where I had some trouble determining why the OneLake security wasn't functioning as I expected. Spoiler alert: a part was me, and a part had to do with setting up my testing account. Setup The reason I got myself into this little pickle was quite … Continue reading Microsoft Fabric Lakehouse OneLake security, some experiences
A few minutes ago, I came across a post on LinkedIn by Erin Stellato, highlighting the post from Makena Barickman on the release of SSMS 22, preview 3. If you've been following my blogs, you've read that I'm a keen follower of the latest editions of SSMS, especially now that Copilot is integrated. From very … Continue reading Exploring SSMS 22 Preview 3: New GitHub Copilot Features
Some of you might recognise database projects from either Synapse Analytics or SQL Server. Yay for the latter ;). A long story, very short, database projects are a way to develop and deploy your databases using a CI/CD (Continuous Integration/Continuous Development) approach. For each database, the code you've written is saved in a specific project … Continue reading DP-700 training: implement database projects
Last week, I had the pleasure of attending the Microsoft Fabric Community Conference (FabCon) in Vienna. Four days of learning, networking, meeting new people, speaking, announcements, Power Hour, volunteering and charity. I'll cover all these aspects in this post. The updates part won't cover all of them, as there are many. I'll pick my favourites … Continue reading Microsoft Fabric Community Conference: announcements and experiences
Reitse's blog 