The Book of Redgate: Don’t be an a**hole

This was one of the original values: The facing page has this text: No matter how smart you are, or how good you are at narrowly defined tasks, there...

The Challenge of Implicit Transactions: #SQLNewBlogger

I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting. Another...

The Journey to PostgreSQL (or anything)

Learning is fundamental in technology. Steve has a few thoughts on adopting a new technology at work.

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...