A Broken Copilot Query

I was testing the new SSMS (v22 Preview 3) with Copilot and ran into an interesting issue. This is part of a series of experiments with AI systems. My...

Estimated Rows

We Should Demand Better

Steve talks about the problems with security in vendor software.

DBCC CHECKIDENT

PWDCompare

The Improvement Limit

How much of a difference can you make at a job? Steve has a few thoughts today.

T-SQL Tuesday #191: Invitation–Your Favorite String Parsing

It’s that time of the month, and I’m late. My apologies. I had a mix-up with a host and was on vacation all last week, so no invite. I’m...

Start Fixing Your DB with Better Code

The best way to improve your database performance is with better code. We all know that, but few of us actually end up making those changes.

The Book of Redgate: We Value Teams

This value is something that I still hear today: our best work is done in teams. On the facing page, there is a short description of what this means....

Vector Datatype Dimensions