Finding Bad Queries

Recognizing queries that might perform poorly is a skill that will help you, and your AI assistant, produce better code in production.

The Service Name

A New Word: Mauerbauertraurigkeit

mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company you generally enjoy, like a poker player who keeps folding a promising hand in order...

Advice I Like: Responsibility

“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not your responsibility.” – from Excellent Advice for Living I’ve worked with a lot of people...

BIT_COUNT() IV

Fixing P1 Queries

Steve asks if we should focus on the slowest queries or tackle other issues in our systems. Or if we should even have to make these decisions.

Adding an HTTP MCP Server to VSCode

I wrote earlier this week about the SQL MCP Server using the Data API Builder. In that post I showed how to query the MCP server from VSCode, but...

AI Experiments: Claude Solved a DAB Issue

I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some sort of agent. I’m doing the same, but in this case, I had it tackle...

Building Your Own Software

AI helps with building software, but it doesn't do all the work.

Symmetric Key Encryption