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

SWAG Saves the Day

PASS Summit East is in one week. I was on the road last week in the UK and then Houston for the Houston AI-lytics event. I had been a...

The unhealthy obsession with ROLLBACK

So I jumped onto an LLM and asked it to give me some PL/SQL to handle a 3-step series of DML statements and out popped the following code: That...

Upgrading SQL Server Containers on the Laptop

I don’t have SQL Server installed on my laptop. In an effort to keep things clean and smooth in case I need to rebuild things, I’ve gone with containers....

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

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

Unleashing Skills onto my database

You may have already seen that thanks to Kris Rice, we now have a baseline set of Oracle skills available for your favourite AI tools. Check out the skills...

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

Questions and Answers from Running a Local LLM

I had a few random questions from my Running a Local LLM on Your Laptop session at the Houston AI-lytics 2026 event last week, so this post looks at...

Overview of Claude AI Models: Which One to Choose?

For those entering the AI space whether professionally or personally I wanted to give a quick overview on the different models on offer within the Claude family – when...