T-SQL Tuesday #173–The AI Job Helper

This month I had a new host, Pinal Dave. I was surprised to see he hadn’t hosted, but I didn’t see him in the list. His invite is interesting,...

Data Search within SQL Server Databases

Search and Export Script for SQL Server Databases

Plainly speaking, this article is about searching for a specific value inside all tables and their columns of a SQL database and...

DevOps Book Recommendations

I’m out today, coaching in Salt Lake City. However, I’ve been thinking about a few books after discussions with various customers and attendees at a few events. I wanted...

Book Review – Deciphering Data Architectures

I recently purchased and read the book Deciphering Data Architectures – Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh by James Serra. James –...

Slides from SQL Saturday SLC 2024 – Zero Downtime

Thanks to everyone that came to my presentation at SQL Saturday SLC 2024. This post has a few links for you: Code and repo: https://github.com/way0utwest/ZeroDowntime Slides: Architecting Zero Downtime.pptx...

Learning SQL Book Review – Best Free Book for Learning SQL for Beginners

Data is everywhere, and if you want to make sense of it, SQL (Structured Query Language) is your secret weapon. Whether it’s managing customer data or analyzing trends, SQL...

Webinar Apr 9: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise

On Tuesday I have a webinar with a Redgate sales engineer: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise. This will cover You can register here. In this...

Azure SQL DB Failover Groups

In today’s fast-paced digital world, keeping your data safe and accessible is more important than ever. That’s where Azure SQL Database steps in, offering a suite of tools to...

SQL Quickstart Guide by Walter Shields – Book Review & Summary

In today’s world, data is everywhere. Companies collect it, governments analyze it, and it influences everything from what products we buy to how we vote. But all that data...

RTO and RPO are myths unless you’ve tested recovery

I’ve watched teams spend a lot of time on backup strategy. They plan out the full, differential, and log backups to ensure they can successfully meet the recovery point...