You paste a slow Redshift query plan into PlanTrace and one of the tuning insights reads "SORTKEY optimization candidate", pointing at an explicit sort step that's adding cost you...
2026-06-15
10 reads
As part of my running the SQL Saturday charitable foundation, I get sponsorship money from vendors. Primarily Microsoft and AMD, but I hope to change that in the future....
2026-06-15
19 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break into data engineering or AI, nothing on your resume carries more weight than a GitHub...
2026-06-29 (first published: 2026-06-12)
379 reads
We work hard at Redgate, though with a good work-life balance. One interesting observation for me (as an American) is how well most of the company in the UK...
2026-06-12
53 reads
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A read-only advisory system does exactly two things: it observes and it recommends. It never acts....
2026-06-11
32 reads
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...
2026-06-24 (first published: 2026-06-11)
346 reads
While wandering around the documentation looking for some Question of the Day topics, I learned something new about the money data type. This post discusses what I learned. Another...
2026-06-10
98 reads
Third part in my Ai series with databases. When building AI solutions within the database realm the first thing that people do is a straightforward concept, connect the LLM...
2026-06-09
167 reads
This month we have a very interesting invitation from Koen Verbeeck. He has hosted once before, and agreed to help me out this month by tackling another topic. We’ve...
2026-06-09
157 reads
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s topic is chosen by myself, and it’s inspired by a blog post of Alexander Arvidsson....
2026-06-19 (first published: 2026-06-08)
438 reads
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item Have you done a Mid...
Comments posted to this topic are about the item From SQL Server On-Premises to...
Comments posted to this topic are about the item Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers