SQL Performance Explained: Everything developers need to know about database performance by Markus Winand

What relational joins are and why Venn diagrams cannot represent them.

Oracle cut its Always Free ARM limits to 2 OCPU / 12GB, enforced Aug 18, 2026. Resize or consolidate your free instances before they're terminated.

Structured primary keys prevent contradiction and perform better than surrogate keys

The most recent meeting of ISO/IEC JTC1 SC32 WG3 “Database Languages” took place from the 15th to the 19th of June 2026 in Stockholm. “WG3”, as we call it, works on standardizing the database language...

Structured primary keys prevent contradiction and perform better than surrogate keys

.KEYVALUE() JSON/Path: Transform Object Attributes into Array Elements

ORDER BY Evolution

Litigation, neglect killed dBase. The dBase newsgroup servers went off-line since November 2025. Court-smart dBase vendors and AI accelerated the fall.

Do identical OVER clauses always produce identical row orders?

The strange edge case that triggered our assertions

We benchmark the performance of AI SQL models against a human baseline to help you choose the best model for your needs.

Just 5 questions to see how much you know about SQL performance. Never make these mistakes again.

A Guide to comparing Claude Code Compiler with GCC

C-style comments work in SQL, with nesting

Protection against infinite loops for WITH RECURSIVE.

The FILTER clause extends aggregate functions (SUM, AVG, COUNT, etc.) with an additional WHERE clause. Databases not supporting FILTER can use CASE within the aggregate function instead.

SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.