Master SQL Subqueries with This Free Course

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World Exercises for All Levels. It covers subqueries – a must-have tool for any SQL pro....

Removing the REST Endpoint in the Data API Builder

The more I work with the Data API Builder (DAB), the more I lean towards GraphQL instead of REST. Rest isn’t bad, but it’s tough. This is part of...

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