Advice I Like: Celebrate Success

“On the way to a grand goal, celebrate the smallest victories as if each one were the final goal. That way, no matter where it ends, you are victorious.”...

How to Find Expensive Queries in Amazon Redshift

Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying the most expensive queries is crucial to optimize resource usage and improve overall system efficiency.

Step-by-Step...

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

SSMS Evaluation – future ready

In previous posts, we looked at the SQL Server engine. for us DBAs, the SSMS plays an important role for handling/Managing SQL Server. we have been using these tools...

Programmatically Retrieving MLV Lineage and Refresh Times

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion architecture declaratively, but once you have a pipeline of MLVs in production, you need visibility...

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

If you’ve been here before, you know this blog is usually about SQL Server, PowerShell, and the day-to-day work of being a DBA. Execution plans, availability groups, dbatools scripts...

T-SQL Tuesday #198–Change Detection

This month we have a new host, Meagan Longoria, who graciously agreed to help me this month. I’ve known Meagan for a number of years and she’s been a...

Designing a Storage Load Test for SQL Server

I’ve been doing storage load tests for SQL Server for a long time, both as a consultant and now in my work at Everpure, and I see the same...

Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database

Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding which queries consume the most DTU (Database Transaction Unit) helps prioritize tuning efforts and improve...

Redgate and Rome

I’m at the UK Redgate office today, meeting with senior leaders in all areas of the business. I was honored to be awarded a spot in our President’s Club....