Using CAT for Testing of Data Agents

In last months one of the scenarios where you can use AI has been to build an agent which would answer your questions by looking into your data. It...

Claude Code Helps Analyze Test Data Manager Log Files

I had a customer ask about analyzing their Test Data Manager (TDM) usage to determine how many people were protecting data in dev databases and how often. TDM creates...

Are you getting value from your reporting?

Do you spend so long manipulating your data into something vaguely useful that you don’t have the time to focus on analysing the what the data is telling you?...

PowerPoint to HTML with Claude AI

I had an idea for an animated view of a sales tool, and started to build this in PowerPoint. I decided to switch to Claude and ended up with...

The Book of Redgate: SQL Server Central

It was neat to stumble on this in the book, a piece by me, just a few years after Redgate acquired SQL Server Central. I’ll let the words speak...

Git forked

Forgive me for the title. Mentally I’m 12. When I started my current day job, I certainly didn’t expect to write this many blog posts about Git. I don’t...

Claude AI Convinced Me Not to Build an iPad App

I coach volleyball and I do a lot of stat stuff on paper. I decided recently to see if I could find a way to more easily automate things....

Fabric Cost Analysis (FCA)

Monitoring costs in Microsoft Fabric can be trickier than it first appears. You might assume it’s just a flat fee per capacity (easy, right?), but real-world usage tends to...

Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes

Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes

After tempdb, msdb is often the most abused system database, growing unchecked until it tanks...

Setting FK Constraints in Data Modeler

One of the things a customer asked recently about Redgate Data Modeler was how to set a FK constraint between two tables. The tool seemed to make it easy,...