Changing the Cardinality of a FK in Redgate Data Modeler

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

Future-Proofing: How to Stay Ahead in FinOps

Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly last year’s “perfectly optimised” setup isn’t so perfect anymore. Over time, I’ve realised that FinOps...

Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes

When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned and unplanned failovers. The easy case is a planned failover, where you deliberately move the...

OpenClaw- Agentic Engineering

This week has training on AI – Cyber security experts – Omar Santos and Aamir Lakhani- with great knowledge . during the session learned about OpenClaw and more. I...

Reading SQL Server File Headers with DBCC FILEHEADER

I’ve been doing a deep dive into SQL Server on-disk structures lately, and one of my favorite rabbit holes is revisiting Paul Randal’s series on file header pages. If...

Did You Really Name That Default?

Ten years (and a couple jobs) ago, I wrote about naming default constraints to avoid having SQL Server name them for you. I closed with the following statement:

SQL Server...

Fabric Mirroring doesn’t start copying Rows

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I’ve managed to run into, twice. I’ve set up mirroring by...

The Intersection Between DevOps and FinOps

DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster, deploy faster. But while we accelerate delivery, why not shorten the expense lifecycle as well?...

T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP

Thanks to everyone who joined the blog party this month. I noticed three themes in the responses. Every response had one or more of these themes woven into their...

Visualising Vectors in High Dimensional Space

Following on from my previous post on building The Burrito Bot, I want to delve into visualisation of vector embeddings that were generated from the restaurant data pulled from...