Adding a FK in a CREATE TABLE

Be Valuable, Not Critical

One piece of advice for engineers is to be valuable, but not critical. It's a mistake Steve made early in his career, but he hopes you can do better.

Creating a SQL Clone Image from a SQL Clone Database

A customer asked if a new image could be created from a database that was itself a SQL Clone. It can, and I’ll show that in this post. This...

Suppressing the FOMO

I saw a post recently on Twitter/X/whatever we call it. It was for a DevOps in a Day from Redgate taking place in Jacksonville. I’ve been a part of...

Extracting JSON

The Justification Database

Having a good process for managing security is important, but how many of us enforce that?

T-SQL Tuesday #167 – Encryption and Data Protection

I missed September since I was gone half the month in Europe and busy with a roadshow. And, I missed October, since I was busy this month and lost...

Bad Culture Bad Security

Another company has hard-coded credentials, which Steve feels are a sign of bad culture.

The Column Synonym

A New Word: Gobo

gobo – n.  the delerium of having spent all day in an aesthetic frame of mind, taking photos across the city, getting lost in an art museum – which...