SQL Prompt Quick Access to Helper Code

We’ve been doing some events as part of the Redgate Roadshow, and at one of the events, we had a customer ask about something that we demo’d. This post...

The Year in Travel

Here’s my year, which is pre-populated with a couple more trips coming up in November. Those should be all, as I’ve declined to go back to the UK in...

TRUNCATE an FK

Practicing (Annoying) Better Security

Steve has had to change his security, which is good, but annoying.

The Basic Symmetric Key

Rollback or Not?

The Code Review Checklist

Code reviews are a part of many software development processes, but not used that often with database work. Today Steve has a few thoughts and asks if you have any formal code review process.

More SQL Server GDRs

A number of patches for SQL Server were released this week.

SQL Saturday Boston 2023 Slide Decks

Thanks to everyone who came to my sessions at SQL Saturday Boston 2023. I’ve added the decks to the schedule, so you can click my session and will see...

A New Word: Harmonoia

harmonoia – n. an itchy sense of dread when life feels just a hint too peaceful – when everyone seems to get along suspiciously well, with an eerie stillness...