
Teaching is about making students reach the same level of understanding as the teacher—but with less mental effort. This allows students to put their mental efforts into growing beyond their teachers.

SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of use-the-index-luke.com and modern-sql.com.

Teaching is about making students reach the same level of understanding as the teacher—but with less mental effort. This allows students to put their mental efforts into growing beyond their teachers.

Let's face it: XPath 2.0+ has the cutest comment syntax... /html/body (: this is a comment :) /h1 The world needs more smiles! Also: Nesting allowed!

rewritey.com/ "Rewrite multi-join SQL into faster plans. Analyze query shape and workload overlap to find reusable intermediates." Maybe worth a try if you have aggregating queries with many joins.

€10 for a frontier AI subscription are gone in one workday €10 for my book SQL Performance Explained has a lasting impact on you* sql-performance-explained.co… Learning timeless fundamentals always has a lasting effect * you also need to read it, which takes about 1 day ;)

There's much more to defining primary keys than using surrogate id columns @MarkusWinand introduces Structured Primary Keys These are based on foreign keys plus the columns needed for uniqueness Using these can give performance & functional benefits modern-sql.com/blog/2026-06/…

New post: Structured Primary Keys For consistency and performance. modern-sql.com/blog/2026-06/…

The SQL/JSON Path item-method .keyvalue() has an interesting history in the Oracle Database. modern-sql.com/caniuse/keyva… In 23.26.2 it works, but not in ?( filter ) context.

MariaDB 12.3.2 was released last week. It's the first "stable" version of the long-term supported (LTS = 3 years) 12.3 branch. An SQL dialect enhancement is the IS JSON predicate. Also: a bug I reported is fixed (MDEV-38835). All charts on modern-sql.com are updated.

ORDER BY Has Come a Long Way modern-sql.com/blog/2026-05/… The ORDER BY clause is one of the best-known SQL clauses. Yet there are a number of common misunderstandings that are worth clearing up. The article walks you through the evolution of the ORDER BY clause in the SQL standard.

Should these functions return the same value? SELECT ROW_NUMBER() OVER (ORDER BY x), ROW_NUMBER() OVER (ORDER BY x) FROM ... What about when many rows have the same value for X? According to the #SQL standard: yes @MarkusWinand investigates modern-sql.com/blog/2026-03/…

Other profiles mastodon.social/@MarkusWinan… bsky.app/profile/winand.at at.linkedin.com/in/markuswin…

Order-equivalent OVER clauses modern-sql.com/blog/2026-03/… About an important but rarely appreciated aspect when using multiple OVER clauses in a single query.

SQL Comments, Please! modern-sql.com/caniuse/comme… Standard SQL offers two flairs of comments: one starts by two dashes (--) and goes to the end of the line. The other starts with slash-asterisk (/*) and ends with asterisk-slash (*/). #SQL #DuckDB #PostgreSQL #MSSQL

Infinite Recursion Guards modern-sql.com/caniuse/with_… With recursive is the only SQL construct that is not guaranteed to terminate, eventually. As the DBMS is typically a very crucial system, infinite loops must be prevented at all times. See how various SQL systems help you.

I’m a simple man. While Oracle people are ecstatic about ASSERTION in the just released version 23.26.1 of the Oracle Database, I’m happy to see something as simple as FILTER :) 🧵
The just released version 23.26.1 of the Oracle DB supports the FILTER clause. modern-sql.com/feature/filte…

Oh, BTW, I’m also ecstatic about ASSERTION, but I’ll need some time to cover it on modern-sql.com.