In a previous blog, I wrote about processing XML and that it's actually JSON after the first pass. So far, so good. But then I found out that not all data was returned. That's weird because it's really there. So, what's happening here? Follow me, and let's find out! The previous blog had this JSON … Continue reading Microsoft Realtime Intelligence: the array that wasn’t
Let's be honest, you thought of doing this yourself. Connecting two tools that seem to serve very different purposes. But, as I had a day to fool around, I thought to myself, let's see if I can make this work. In the previous blog post on MCP Local, I described how to run your MCP … Continue reading SQL MCP: Local to Fabric Lakehouse
I got a new laptop this week, and one of my default steps is installing SQL Server. This has always gone without issue until yesterday. I ran into an error message when my Bing skills (for some reason, my company defaults to Bing instead of Google) failed me. The error message When I started installing … Continue reading SQL Server 2025 and disk sector size
In the previous blog posts, I've written about installing MCP and how it works, followed by how to use it with an Azure SQL Database through an Azure Container Instance and Microsoft Foundry. But, you can also use your favourite local database (SQL Server ;)) and Visual Studio Code. The reason Visual Studio Code is … Continue reading SQL and MCP, the local edition
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
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
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
We're almost used to SQL Server Management Studio (SSMS) 21, and now 22 is already in preview. So, let's see where it's available for download, install it and see what's different. Download and release notes. The most important part, of course, is the download of the binaries. Click here for the download. Click here for … Continue reading SSMS 22 preview 1 first impressions
Reitse's blog 