Markus Winand

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

Categories
N/A
Content Types
N/A
More Information
Location|Languages
Publications

Published Content

51
Upcoming Training: SQL Performance Kick-Start and modern SQL
use-the-index-luke.comArticle
Upcoming Training: SQL Performance Kick-Start and modern SQL
July, 31 2018
Big News In Databases: SQL Still on The Rise, Cloud First, Fsyncgate and a Giant Leap for SQL
winand.atArticle
Big News In Databases: SQL Still on The Rise, Cloud First, Fsyncgate and a Giant Leap for SQL
July, 4 2018
PostgreSQL Standard SQL Gap Analysis
modern-sql.comArticle
PostgreSQL Standard SQL Gap Analysis
June, 5 2018
One Giant Leap For SQL: MySQL 8.0 Released
modern-sql.comArticle
One Giant Leap For SQL: MySQL 8.0 Released
April, 25 2018
SQL Pivot in all databases: MySQL, MariaDB, SQLite, PostgreSQL, Oracle, …
modern-sql.comArticle
SQL Pivot in all databases: MySQL, MariaDB, SQLite, PostgreSQL, Oracle, …
February, 5 2018
Standard SQL Features Where PostgreSQL Beats its Competitors
modern-sql.comArticle
Standard SQL Features Where PostgreSQL Beats its Competitors
February, 5 2018
Standard SQL features where PostgreSQL beats its competitors
slideshare.netArticle
Standard SQL features where PostgreSQL beats its competitors
February, 3 2018
Modern SQL: Three-Valued Logic (3VL) — Purpose, Benefits and Special Cases
modern-sql.comArticle
Modern SQL: Three-Valued Logic (3VL) — Purpose, Benefits and Special Cases
December, 14 2017
Modern SQL: IS DISTINCT FROM — A comparison operator that treats two NULL values as the same
modern-sql.comArticle
Modern SQL: IS DISTINCT FROM — A comparison operator that treats two NULL values as the same
December, 6 2017
Modern SQL: NULL — purpose, comparisons, NULL in expressions, mapping to/from NULL
modern-sql.comArticle
Modern SQL: NULL — purpose, comparisons, NULL in expressions, mapping to/from NULL
November, 28 2017
3-Minute Test: What do you know about SQL performance?
use-the-index-luke.comArticle
3-Minute Test: What do you know about SQL performance?
November, 13 2017
Spanish Translation and Other News
use-the-index-luke.comArticle
Spanish Translation and Other News
November, 13 2017
Big News In Databases: Cloud Wars, IBM’s Renaming Insanity, Three Major Releases
use-the-index-luke.comArticle
Big News In Databases: Cloud Wars, IBM’s Renaming Insanity, Three Major Releases
November, 6 2017
Modern SQL: EXTRACT components from a date or time in MySQL, Oracle, PostgreSQL, etc.
modern-sql.comArticle
Modern SQL: EXTRACT components from a date or time in MySQL, Oracle, PostgreSQL, etc.
September, 19 2017
Literate SQL using the WITH clause
modern-sql.comArticle
Literate SQL using the WITH clause
June, 28 2017
What's New in SQL:2016
modern-sql.comArticle
What's New in SQL:2016
June, 15 2017
Big News In Databases: new SQL standard, cloud wars, ACIDRain (Spring 2017)
use-the-index-luke.comArticle
Big News In Databases: new SQL standard, cloud wars, ACIDRain (Spring 2017)
May, 11 2017
Myth: Select * is bad
use-the-index-luke.comArticle
Myth: Select * is bad
April, 13 2017
SQL LISTAGG concatenates values of multiple rows into an delimited string such CSV.
modern-sql.comArticle
SQL LISTAGG concatenates values of multiple rows into an delimited string such CSV.
April, 5 2017
SQL WITH: Performance Impacts
modern-sql.comArticle
SQL WITH: Performance Impacts
February, 2 2017
Results of the SQL Performance Quiz
Use-The-Index-Luke.comArticle
Results of the SQL Performance Quiz
January, 21 2017
Big News In Databases: Fall 2016
use-the-index-luke.comArticle
Big News In Databases: Fall 2016
November, 28 2016
On Uber's Choice of Databases
use-the-index-luke.comArticle
On Uber's Choice of Databases
July, 28 2016
filter — Selective Aggregates
modern-sql.comArticle
filter — Selective Aggregates
May, 30 2016
with — Organize Complex Queries
modern-sql.comArticle
with — Organize Complex Queries
November, 27 2015
Inaugural Post
Use-The-Index-Luke.comArticle
Inaugural Post
September, 25 2015
Modern SQL in PostgreSQL [and other databases]
Use-The-Index-Luke.comArticle
Modern SQL in PostgreSQL [and other databases]
February, 2 2015
Seven Surprising Findings About DB2
Use-The-Index-Luke.comArticle
Seven Surprising Findings About DB2
November, 3 2014
Meta-Post: New Mascot, New Language, New Database
Use-The-Index-Luke.comArticle
Meta-Post: New Mascot, New Language, New Database
October, 15 2014
We need tool support for keyset pagination — No Offset
Use-The-Index-Luke.comArticle
We need tool support for keyset pagination — No Offset
September, 24 2014
A Story of Indexes and Full‑Table Scans
Use-The-Index-Luke.comArticle
A Story of Indexes and Full‑Table Scans
July, 16 2014
What I learned about SQLite…at a PostgreSQL conference
Use-The-Index-Luke.comArticle
What I learned about SQLite…at a PostgreSQL conference
May, 27 2014
What's left of NoSQL?
Use-The-Index-Luke.comArticle
What's left of NoSQL?
April, 25 2014
Thank You MySQL, We'll Miss You!
Use-The-Index-Luke.comArticle
Thank You MySQL, We'll Miss You!
April, 1 2014
Primary Key as Clustering Key
Use-The-Index-Luke.comArticle
Primary Key as Clustering Key
January, 16 2014
MySQL is to SQL like ??? to NoSQL — MongoDB?
use-the-index-luke.comArticle
MySQL is to SQL like ??? to NoSQL — MongoDB?
November, 12 2013
Try it online! — Working Examples at SQL Fiddle
Use-The-Index-Luke.comArticle
Try it online! — Working Examples at SQL Fiddle
August, 12 2013
About Optimizer Hints
Use-The-Index-Luke.comArticle
About Optimizer Hints
July, 25 2013
Pagination Done the Right Way
Use-The-Index-Luke.comArticle
Pagination Done the Right Way
July, 18 2013
Indexes: The neglected performance all-rounder
Use-The-Index-Luke.comArticle
Indexes: The neglected performance all-rounder
July, 10 2013
Afraid of SSD?
Use-The-Index-Luke.comArticle
Afraid of SSD?
July, 2 2013
Training and Conference Dates
Use-The-Index-Luke.comArticle
Training and Conference Dates
May, 21 2013
The two top performance problems caused by ORM tools
Use-The-Index-Luke.comArticle
The two top performance problems caused by ORM tools
April, 23 2013
I need your help!
Use-The-Index-Luke.comArticle
I need your help!
April, 22 2013
Party time
Use-The-Index-Luke.comArticle
Party time
March, 4 2013
Better Performance with PostgreSQL
Use-The-Index-Luke.comArticle
Better Performance with PostgreSQL
February, 22 2013
FOSDEM Impressions
Use-The-Index-Luke.comArticle
FOSDEM Impressions
February, 5 2013
Top Tweets January 2013
Use-The-Index-Luke.comArticle
Top Tweets January 2013
February, 5 2013
I’m speaking at FOSDEM PGDay 2013
Use-The-Index-Luke.comArticle
I’m speaking at FOSDEM PGDay 2013
January, 8 2013
Top Tweets December 2012
Use-The-Index-Luke.comArticle
Top Tweets December 2012
December, 28 2012
Authorship Stats
4Sites51Projects34,190Words
About
Markus Winand is a writer who has produced content for slideshare.net, use-the-index-luke.com, and winand.at
Key Phrases
Sql Performance, Sql Server, Modern Sql, Sql Standard, Oracle Database, Keyset Pagination, Performance Explained, Clustered Indexes, Aggregate Function, Execution Plan
© ClearVoice, Inc.