Changing the PK - I

Does Management Care About the Database?

In the past, Steve hasn't often felt management considered databases to be important, but that is changing.

The Basics of Dynamic Data Masking - Step 1 of the Stairway to Dynamic Data Masking

Learn the basics of how Dynamic Data Masking can be used to obfuscate data in SQL Server 2016+.

Don't (Always) Be a Hero

When we need to be heroes in IT on a regular basis, that's a problem for Steve.

The Temporary Synonym

A New Word: Zielschmerz

zielschmerz – n.  the dread of pursuing a lifelong dream, which requires you to put your true abilities out there to be tested on the open savannah, no longer...

Deleting a Git Branch–#SQLNewBlogger

I had someone ask me recently about deleting branches. While I had known how to delete a local branch, I had to look up how to delete a remote...

Friday Flyway Tips–Seeing Pending Migrations

I find that quite a few people using Flyway will end up with a lot of migration scripts over time. While you can certainly re-baseline and split scripts into...

The EXCEPT Query

When Work Isn't Done

Today Steve looks at the case when one software developer finishes their work, but another doesn't. The challenge of reordering work is something that happens more and more as teams struggle to coordinate their efforts.