Creating a JSON Document IV

The Vector Data Type

Don't Panic

And bring a towel. If you don't know what I'm talking about, you have homework. You know with that lead in I'm going to talk about AI. Sorry, can't help it. It's on my mind quite a lot. It's in the news, oh, a whole lot. The majority of those stories can be summed up […]

AI Database Central

SQL Server Central is expanding with AI Database Central next week.

Answering Questions On Dropped Columns

Answering a couple of questions from the previous posts about dropping columns.

How to Help Copilot Encourage Good Database Standards

I know a lot of y’all lag behind on upgrading SSMS, but v22.3 just introduced something that you need to be aware of. It’s going to impact any of your users who DO upgrade their SSMS, or who use Github Copilot. There’s something that you can do in order to improve Copilot’s code quality and make it match your preferred coding standards.

Foreign Keys - Foes or Friend?

Learn about how those Foreign Keys can impact your performance.

SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained

Now that SQL Server 2025 has finally been released to the public, I was finally able to test and learn a lot about this command (named CREATE EXTERNAL MODEL), and I want to share my knowledge with you here. If you’re new to the world of AI, don’t worry, we’ll start with the basics and evolve to where this command fits in!

I Just Don’t Understand Why You Don’t Update SSMS.

A long time ago in a galaxy far, far away, SQL Server Management Studio was included as part of the SQL Server installer.

Optimism Without Illusion or Why AI Needs Blunt Technologists

There is a temptation, especially in technology, to mistake momentum for maturity.