A New Word: on tenderhooks

on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which makes you feel that much more rooted to the world, even if the roots belong...

Having a Little Fun at SQL Server Central

Steve reminisces on some of the fun times he's had at SQL Server Central.

Setting FK Constraints in Data Modeler

One of the things a customer asked recently about Redgate Data Modeler was how to set a FK constraint between two tables. The tool seemed to make it easy,...

String Similarity I

Creating JSON III

Identity Columns Can’t Be Updated: #SQLNewBlogger

I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error...

Testing is Becoming More Important

Testing is going to be even more important in the age of AI.

Can You Let Go of Determinism

As Steve uses AI more, it seems determinism isn't something you get out of many LLMs.

Lots of FKs

Rolling Back a Broken Release

We had an interesting discussion about deployments in databases and how you go forward or back from the point when you discover a problem. You can watch the episode...