←
Markus Winand6,625 posts
Markus Winand avatar

Markus Winand

@MarkusWinand

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

◷ Joined August 2010▧ 296 Photos and videos
Markus Winand avatar
Markus Winand@MarkusWinand·18 Jan 2021

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.

Markus Winand avatar
Markus Winand@MarkusWinand·Nov 12

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!

Markus Winand avatar
Markus Winand@MarkusWinand·Oct 8

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.

Markus Winand avatar
Markus Winand@MarkusWinand·Oct 1

€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 ;)

Markus Winand avatar
⟳ Markus Winand retweeted
Markus Winand@MarkusWinand·Jun 1

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.

Post attachment