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
A lot of you may probably know that I like the GitHub Copilot sidecar chat in SSMS, and that it can really help develop code faster. Even though you have to be aware of how the integration now handles your prompts, it remains a great help to quickly generate code. But did you know that … Continue reading SSMS 22.5 and Copilot: generate code in the query window
Maybe you've read my blog post in the DP-700 certification series about mirroring data. You can find that one here. This blog will be longer and more technical. And involve SQL Server. To make reading a little easier, I've listed the Microsoft Learn pages at the end of this blog post. While writing the DP-700 … Continue reading Mirroring SQL Server 2025 to Microsoft Fabric, a level deeper
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
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
One of the new features in SQL Server 2025 is that you can now use regular expressions directly in your T-SQL queries. Now, regular expressions (or RegEx) have never been a syntax that's easy to read. There are a lot of brackets, dashes and other symbols that make no sense when you first see them. … Continue reading SQL Server 2025: Simplifying Data Checks with RegEx
Reitse's blog 