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

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

Going to Cloud? Look at the Shared Responsibility Model

The bottom line here is this: the idea that a CSP takes care of everything for you is a fallacy that really needs to die. Thompson, Graham. All-in-One CCSK...

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

Flying Halfway Around the World to Australia

I leave tonight for Australia. I was in London 3 days ago, so this will complete my halfway around the world trip when I time travel tomorrow and skip...

The Basics of TRY CATCH Blocks–#SQLNewBlogger

I was working with a customer and discussing how to do error handling. This is a short post that looks at how you can start adding TRY.. CATCH blocks...

A New Word: Apolytus

apolytus– n. the moment you realize you are changing as a person, finally outgrowing your old problems like a reptile shedding its skin, already able to twist back around...

Book Review: 100 SQL Server Mistakes

I was approached by Manning Publications and asked to review 100 SQL Server Mistakes and How to Avoid Them. They gave me a free copy of the book (and...

First Time Speaking with a Mask at an Event

Over the past couple of months, I have started losing my ability to talk without a mask. One of the effects of a disease, ALS, is that I am...

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