KDA: Echoes of Deception - Case 5

A deleted podcast episode, 17 million archive log entries, and KQL's time series analysis to find the backup that was never supposed to survive.

The Joyful Craftsmen and the Revolt BI join forces

The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates one of the most significant independent groups in the field of data analytics, business intelligence...

Want to look at cloud reporting but not sure what the costs will be?

Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but you have no idea what it would actually cost? ?? That’s the scariest thing, and...

Creating a SQL Stored Procedure to Load a SCD2

This is a blog that I am writing for future me and hopefully it’ll help a few of you save some time too! It’s not often that I get...

My Toolbox - AI

I trusted AI to redesign this entire blog. The layout, the CSS, the deployment pipeline, the shortcodes. I use it to build home automation, organize my notes, fix my...

Prime Day Recommendations

It’s Prime Day. A few of my recommendations, since I want to do some shopping myself (yes, these are commissioned referrals). These are things I’ve ordered and used this...

How AgentDBA Diagnoses SQL Server Issues Fast

Not every production incident is a database in RECOVERY_PENDING or a corrupted event (like the other post). Sometimes the server is just a mess. Jobs failing. Error log full...

AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared

Both SQL Server and PostgreSQL are moving fast into AI territory — and if you manage either (or both), you've probably wondered how they compare when it comes to...

Monday Monitor Tips: AI Alert Analysis

We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check out this new feature we’ve added for alerts. This is a great addition to help...

SQL Server instance metadata inventory with PowerShell and SMO

SQL Server instance metadata inventory with PowerShell and SMO

The purpose of this article is to introduce a PowerShell script that I wrote and published on...