Detecting Issues

How do you detect issues in your systems? Testing? Monitoring? Steve Jones has a few thoughts that we should find ways to do so before our customers.

RANK() vs DENSE_RANK(): #SQLNewBlogger

I haven’t done one of these in awhile, but I saw an article recently about this and decided to explain it to myself, but in a slightly different way....

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

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