This month, Koen Verbeeck invites the blogging community to write about their thoughts on returning to on-premises. What could be struggles, things we have to re-learn, etcetera. When I read the invite, it immediately sparked inspiration, because there are increasing rumours around cloud exits. People musing about 'what if'. Some clients reference these questions, but … Continue reading T-SQL Tuesday #199: Back to on-prem?
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
Let me start this blog post by asking you a question. Q. When was the last time you looked at your redundancy? Yes, this is a very vague question because there's a lot of interpretation you can put into it. Even though it's very valid to think about your personal redundancy (who can fill in … Continue reading Remember your Redundancy
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
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
Now that's a title! Especially for a very cool new feature: Copilot embedded in SSMS. I've blogged about Copilot for SQL before, but this really is the next step! I'm very excited about this new feature, and I tried to install it on my machine. Because Microsoft can share all the steps they think you … Continue reading Setting Up Copilot in SSMS 21: A Step-by-Step Guide
Reitse's blog 