Journal

The journal

Experiments at the intersection of AI and marketing. Frameworks that compounded, and teardowns of things that spectacularly didn't.

How to Replace Part of a String in SQL

Use the REPLACE function to swap part of a string in one record or thousands — with practical examples.

CAST() is the ANSI way. Here's how to convert text columns to numbers — with the classic gotchas.

ROUND() takes the number and the decimals you want. Simple, but easy to compound errors if you round too early.

DATEADD() shifts dates fast — perfect for renewals, cohort windows and birthdays.