I’m the founder and CTO of VividCortex, author of several books, and creator of various open-source software. I write about topics such as technology, entrepreneurship, and fitness.

How to group data in SQL with a catch-all bucket

How to simulate the GROUP_CONCAT function

Singular vs. plural table names

Tips and tricks for bitwise arithmetic

How to simulate the SQL ROW_NUMBER function

Less is More

The difference between subqueries and derived tables in SQL

How to write INSERT IF NOT EXISTS queries in standard SQL

How to write a SQL exclusion join

How to write a UNION in SQL without using UNION

Interactive directory merging

Mutex tables in SQL

How to write subqueries without using subqueries in SQL

About Me

Essential Books

Regex Toolkit