In today's cloud era, Azure SQL is usually first with new functionality, while on-premises SQL Server follows. One of the new things is the JSON data type and accompanying JSON index. Because I had to learn how JSON works in SQL Server for my DP-800 exam, I decided to see how the JSON index works … Continue reading SQL Server 2025: Testing the JSON Index
First up, congrats to Adam Machanic and Steve Jones on reaching 200 episodes of T-SQL Tuesday; you can be proud of yourselves! I've always loved the variety of topics, the different views of the bloggers, and the learning that can be gained from all the posts. I've even had the honour of hosting. Anyway, Brent … Continue reading T-SQL Tuesday 200: When I Look at a Query …
Earlier this year, Microsoft released a new certification that combines AI and SQL Server knowledge: the DP-800: Developing AI-Enabled Database Solutions. As I still deeply care about SQL Server and am convinced it has a very central place in any data architecture (cloud or on-premises), this one sparked a lot of interest. Today, I took … Continue reading DP-800 Exam Experiences
When you start using SSMS with GitHub Copilot, there is no default set of instructions in place. The agent will just sort of do what it thinks is best. But you can make sure the agent has more knowledge of your local environment (yes, it can be a cloud database as well), how it should … Continue reading SSMS 22.6: Custom Copilot instructions
The DP-800 training is new and was released to GA a few weeks ago. It now sits in the same family as DP-600 (Data Analytics using Microsoft Fabric), 700 (Data Engineering using Microsoft Fabric) and 750 (Data Engineering using Databricks). The full name of this training is "Develop AI-Enabled Database Solutions". This one sparked my … Continue reading DP-800: First Microsoft Learn experiences
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
I've been working for quite some time on a fun solution in Fabric Realtime Intelligence. We're processing XML files into a structured table. As you're probably aware, XML has its own... well, let's be nice and call them challenges. One thing I ran into was that an element contained several other elements. Usually, you'll see … Continue reading Microsoft Fabric Realtime Intelligence: Processing XML, or are you?
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
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
Reitse's blog 