Wait, what? Resiliency? Against what? Well. The cloud sounds like an amazing, magical place without limits. The truth is, it isn't. Maybe you've seen the funny T-shirts with the text "the cloud is just someone else's computer". And that's true. Instead of building and maintaining your own data centre, you're hiring a global corporation to … Continue reading Azure: Check your data platforms resiliency
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
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 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 is going to be a short blog post, as it serves to highlight a new setting found in SSMS 21.4.12. Tell me more! Well, if you go to the Tools menu in SSMS and click on Options, you will see, unsurprisingly, the options. Locate your Copilot option and click on the Azure OpenAI settings. … Continue reading How to set the Copilot default execution mode in SSMS 21
If you come from an SQL Server background, mirroring will be familiar to you. It may be good or bad, but hopefully not at a nightmare level. Whatever your association with database mirroring, it is also available within Microsoft Fabric. What is mirroring If you're not coming from a SQL Server background, or any data … Continue reading DP-700 training: Implement mirroring
Today, May 19th, 2025, is the keynote day of Microsoft Build, where Microsoft announces its big new tech innovations. You won't be surprised; there's a lot of Copilot in the announcements. You can't get around it if you have any toolset in the cloud; there will be AI waiting for you to help you. Bad … Continue reading Is Microsoft SSMS Copilot the Future of Database Management?
April 12th marked the first edition of Seaql Saturday in the Netherlands, the inaugural event situated in the southern part of the country. The event focused on SQL Server only; as advertised, it was a Fabric-free event. This blog post will discuss my experiences and why you should attend the next edition. Before the event … Continue reading Speaking experiences at Seaql Saturday
