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

Creating an Empty Repo in GitHub–#SQLNewBlogger

I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an...

Restore and Upgrade With NoRecovery

You Always Have a Software Pipeline

If you build software for customers, you have a pipeline. It might not be good, but you have one. Steve recommends you work to make sure this is a repeatable, reliable pipeline.