T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?

Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the invitation post, I intentionally kept the prompt broad because change detection looks different depending on...

Optimizing Redshift Performance by Configuring WLM Queues

Efficient query performance in Amazon Redshift often comes down to how well you manage workload concurrency. Redshift's Workload Management (WLM) queues enable you to control how queries share resources,...

PowerShell Strikes Back: Return of the Loop

Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is paying off. In Week 1, we learned that quotes are not interchangeable. In Week 2,...

Breaking Rules in Rome

Last week I was honored with a trip to Rome for the Redgate President’s Club. I was awarded this, along with our top people in Sales, for the work...

Databases and AI Agents

As part of my wider work exploring Claude Code and AI-assisted database engineering, I have been looking at how AI can support SQL Server operations. A failed job, missed...

Creating a Pulsing Conducting Baton - Part 1

Train Wreck
The last time I watched a high school band nearly fall apart mid-performance was when the relatively new, certainly nervous band director started the piece off much faster...

ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)

If you are considering any of the ISACA AI certs like the Advanced Artificial Intelligence Audit (AAIA) or the newly release Advanced Artificial Intelligence Risk (AAIR), ISACA will be...

A Fabric solution can be very cost effective

Are you currently using Microsoft Fabric or considering migrating to it? If so, there are a couple of options to significantly reduce your monthly running costs. Firstly, there’s the...

Track SQL Server Configuration Changes Using the Error Log

Track SQL Server Configuration Changes Using the Error Log

If you work with SQL Server long enough, you or someone will eventually want to know, “Did...

Data Engineering Books Worth Having on Your Shelf (or your tablet)

Good documentation gets you started. Good books get you deep. After years of working with cloud data platforms, SQL engines, and machine learning pipelines, a handful of titles keep...