Markus Winand erklärt auf modern-sql.com praxisnahes und standardkonformes SQL, inklusive fortgeschrittener Konzepte wie CTEs, Zeilengeneratoren und Performance-Optimierung über verschiedene Datenbanksysteme hinweg.
5 articles from this blog
Explains how different database systems rewrite date/time range queries to enable efficient index usage for functions like EXTRACT(YEAR FROM ...).
Explains the index INCLUDE clause in SQL databases, covering its purpose, how it works with B-tree indexes, and when to use it for performance.
Announcement of the Spanish translation of 'SQL Performance Explained' with updates for latest database releases and a refreshed SQL indexing quiz.
Summary of major database trends in Fall 2017, including SQL's resurgence, cloud pricing wars, IBM's renaming controversy, and new releases.
Spring 2017 database news: SQL:2016 standard, cloud pricing wars, ACIDRain security study, and DB-Engines rankings.
