SQL Server Error 9002 – Full Transaction Log

A full transaction log can occur for a number of reasons. Typically it is due to the log not being truncated with regular transaction log backups, or something else...

Using Flyway Prepare for State-Based Deployments

One of the neat enhancements made to Flyway was the addition of state-based workflows and tooling. A lot of people have loved SQL Compare or SQL Source Control for...

SQL Saturday Oregon & SW Washington 2024

Wow I am so late in posting these notes! But this conference was amazing, so figured still good to post my notes from the incredible sessions I attended! Hope...

T-SQL Tuesday #182: Personal Integrity

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from the first non-founder to host a party, Rob Farley. I reached out to Rob and...

Grinding Away: Mary Spender

A few years ago I stumbled on this video and loved it. That led me to Mary’s page and this cover of John Mayer’s Stop This Train: Since then...

How I Migrated to Azure PostgreSQL Flex from Single Server

I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also using the Azure migration tool. I had to ultimately do a combo of those because...

How to clear the SSMS cache?

How to clear the SSMS cache?

If you are reading this, it's probably because you too have this rare need to clear the SSMS cache for...

How to Learn SQL Without Quitting Your Day Job

Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest in flip-flops. But guess what? You absolutely can become an SQL whiz without sacrificing your...

A New Word: Querinous

querinous – adj. longing for a sense of certainty in a relationship; wishing there were some way to know ahead of time whether this is the person you’re going...

BK’s Bookshelf: Never Split the Difference

I picked up Never Split the Difference: Negotiating As If Your Life Depended On It by Chris Voss, a former FBI negotiator. Given what I do, I realized that...