A sequential scan is not always a problem — PostgreSQL’s planner often chooses one correctly for small tables or queries…
Browsing: SQL
Two years ago, two things happened within a few days of each other. I retired from 3Cloud going on full…
Redgate is a for-profit company. We look to make money by building and selling tools that help you. If we…
It was a Sunday evening. Around 8:15 PM. The kind of evening where the whole house smells of cardamom and…
What problem is Fabric Ontology trying to solve?For years, most data conversations have started with tables. We ask where the…
Recently I ran across some code that used a lot of QUOTENAME() calls. A colleague was having some trouble with…
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the invitation post, I intentionally kept the…
Last week I was honored with a trip to Rome for the Redgate President’s Club. I was awarded this, along…
As part of my wider work exploring Claude Code and AI-assisted database engineering, I have been looking at how AI…
Train WreckThe last time I watched a high school band nearly fall apart mid-performance was when the relatively new, certainly…