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

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

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

Challenges Enterprises Face When Adopting AI

The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.

15 Characters or Less: The Challenge of SQL Server Listeners Name

15 Characters or Less: The Challenge of SQL Server Listeners Name

There is a hard limit on how long your AlwaysOn listener name can be. That...

Data Masking with Azure Databricks

“Alice: Would you tell me, please, which way I ought to go from here?The Cheshire Cat: That depends a good deal on where you want to get to.”— Lewis...

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

PASS Summit 2024 – A new experience

I attended the PASS Data Community Summit held in Seattle in person this year after a long gap of 4 years and after RedGate software took over running the...

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

Friday Flyway Tips: Chaining Commands for State-based Deployments

One of the cool things I’ve seen with the new Flyway CLI is that I can combine multiple actions together in one call, which can make the process of...