Past Events
October 2020
October 13+15 — Online
Oracle Code
Panel: SQL or NoSQL? Schema or Schemaless?
Discussion between Morgan Tocker, Bill Karwin and Markus Winand.
May 2020
May 13 — Online (Zoom)
PHP Russia
More Than a Query Language: SQL in the 21st Century
“Great News–The Relational Model is Dead” was a prominent comment on the release of the new SQL standard in 1999. The message behind the provoking statement was that SQL has evolved beyond the relational model. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many developers haven’t heard of it until today.
This talk provides the big picture on the evolution of SQL and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
April 2020
April 20 — Online
Pro Huddle
Java & SQL, Stronger Together
For many Java developers, life without an ORM tool is impossible to imagine. But all these advantages should not prevent one from knowing about alternatives. Just because a specific job can be done with an ORM tool doesn’t automatically mean that there is no better tool for this job.
In this talk I’ll discuss some cases where a modern SQL backend might offer a better alternative. Naturally, I’ll also show how to integrate these SQL solutions into a Java Application using JPA or Spring Data JPA.
We will also see the common patterns such cases follow so you can more easily spot them in the future. Ultimately, ORM vs. SQL is not an either-or question. The concluding example demonstrates how they can work together so that the overall solution is better than each one of the technologies alone could ever accomplish.
February 2020
February 27 — Warsaw, Poland
Warsaw PostgreSQL Users Group
More Than a Query Language: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999?
The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.
This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
November 2019
November 28 — Vilnius, Lithuania
Big Data Conference
More Than a Query Language: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999? The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today. This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
Media: Slides [PDF; 10MB]
Ratings: (n=143)
High - 141
Medium - 2
Low - 0
Reactions:
November 16 — Vienna, Austria
DevFest Vienna
More Than a Query Language: SQL in the 21st Century
“Great News–The Relational Model is Dead” was a prominent comment on the release of the new SQL standard in 1999. The message behind the provoking statement was that SQL has evolved beyond the relational model. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many developers haven’t heard of it until today.
This talk provides the big picture on the evolution of SQL and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
Reactions:
Alexander (@oioki) on Twitter: @MarkusWinand Thank you for the great presentation! I learnt something new today #DevFest19
Gregor Riegler (@gregor_riegler) on Twitter: Great Talk by @MarkusWinand , Modern SQL. learned a lot!
DevFest Vienna (@DevFestVienna) on Twitter: Window functions in SQL:2003 at #DevFest19 #Vienna by @MarkusWinand
November 10 — Sofia, Bulgaria
Bulgaria PHP Conference (BGPHP)
More Than a Query Language: SQL in the 21st Century
“Great News–The Relational Model is Dead” was a prominent comment on the release of the new SQL standard in 1999. The message behind the provoking statement was that SQL has evolved beyond the relational model. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many developers haven’t heard of it until today.
This talk provides the big picture on the evolution of SQL and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
Media: Recording (YouTube), Slides [PDF; 12MB]
Rating on Joind.in: 5.00 / 5.00 (n=10)
Comments:
Arnout Boks on Joind.In: Great talk, it really opened my eyes to a whole bunch of new SQL features.
Milana Cap on Joind.in: Very detailed overview of SQL’s evolvement accompanied with excellent examples and support charts.
Frtis van Tiel on Joind.in: Eye opener
Alexander Makarov on Joind.in: Awesome content. Awesomely performed.
Vasil Vasilev on Joind.in: I was blown off by how many things I dont know, and how much easier my life could have been.
Nikola Poša on Joind.in: Speaker did very good job at delivering this very insightful, eye-opener talk on the current trends and the state of SQL standard.
Jean-Bernard on Joind.in: Was very interesting, many things i didn’t know about modern sql
Sergey Podgornyy on Joind.in: Probably the best conference talk I hear since a long time. Great job, Markus!
Michael Kumar on Joind.in: Best talk of the day.
Lyubomir Filipov (@FilipovG) on Twitter: If you see a self join - Kill it! By @MarkusWinand #bgphp19
Nikola Poša (@nikolaposa) on Twitter: Nice overview about the evolution of SQL standard all the way from SQL-92 to SQL-2016 by @MarkusWinand #bgphp19
Alexander Makarov (@sam_dark) on Twitter: @MarkusWinand talks about SQL.
November 4-8 — Antwerp, Belgum
Devoxx
More Than a Query Language: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999? The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today. This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
Media: Slides [PDF, 15MB], Recording (YouTube)
Rating (via conference App): 4.50 / 5.00 (n=72)
1 x 1: “Too complicated”
1 x 2: “would be 4 or 5, but DO NOT BLAME OTHERS”
2 x 3: 2x “Learned something new”
24 x 4: 11x “Learned something new”, 7x “Very interesting”
44 x 5: 20x “Awesome content”, 10x “Really enjoyed this”, 4x “Amazing speaker”, 1x “A new Devoxx Rock Star is born”
Comments:
Feedback via conference App (rating: 5): scary that as a newly educated developer all training and education i have recieved is sql-92 without anyone mentioning the newer functions
Feedback via conference App (rating: 2): would be 4 or 5, but DO NOT BLAME OTHERS
Olivier Demeijer (@olivierdemeijer) on Twitter Best talk I attended :) Now I’ll read you book ;)
Gökhan Orhun (@gokhan_orhun) on Twitter: So, guess I have to remove SQL from my CV since I don’t know about window functions #Devoxx
Gert Driljeux (@DriljeuxGert) on Twitter: Thanks @MarkusWinand for showing some of the magic of modern SQL... It was an eye opener. #Devoxx #continuum
Charles Sabourdin (@kanedafromparis) on Twitter: Great talk about SQL (so much change since 92, so many feature redevelop could be right under my nose) Knowledge matter #Devoxx
Martijn van Iersel (@mpvaniersel) on Twitter: Oof! @MarkusWinand exposing dangerously outdated #sql knowledge on my part. JSON_TABLE? PERCENTILE_DISC? I have some catching up to do! Very useful talk #Devoxx
Martijn van Iersel (@mpvaniersel) on Twitter: Are #sql databases really #nosql databases if you use all the modern features? At least it feels like that after listening to @MarkusWinand #Devoxx
Jens (@derSatan) on Twitter: I was today days old, when I found out how less I know about modern SQL! Thanks @MarkusWinand #Devoxx #devoxx2019
teilzeitKonservativ (@KapitalFaschist) on Twitter: SQL @Devoxx . What a talk to start your day #Devoxx #DevoxxBE
Tobias Bell (@tobidope) on Twitter: Prepared for the first talk with @MarkusWinand at #devoxx
Jan Vissers (@Jan_Vissers) on Twitter: #Devoxx - “more than a Query language: SQL in the 21st Century” is next. Shout out to @ToonKoppelaars - you can watch this on YouTube now and let us know what you think
October 2019
October 24-25 — Hamburg, Germany
code.talks
Mehr als eine Abfragesprache: SQL im 21. Jahrhundert
SQL-92 war der letzte Standard, der auf die relationale Idee beschränkt war. Ab 1999 wurde SQL um nicht-relationale Operationen und Datenstrukturen erweitert. Obwohl dieser Schritt damals viel diskutiert wurde, dauerte es Jahrzehnte, bis die Datenbankhersteller dieses Paradigmenwechsel verdaut hatten. Viele Entwickler haben bis heute nichts davon gehört.
Das Jahr 2018 markiert aber den Wendepunkt. Mit dem Erscheinen von MySQL 8.0 hat auch die letzte der gängigen SQL-Datenbanken den Paradigmenwechsel vollzogen und unterstützt die wichtigsten nicht-relationalen Konzepte von SQL.
Dieser Vortrag gibt einen Überblick über die Evolution von SQL seit 1999 und stellt einige der neuen Funktionen anhand häufiger Anforderungen vor. Dabei wird auch aufgezeigt, wann diverse Hersteller begonnen haben, nicht-relationales SQL zu unterstützen. Letztendlich zeigt der Vortrag, dass sich SQL in den letzten Jahrzehnten genauso weiterentwickelt hat, wie die Anforderungen mit denen man in der Entwicklung zu tun hat.
Media: Slides [PDF, 10MB], Recording (YouTube)
Reactions:
October 16-18 — Milan, Italy
PgConf.EU
More Than a Query Language: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999?
The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.
This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
Media: Slides [PDF, 15MB]
Rating via conference website (n=20):
Topic Importance: 4.65 / 5.00
Content Quality: 4.85 / 5.00
Speaker Knowledge: 4.90 / 5.00
Speaker Quality: 4.62 / 5.00
Comments:
From the audience, via conference website:
Excellent talk! I learned a lot. I always look forward to your talks. It’s great to hear about features that we won’t always hear about.
I liked the content, but not the form. The talk was offensive, after every raise-your-hand type of question the presenter mocked the audience reminding how dump and stuck-in-the-past we were. This put the audience into defensive not-gonna-answer-any-of-your-questions mode and for his next well meaning and innocent question of “can we use it? how many of you run PostgreSQL newer than 9.3?” received NO hands at all (obviously not true, the majority was running newer than 9.3), but nobody was willing to be mocked and proved wrong again. Good content, but bad form.
Thanks as usual you presentation are always good !
In my eyes, this qualifies as a keynote speech. Very good job presenting and engaging us and extremely informative content. kudos! (will put the stickers in prominent places in the office)
all good thanks.
great talk
Danke wiederum. Niemand erklärt das so gut wie du.
Amazing speaker!
One of the highlights of this conference
Guillaume Lelarge on Twitter: Another talk from @MarkusWinand about SQL language at #pgconfeu !
Mladen Marinović on Twitter: “If you have SQL in your CV and don’t know window funtions you are lying” @MarkusWinand SQL in the 21st century #pgconfeu #Milan
Alexis Gil Gonzales on Twitter: SQL evolution and unusual use-cases. Great presentation by @MarkusWinand #pgconfeu
Claire Giordano @ PGConfEU on Twitter: At #pgconfeu @MarkusWinand of @ModernSQL is presenting “More Than a Query Language: SQL in the 21st Century” & implores his audience to wash their hands after using self joins / lol / #PostgreSQL
Lætitia on Twitter: OH: If you’ve written down “SQL” into your resume but don’t know window functions, you’re basically lying. #pgconfeu @MarkusWinand
October 16-18 — Milan, Italy
PgConf.EU
Be Inclusive: Welcome Non-key Columns in B-Tree Indexes
PostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities that might be even more useful than the support of Index Only Scans.
This talk gives you a brief introduction into b-tree indexes, Index Only Scans and what the INCLUDE clause does. It demonstrates where cases the INCLUDE clause can be beneficial and discusses a few more subtle benefits that are not commonly known. Finally, the talk also shows the limits of the INCLUDE clause in PostgreSQL 11.
Media: Slides [PDF, 3MB]
Rating via conference website (n=30):
Topic Importance: 4.46 / 5
Content Quality: 4.70 / 5
Speaker Knowledge: 4.90 / 5
Speaker Quality: 4.40 / 5
Comments:
From the audience, via conference website:
Nice presentation! Thank you Markus
always very good
Great talk! Clear, efficient and simple.
Really good talk! Good level, good introduction and good advice. Clear slides and examples.
Great topic and presentation! Good job. Perhaps more examples along the way, not only systematic slides. A bit complicated and hard to follow without understanding indexes well already.
DEVersity on Twitter: Be careful when adding new or changing existing indexes. Database never forgets! By @MarkusWinand #pgconfeu
Thomas Boussekey on Twitter: Thanks @MarkusWinand for this great talk on include into btree indexes #pgconfeu
October 1 — Amsterdam, The Netherlands
Percona Live Amsterdam
More Than a Query Language: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999?
The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.
The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.
Media: Slides [PDF, 12MB]
Reactions:
Boriss Mejias on Twitter: Very nice talk @MarkusWinand at #PerconaLiveEU.
Georgi D. Sotirov on Twitter: Listening again to @MarkusWinand ’s presentation “SQL in the 21st Century” I find it even more interesting. Wash your hands after using self-join! #PerconaLiveEU #SQL #modernsql #usetheindexluke
Percona Community on Twitter: @MarkusWinand (creator of http://modern-sql.com) talks about #SQL in the 21st Century. #perconalive #percona
think(x) on Twitter: Survey of the most important SQL databases from @MarkusWinand #perconalive @amplifypostgres
think(x) on Twitter: Great online. Better in person. Enjoyed the deep treatise on the state of SQL implementations at #Percona #PerconaLiveEU
August 2019
August 10 — St. Augustin, Germany
FrOSCon
Neues in Open-Source-SQL-Datenbanken
SQL ist ein lebender Standard mit Hunderten optionalen Funktionen. Traditionell wurden diese optionalen Funktionen von Open-Source-SQL-Datenbanken nur sehr lückenhaft unterstützt. In den letzten Jahren ist jedoch Schwung in die Sache gekommen.
Dieser Vortrag stellt die SQL-Funktionen vor, die in den letzten Versionen von MariaDB, MySQL, PostgreSQL und SQLite eingeführt wurden und damit einer breiten Anwenderbasis zur Verfügung stehen.
Media: Slides [5MB; PDF], Video (German, ccc.de)
Reactions:
Niels Theen on Twitter: Came late to @MarkusWinand talk, but it’s always worth it!
July 2019
July 3-4 — Munich, Germany
Clean Code Days
SQL als Clean Code Werkzeug?
SQL hat als deklarative Sprache einen Startvorteil in Sachen Clean Code. Leider wird das oft nicht so gesehen, da das SQL-Know-how in der Branche gut 20 Jahre hinter dem Stand der Technik ist.
Dieser Vortrag gibt einen Überblick über die Evolution von SQL seit 1999 und stellt einige der neuen Funktionen anhand häufiger Anforderungen vor. Dabei wird hervorgehoben, wie man heutzutage “sauberes” SQL nutzten kann. Letztendlich zeigt der Vortrag, dass sich SQL in den letzten Jahrzehnten genauso weiterentwickelt hat, wie die Anforderungen mit denen man in der Entwicklung zu tun hat.
Reactions:
Christoph Mayer on Twitter: „Saubererer Code ist immer möglich“ #cleanSql #CleanCode @MarkusWinand @Clean_Code_Days
June 2019
June 24-26 — Nuremberg, Germany
DWX - Developer Week
Die Mutter aller Abfragesprachen: SQL im 21. Jahrhundert
Wussten Sie, dass das rein relationale Dogma von SQL bereits 1999 aufgegeben wurde?
SQL-92 war der letzte Standard, der auf die relationale Idee beschränkt war. Ab 1999 wurde SQL um nicht-relationale Operationen und Datenstrukturen erweitert. Obwohl dieser Schritt damals viel diskutiert wurde, dauerte es Jahrzehnte, bis die Datenbankhersteller dieses Paradigmenwechsel verdaut hatten. Viele Entwickler haben bis heute nichts davon gehört.
Dieser Vortrag gibt einen Überblick über die Evolution von SQL seit 1999 und stellt einige der neuen Funktionen anhand häufiger Anforderungen vor. Dabei wird auch aufgezeigt, wann diverse Hersteller begonnen haben, nicht-relationales SQL zu unterstützen. Letztendlich zeigt der Vortrag, dass sich SQL in den letzten Jahrzehnten genauso weiterentwickelt hat, wie die Anforderungen mit denen man in der Entwicklung zu tun hat.
Media: Slides [PDF; 14MB]
June 5 — Berlin, Germany
International PHP Conference
Modern SQL: Evolution of a dinosaur
Purely relational SQL has been abandoned in 1999. Since then, SQL has got many non-relational features for problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.
This presentation demonstrates what modern SQL can do for you. It compares two different approaches to common problems: a purely relational one and the modern SQL approach.
In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!
Recording: on YouTube
Ratings (n=45)
Quality of the presentation: 4.8 (conference average: 3.8)
Speaker’s knowledge of the subject: 4.8 (conference average: 4.4)
Feedback via the Conference:
Perfect
exceptional session with expertise knowledge, thank you
learned a lot
The best talk so far, presentner is very knowledgeable about the topic
Reactions:
Andi Rückauer on his blog: It was a bliss listening to Markus share his expertise on SQL. The session was absolutely interesting and informative.
Andi Rückauer on Twitter:
JustCurious on Twitter: Was a good presentation, thank you! Especially liked the “caniuse” slides.
Chema on Twitter: Really nice talk @MarkusWinand. How many things were there in #SQL and I had no clue. Thanks, @ModernSQL! #IPC19
Marius Adrian on Twitter: Wow! I just found out that system versioned tables is a feature included in SQL!!! Very interesting talk @MarkusWinand! #IPC19
Sasa Blagojevic on Twitter: It’ll be packed, I loved your talk at @webcampzagreb last year, learned a ton in a short time span :D
June 7 — Amsterdam, Netherlands
Dutch PHP Conference 2019
More Than a Query Language: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999?
The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.
The year 2018 finally marks the turning point. With the release of MySQL 8.0 all major SQL dialects finally support the most important non-relational concepts of SQL.
This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
What will people learn from your talk:
...how to process graphs in SQL
...how to do JSON transformations
...about time traveling in SQL
Recording: at YouTube
Reactions:
Bert-Jan de Lange on Twitter: The relational model is only 20% of the current SQL standard #dpc19
Bert-Jan de Lange on Twitter: SQL is not a query language, it’s a transformation language #DPC19
M1ke on Twitter: A _lot_ of interested looks between colleagues as @MarkusWinand talks about automated system versioning in SQL #DPC19
M1ke on Twitter: It’s @MarkusWinand teaching us some SQL recursive query magic #DPC19
Wouter Kamphuis on Joind.in: Really interesting and learned more about sql
Gert de Pagter on Joind.in: I thought i knew SQL. I learned that i know very little about SQL, but more than yesterday
June 3 — Karlsruhe, Germany
Karlsruher Entwicklertag 2019
Volkskrankheit “stiefmütterliche Indizierung”
Dieser Vortrag geht kurz auf die häufigste Ursache schlechter SQL-Performance – die Index/Query-Inkompatibilität – ein und erklärt, wie es dazu kommen konnte. Der Hauptteil des Vortrages widmet sich der Lösung dieses Problems auf äußerst unterhaltsame weise: In einem Livequiz mit dem Publikum werden die wichtigsten Beispiele der Index/Query-Inkompatibilität demonstriert und gezeigt, wie sich die Performance mit einfachen Mitteln um Faktoren verbessern lässt.
Rating:
22 like
1 neutral
0 dislike
Feedback:
Sehr anschaulich, unterhaltsam + lehrreich
Quiz war eine sehr gute Idee. Sehr kurzweilig, sehr gut erklärt - auch für den Ex-Entwickler & jetzt Teamleiter ;-)
Lustiger Vortrag, gute Einbeziehung des Publikums
Bester Talk heute!
Sehr lebhaft, ansprechend
Super hilfreicher Vortrag
Großartig
Sehr kurzweilig.
Sehr gut, gute Beispiele in gut erklärt
June 4 — Karlsruhe, Germany
Karlsruher Entwicklertag 2019
Mehr als eine Abfragesprache: SQL im 21. Jahrhundert
Wussten Sie, dass das rein relationale Dogma von SQL bereits 1999 aufgegeben wurde?
SQL-92 war der letzte Standard, der auf die relationale Idee beschränkt war. Ab 1999 wurde SQL um nicht-relationale Operationen und Datenstrukturen erweitert. Obwohl dieser Schritt damals viel diskutiert wurde, dauerte es Jahrzehnte, bis die Datenbankhersteller dieses Paradigmenwechsel verdaut hatten. Viele Entwickler haben bis heute nichts davon gehört.
Das Jahr 2018 markiert aber den Wendepunkt. Mit dem Erscheinen von MySQL 8.0 hat auch die letzte der gängigen SQL-Datenbanken den Paradigmenwechsel vollzogen und unterstützt die wichtigsten nicht-relationalen Konzepte von SQL.
Dieser Vortrag gibt einen Überblick über die Evolution von SQL seit 1999. Neben Rekursionen und Window-Funktionen wird die Unterstützung schemaloser Dokumente (JSON) und die Zeitreisefähigkeiten von SQL vorgestellt. Dabei wird auch aufgezeigt, wann diverse Hersteller begonnen haben, nicht-relationales SQL zu unterstützen. Letztendlich zeigt der Vortrag, dass sich SQL in den letzten Jahrzehnten genauso weiterentwickelt hat, wie die Anforderungen mit denen man in der Entwicklung zu tun hat.
Der Vortrag richtet sich an Entwickler und Architekten, die einen Überblick über den aktuellen Stand von SQL erhalten wollen.
Rating:
23 like
0 neutral
0 dislike
Feedback:
Der Trainer war sehr qualifiziert!
Sehr aufschlussreich.
Gut frei gesprochen, spannende Features von SQL gelernt :)
Ich hatte ja keine Ahnung, was es da alles gibt ;-)
Es lohnt sich, auf einige der Features zu schauen -> sehr prägnanter Überblick
Witzig. Genau richtig schnell
Bester Vortrag der ganzen Konferenz!
Toller Überblick
Sehr gut und sehr locker vorgetragen.
Interessant! Viele Infos in kurzer Zeit.
May 2019
May 30-31 — Riga, Latvia
Riga Dev Days
Modern SQL: Evolution of a dinosaur
Purely relational SQL has been abandoned in 1999. Since then, SQL has got many non-relational features for problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.
This presentation demonstrates what modern SQL can do for you. It compares two different approaches to common problems: a purely relational one and the modern SQL approach.
In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!
Media: Slides [PDF; 14MB]
Ratings:
Talk quality: 4.61
Talk Performance: 4.42
Comments:
logical, very good to follow
Boring
really good speach with excelent balance between theory and practice.
I expected more information on performance of those modern sql features. we can use them on some of the new databases, but what about performance penalty? Not sure it would fit in the topic since my concerns do not apply the same way for all db vendors
excellent. goes exactly to the points in a simple way.
May 28-29 — Sofia, Bulgaria
jPrime
More Than a Query Language: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999? The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today. This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
May 25 — St. Augustin, Germany
SQL Saturday Rheinland (#856)
More Than a Query Language: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999?
The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.
This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
Reactions:
I did not expect, that I would enjoy to listen to a pure PowerPoint presentation. It was quite interesting. (rated 5 of 5).
May 21 — Dresden, Germany
Dev Day Dresden
Die Mutter aller Abfragesprachen: SQL im 21. Jahrhundert
Wussten Sie, dass das rein relationale Dogma von SQL bereits 1999 aufgegeben wurde?
SQL-92 war der letzte Standard, der auf die relationale Idee beschränkt war. Ab 1999 wurde SQL um nicht-relationale Operationen und Datenstrukturen erweitert. Obwohl dieser Schritt damals viel diskutiert wurde, dauerte es Jahrzehnte, bis die Datenbankhersteller dieses Paradigmenwechsel verdaut hatten. Viele Entwickler haben bis heute nichts davon gehört.
Dieser Vortrag gibt einen Überblick über die Evolution von SQL seit 1999 und stellt einige der neuen Funktionen anhand häufiger Anforderungen vor. Dabei wird auch aufgezeigt, wann diverse Hersteller begonnen haben, nicht-relationales SQL zu unterstützen. Letztendlich zeigt der Vortrag, dass sich SQL in den letzten Jahrzehnten genauso weiterentwickelt hat, wie die Anforderungen mit denen man in der Entwicklung zu tun hat.
Media: Slides [PDF; 18MB]
Reactions:
Twitter: Thanks @MarkusWinand for such a great talk at #devdaydd
Twitter: @MarkusWinand mit @ModernSQL bisher bester Vortrag beim #devdaydd
Twitter: super Vortrag. Viele neue Ideen die man unbedingt mal ausprobieren muss #devdaydd @MarkusWinand
Twitter: Tolles Plädoyer von @MarkusWinand, #SQL auch jenseits von #CRUD in Betracht zu ziehen. #DevDayDD
Twitter: Erkenntnis des Tages: A lot has happenes since SQL-92. Thanks @MarkusWinand #devdaydd #devday19
Mai 8 — Mainz, Germany
JAX 2019
Modernes SQL: Evolution eines Dinosauriers
Das relationale Dogma von SQL wurde bereits 1999 aufgegeben. Seither hat SQL viele nicht relationale Funktionen erhalten, die einfache Lösungen für Probleme bieten, die mit relationaler Logik nur sehr mühsam umzusetzen sind. Heute ist SQL Turing-Complete, kann Graphen verarbeiten, mit XML- und JSON-Dokumenten umgehen, alte Daten automatisch versionieren, Zeitreihen mit Regular Expressions analysieren und vieles mehr.
Dieser Vortrag zeigt, was modernes SQL für Dich tun kann. Er vergleicht jeweils zwei Lösungsansätze zu häufigen Problemstellungen: den relationalen und den modernen Ansatz. Dadurch erhalten Entwickler und Architekten ein besseres Verständnis, wo SQL heute steht und sind damit in der Lage, bessere Entscheidungen zu treffen. Seit SQL-92 hat sich einiges getan!
Media: Slides [PDF; 6MB], Video on YouTube (German)
Reactions:
Ratings in conference App (n=67) (1-5; 5=best):
Quality of the presentation: 4.7 (conference average: 4.0)
Speaker’s knowledge of the subject: 4.9 (conference average: 4.4)
Participants feedback:
Super Aufbau. Klasse rübergebracht
Packend! Unterhaltsam! Zu kurz!
sehr intressant und auch amüsant
Sehr toller Vortrag über die Neuigkeiten und Verbesserungsmöglichkeiten.
Kompetent, witzig und kurzweilig
5 Sterne für Inhalt und Präsentation.
technisch sehr tief drin, aber eine nette Auswahl an Features. Danke
Richtig gut!!
Toller Vortrag!
Gut und praxisgerecht erklärt.
Wiederholung aber gut. Wiedersehen macht Freude
Mai 10 — Leipzig, Germany
PgConf.DE
Niemanden ausschließen: Begrüße Nicht-Schlüssel-Spalten in B-Tree-Indizes
PostgreSQL 11 hat die CREATE INDEX-Anweisung für B-Tree-Indizes um die INCLUDE-Klausel erweitert. Die bekannteste Anwendung dieser Klausel ist es, einen Index Only Scan zu ermöglichen, ohne die selektierten Spalten in den Indexes-Schlüssel aufzunehmen. Die INCLUDE-Klausel hat jedoch auch andere Anwendungsfälle, die vielleicht noch nützlicher als der Index Only Scan sind.
Dieser Vortrag gibt eine kurze Einführung in B-Tree-Indizes, Index Only Scans und was die INCLUDE-Klausel bewirkt. Neben dem Index Only Scan werden auch Anwendungen gezeigt, die etwas subtiler, aber mindestens so nützlich wie der Index Only Scan sind. Abschließend werden auch noch die grenzen der INCLUDE-Klausel in PostrgreSQL 11 aufgezeigt.
Media: Slides [PDF; 2MB]
Mai 2 — Vienna, Austria
Linux Wochen Wien
Neues in Open-Source-SQL-Datenbanken
Open-source SQL-Datenbanken erweitern Ihren SQL-Dialekt momentan in rasantem Tempo. Dieser Vortrag gibt einen kurzen Überblick.
SQL ist ein lebender Standard mit Hunderten optionalen Funktionen. Traditionell wurden diese optionalen Funktionen von Open-Source-SQL-Datenbanken nur sehr lückenhaft unterstützt. In den letzten Jahren ist jedoch Schwung in die Sache gekommen.
Dieser Vortrag stellt die SQL-Funktionen vor, die in den letzten Versionen von MariaDB, MySQL, PostgreSQL und SQLite eingeführt wurden und damit einer breiten Anwenderbasis zur Verfügung stehen.
Media: Slides [PDF 8MB].
April 2019
April 12 — Vienna, Austria
Enterprise Java User Group Austria
More Than a Query Language: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999? The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.
This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
Slides: [PDF; 23MB]
April 9 — Berlin, Germany
Oracle Code Berlin 2019
More Than a Query Language: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999? The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.
This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
March 2019
March 22 — Berlin, Germany
BOB Konferenz 2019
Modern SQL: Evolution of a dinosaur (45 minutes talk)
Purely relational SQL has been abandoned in 1999. Since then, SQL has got many non-relational features for problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.
This presentation demonstrates what modern SQL can do for you. It compares two different approaches to common problems: a purely relational one and the modern SQL approach. You will see that modern SQL databases are the Swiss Army Knives of persistence which allow up to react quickly when requirements change.
In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!
Media: Recording at YouTube.
Reactions:
Annette Bieniusa on Twitter: I am more of the NewSQL and Apple person, but interesting examples #BOBkonf2019
March 22 — Berlin, Germany
BOB Konferenz 2019
Superficial SQL Indexing: An Epidemic Plague (90 min tutorial)
What if a single root cause was responsible for most SQL performance issues?
Proper indexing is a very time and cost-effective way to improve SQL performance. Yet hardly anyone gets it right so that about 50% of all SQL performance problems can be attributed to the index/query mismatch.
In this tutorial I’ll explain how organizational structures hinder proper indexing and why it is not sufficiently covered in the relevant literature. Naturally, this tutorial will also explain how to approach indexing for a better result and demonstrate the most common indexing mistakes in a fun and educating way: in a live quiz with the audience.
March 20 — Bucharest, Romania
Voxxed Days Bucharest 2019
Full-day Workshop: Modern SQL: Aggregation and Analysis
SQL is a powerful tool that can easily replace hundreds lines of code by a few lines of SQL—in the end, the SQL query will even run faster as the home-grown code. This workshop gives a grounds-up introduction into window functions (aka. the OVER clause), one of the SQL features to leverage that benefit.
March 21 — Bucharest, Romania
Voxxed Days Bucharest 2019
The Mother of all Query Languages: SQL in the 21st Century
Did you know the purely relational dogma of SQL was already abandoned in 1999? The last SQL standard that was limited to the relational idea was SQL-92. From SQL: 1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today. The year 2018 finally marks the turning point. With the release of MySQL 8.0 all major SQL dialects finally support the most important non-relational concepts of SQL. This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.
Media: Slides [PDF; 22MB], Video recording (YouTube)
Reactions:
March 12 — Paris, France
pgDay Paris
Be Inclusive: Welcome Non-key Columns in B-Tree Indexes
PostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities that might be even more useful than the support of Index Only Scans.
This talk gives you a brief introduction into b-tree indexes, Index Only Scans and what the INCLUDE clause does. It demonstrates where cases the INCLUDE clause can be beneficial and discusses a few more subtle benefits that are not commonly known. Finally, the talk also shows the limits of the INCLUDE clause in PostgreSQL 11.
Media: PDF [5MB], Video (YouTube)
Reactions:
Andreas Pizsa on Twitter: I just learned something useful from this tweet, thanks :)
superette on Twitter: introduction on include for btree indexes with @MarkusWinand in @pgDayParis #pg11
Nicolas Lutic on Twitter: #pgDayParis @MarkusWinand Be Inclusive: Welcome Non-key Columns in B-Tree Indexes
(((Stefanie))) on Twitter: @MarkusWinand giving his talk Be Inclusive: Welcome Non-key Columns in B-Tree Indexes at #PGDayParis
sebastien delobel on Twitter: Great presentation about include in index of #PostgreSQL 11 by @MarkusWinand in @pgDayParis
Lukas Fittl on Twitter: Detailed talk at @pgDayParis by @MarkusWinand on index structures and how INCLUDE works in Postgres 11 (and when you may not want to use it)
Anthony Nowocien on Twitter: PostgreSQL 11 finally supports the INCLUDE clause for CREATE INDEX and @MarkusWinand will show us its pros... and cons. #pgDayParis
Espen on Twitter: At @pgDayParis listening to @MarkusWinand from the very useful https://use-the-index-luke.com
pgDay Paris on Twitter: We welcome @MarkusWinand arriving at #pgdayparis.
sebastien delobel on Twitter: @MarkusWinand is in the place of @pgDayParis @ModernSQL
February 2019
February 21 — Frankfurt, Germany
Frankfurter Entwicklertag 2019
Die Mutter aller Abfragesprachen: SQL im 21. Jahrhundert
Wussten Sie, dass das rein relationale Dogma von SQL bereits 1999 aufgegeben wurde?
SQL-92 war der letzte Standard, der auf die relationale Idee beschränkt war. Ab 1999 wurde SQL um nicht-relationale Operationen und Datenstrukturen erweitert. Obwohl dieser Schritt damals viel diskutiert wurde, dauerte es Jahrzehnte, bis die Datenbankhersteller dieses Paradigmenwechsel verdaut hatten. Viele Entwickler haben bis heute nichts davon gehört.
Das Jahr 2018 markiert aber den Wendepunkt. Mit dem Erscheinen von MySQL 8.0 hat auch die letzte der gängigen SQL-Datenbanken den Paradigmenwechsel vollzogen und unterstützt die wichtigsten nicht-relationalen Konzepte von SQL.
Dieser Vortrag gibt einen Überblick über die Evolution von SQL seit 1999. Neben Rekursionen und Window-Funktionen wird die Unterstützung schemaloser Dokumente (JSON) und die Zeitreisefähigkeiten von SQL vorgestellt. Dabei wird auch aufgezeigt, wann diverse Hersteller begonnen haben, nicht-relationales SQL zu unterstützen. Letztendlich zeigt der Vortrag, dass sich SQL in den letzten Jahrzehnten genauso weiterentwickelt hat, wie die Anforderungen mit denen man in der Entwicklung zu tun hat.
Egnlish Slides: at entwicklertag.de.
Ratings: Green: 20 Yellow: 0 Red: 0
Comments (via the conferences comment function):
Super Vortrag!
Super spannender gut gemachter Vortrag! Dieses Wissen muss in die Welt.
Super!
Super Vortrag und Vortragender
Unterhaltsam und informativ. Danke für die Übersicht.
Sympathischen speaker- sehr toll!
Ein wenig wissenschafts-geschädigt aber was soll man machen
Was gelernt und Spass gehabt.
Hat die Beschreibung genau entsprochen
Guter Vortrag, klare Struktur, Beispiele auch für mich mit wenig SQL wissen verständlich.
Danke fürs kommen
Vielen Dank für die Einblicke!! Erstaunlich. Wird meine Arbeit ändern.
December 2018
December 11 (evening) — Düsseldorf, Germany
Web Engineering Düsseldorf
Modern SQL: Evolution of a dinosaur
SQL has evolved considerably in recent years. The purely relational dogma was already abandoned in 1999. What followed was continuous extension through the incorporation of handy features to address problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.
This session walks through the SQL standards from 1999 to the current version of 2016. It demonstrates some selected features on the basis of common problems and compares the traditional SQL-92 solution to the modern SQL approach. Of course, the presentation also shows how long these features are supported by various databases so that you immediately know whether the shown solutions work in your environment or not.
In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!
Free registration required. Event yet to be announced on meetup.com ⇗
December 12 — Frankfurt, Germany
IT-Tage
Oracle Row Pattern Matching: Datenanalyse auf neuem Level
Das Erkennen von Mustern in Zeitreihen wurde durch die MATCH_RECOGNIZE-Klausel in Oracle 12c erheblich vereinfacht. Leider ist diese Klausel unter Entwicklern noch wenig bekannt und wird daher kaum genutzt. Dieser Vortrag führt in das Thema ein und zeigt einige typische (und weniger typische) Anwendungen, die sich mit MATCH_RECOGNIZE wesentlich einfacher lösen lassen als mit anderen SQL-Funktionen.
Ticket: €693 (one day, early bird) - €1399 (three days, regular price). Use code ITT18-SP for 10% off! Conference website ⇗
November 2018
November 22-23 — Berlin, Germany
Data Natives
The Mother of all Query Languages: SQL in Modern Times
Did you know the purely relational dogma of SQL was already abandoned in 1999?
The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.
The year 2018 finally marks the turning point. With the release of MySQL 8.0 all major SQL dialects finally support the most important non-relational concepts of SQL.
This talk provides the big picture on the evolution of the SQL standard. You will see that SQL has changed as much as our requirements have changed over the past decades.
Media: slides [PDF, 5MB], video (YouTube)
Reactions:
Rated ~4.75 (of 5) stars by the audience (14 votes).
October 2018
October 28 (Sun) — Prague, Czech Republic
phpCE
Modern SQL: Evolution of a dinosaur
SQL has evolved considerably in recent years. The purely relational dogma was already abandoned in 1999. What followed was continuous extension through the incorporation of handy features to address problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.
This session walks through the SQL standards from 1999 to the current version of 2016. It demonstrates some selected features on the basis of common problems and compares the traditional SQL-92 solution to the modern SQL approach. Of course, the presentation also shows how long these features are supported by various databases so that you immediately know whether the shown solutions work in your environment or not. Teaser: MySQL and MariaDB have got huge updated lately.
In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!
Reactions:
Grzegorz Skorupa on Joind.in: A really good talk. I have realized that I do not know many SQL areas (5 thumbs up)
Leszek Prabucki on Joind.in: I just realize after that talk that I have to learn modern SQL. Thanks (5 thumbs up)
Tweet by misiaq.com: And now for something completely different - some good SQL stuff by @MarkusWinand at @phpce_eu #phpce #phpce18
October 27 (Saturday) — Munich, Germany
SQL Saturday #772
Epidemic Plague: Superficial Indexing
Proper indexing is a very time and cost-effective way to improve SQL performance. Yet hardly anyone gets it right or knows how different ways to write a query affects indexing and performance. In this session I’ll explain why this knowledge is sparse and what developers can do about it. Finally we will go through the most important indexing mistakes by example and discuss them during a short live quiz with the audience.
Free registration required. Conference Website ⇗
October 25 — Budapest, Hungary
Data Science meetup Crunch edition
The Mother of all Query Languages: SQL in Modern Times
Did you know the purely relational dogma of SQL was already abandoned in 1999?
The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.
The year 2018 finally marks the turning point. With the release of MySQL 8.0 all major SQL dialects finally support the most important non-relational concepts of SQL.
This talk provides the big picture on the evolution of the SQL standard. You will see that SQL has changed as much as our requirements have changed over the past decades.
Reactions:
Tweet by Julianna Göbölös-Sz.: Great and easy to understand presentation about less known SQL features by @ModernSQL at the Budapest Data Science Meetup! Thanks for making SQL cool!
October 5-6 — Zagreb, Croatia
WebCamp Zagreb 2018
Modernes SQL: Evolution of a dinosaur
Most developers use SQL like 25 years ago. A lot has changed since then. Modern SQL makes every developer’s life easier.
SQL has evolved considerably in recent years. The purely relational dogma was already abandoned in 1999. What followed was continuous extension through the incorporation of handy features to address problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.
This session walks through the SQL standards from 1999 to the current version of 2016. It demonstrates some selected features on the basis of common problems and compares the traditional SQL-92 solution to the modern SQL approach. Of course, the presentation also shows how long these features are supported by various databases so that you immediately know whether the shown solutions work in your environment or not.
In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!
Reactions:
zeljko mikic at joind.in: Well structured talk, and there was a real moment of magic, with explanation on oppened slide in a matter of seconds with an example.
Stanko Krtalic Rusendic at joind.in: The speaker is clear, eloquent and extremely funny to listen to. I was afraid to blink not to miss a second of the talk. Only the highest prases for this talk.
Domagoj Štrekelj at joind.in: A definite highlight of the conference, an eye-opening and entertaining talk unlike any other.
Read all comments on joind.in. Total score: 5.0/5 (n=9) as of 2018-10-07.
Dainius on Twitter: Falling in love with sql again, here in #wczg. @MarkusWinand is like a cupid of sql world. Thanks Markus, great talk.
Luka Kladaric on Twitter: “All employees MUST CHOP OFF HANDS after using OFFSET!” “What’s wrong with OFFSET? It’s slow. And its wrong.”
Pim Elshoff on Twitter: Look at all the cool “new” stuff MySQL can’t do :D
Pim Elshoff on Twitter: Impressed with @MarkusWinand. A “boring” subject delivered with humor, sense, and a hint of intimidation...
Sasa Blagojevic on Twitter: @MarkusWinand talk about SQL at @webcampzagreb is both awesome and self-deprecating. Now I’m aware how outdated I am when it comes to SQL, it’s equivalent to using php 4
Luka Kladaric on Twitter: “If you see a self-join, kill it. All employees must wash hands after performing a self-join." @MarkusWinand #wczg I’m calling it -- the best talk of the conference.
Rated 4.66 (out of 5) on average by 125 participants.
September 2018
September 26-28 — Krakow, Polen
DevConf 2018
Modernes SQL: Evolution of a dinosaur
SQL has evolved considerably in recent years. The purely relational dogma was already abandoned in 1999. What followed was continuous extension through the incorporation of handy features to address problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.
This session walks through the SQL standards from 1999 to the current version of 2016. It demonstrates some selected features on the basis of common problems and compares the traditional SQL-92 solution to the modern SQL approach. Of course, the presentation also shows how long these features are supported by various databases so that you immediately know whether the shown solutions work in your environment or not.
In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!
Reactions:
Tweet by Bartłomiej Rodak: Stop using offset #devconfPL
September 25-27 — Mainz, Germany
BASTA!
Modernes SQL: Evolution eines Dinosauriers
SQL hat sich in den letzten Jahren erheblich weiterentwickelt. Denn das rein relationale Dogma wurde bereits im Jahr 1999 aufgegeben. Es folgte eine stetige Erweiterung um praktikable Lösungen für Probleme, die mit der relationalen Algebra nur sehr umständlich zu lösen sind. Heute kann man mit SQL sogar in so manchem NoSQL-System sehr komplexe Auswertungen schneller, effizienter und vor allem korrekter umsetzen, als mit anderen Programmiersprachen. Seit SQL-92 hat sich einiges getan!
Ratings (n=13; in parenthesis: conference average)
Quality of the presentation: 4.0 (4.1)
Speaker’s knowledge of the subject: 4.5 (4.6)
Comments in the conference app:
praxisnahe
einige interessante Infos für die tägliche Arbeit. Top!
September 12-13 — Oslo, Norway
JavaZone
Modern SQL: Evolution of a dinosaur
SQL has evolved considerably in recent years. The purely relational dogma was already abandoned in 1999. What followed was continuous extension through the incorporation of handy features to address problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.
This session walks through the SQL standards from 1999 to the current version of 2016. It demonstrates some selected features on the basis of common problems and compares the traditional SQL-92 solution to the modern SQL approach. Of course, the presentation also shows how long these features are supported by various databases so that you immediately know whether the shown solutions work in your environment or not.
In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!
Media: Video at Vimeo, slides.
Reactions:
Tweet by Vidar Eidissen: @MarkusWinand presenting modern #SQL at #JavaZone. Hope the audience is paying close attention, since it’ll require less Java code and boost performance
Tweet by Lasse Jenssen: @javazone Fun to see almost full class listening to «Modern SQL» by @marcuswinand
Tweet by Martin Skarsaune: Really useful talk on @ModernSQL @javazone
Tweet by Vlad Mihalcea: @MarkusWinand speaking about Modern SQL @javazone
August 2018
August 25-26 — St. Augustin, Germany
FrOSCon
Volkskrankheit „stiefmütterliche SQL-Indizierung“
SQL-Indizierung gehört zur Softwareentwicklung. Warum Entwickler den Kopf nicht länger in den Sand stecken sollten zeigt dieser Vortrag.
Dieser Vortrag geht kurz auf die häufigste Ursache schlechter SQL-Performance ein – die Index/Query-Inkompatibilität – und erklärt, wie es dazu kommen konnte. Der Hauptteil des Vortrages widmet sich der Lösung dieses Problems auf äußerst unterhaltsame Weise: In einem Live-Quiz mit dem Publikum werden die wichtigsten Beispiele der Index/Query-Inkompatibilität demonstriert und gezeigt, wie sich die Performance mit einfachen Mitteln um Faktoren verbessern lässt.
Video recording: At CCC, at YouTube
Reactions:
July 2018
Prague PostgreSQL Meetup – Prague, Czech Republic – 2018-07-30 (18:00)
How PostgreSQL’s SQL dialect stays ahead of its competitors
PostgreSQL has the best support of standard SQL features among its competitors. But the two free main competitors (MySQL and MariaDB) have recently started to embrace modern SQL too and closed some of the major gaps they have had for decades: Window functions (OVER) and common table expressions (CTEs, WITH) are now supported by both, MySQL and MariaDB. MariaDB even rushes ahead by adding so-called “system versioned tables” in version 10.3 released in May 2018.
This presentation provides an overview how PostgreSQL keeps up being the most advanced open source database. I will present some interesting features introduced to PostgreSQL recently but also give an outlook to features that are (hopefully) coming with PostgreSQL 11 and beyond.
PostgreSQL España – Madrid, Spain – 2018-07-18
How PostgreSQL’s SQL dialect stays ahead of its competitors
PostgreSQL has the best support of standard SQL features among its competitors. But the two free main competitors (MySQL and MariaDB) have recently started to embrace modern SQL too and closed some of the major gaps they have had for decades: Window functions (OVER) and common table expressions (CTEs, WITH) are now supported by both, MySQL and MariaDB. MariaDB even rushes ahead by adding so-called “system versioned tables” in version 10.3 released in May 2018.
This presentation provides an overview how PostgreSQL keeps up being the most advanced open source database. I will present some interesting features introduced to PostgreSQL recently but also give an outlook to features that are (hopefully) coming with PostgreSQL 11 and beyond.
Reactions:
PGConf UK – London, United Kingdom – 2018-07-03
Standard SQL features where PostgreSQL beats its competitor
The SQL standard has more than 4300 pages and hundreds of optional features. The number of features offered by different products varies vastly. PostgreSQL implements a relatively large number of them.
In this session I present some standard SQL features that work in PostgreSQL, but not in other popular open-source databases. But when it comes to standard conformance, PostgreSQL doesn’t even need to fear the comparison to its commercial competitors: PostgreSQL also supports a few useful standard SQL features that don’t work in any of the three most popular commercial SQL databases.
Reactions:
June 2018
Austrian Oracle User Conference – Vienna, Austria – 2018-06-12
Row Pattern Matching — Datenanalyse auf neuem Level
Das Erkennen von Mustern in Zeitreihen wurde durch die MATCH_RECOGNIZE-Klausel in Oracle 12c erheblich vereinfacht. Leider ist diese Klausel unter Entwicklern noch wenig bekannt und wird daher kaum genutzt. Dieser Vortrag führt in das Thema ein und zeigt einige typische (und weniger typische) Anwendungen, die sich mit MATCH_RECOGNIZE wesentlich einfacher lösen lassen als mit anderen SQL-Funktionen.
May 2018
PgCon.org – Ottawa, Canada – 2018-05-31 - 2018-06-01
Standard SQL Gap Analysis: Standard SQL features where PostgreSQL lags behind its competitors
PostgreSQL supports an impressive number of standard SQL features in an outstanding quality. Yet there remain some cases where other databases exceed PostgreSQL’s capabilities in regard to standard SQL conformance.
This session presents the gaps found during an in-depth comparison of selected standard SQL features among six popular SQL databases. The selected features include, among others, window functions and common tables expressions—both of them were recently introduced to MySQL and MariaDB.
The comparison uses a set of conformance tests I use for my website modern-sql.com. These tests are based on the SQL:2016 standard and attempt to do a rather complete test of the requirements set out in the standard. This includes the correct declared type of expressions as well as the correct SQLSTATE in case of errors (teaser: nobody seems to care about SQLSTATE).
This presentation covers two aspects: (1) features not supported by PostgreSQL but by other databases; (2) features available in PostgreSQL that are less complete or conforming as in other databases.
Slides: https://modern-sql.com/slides/pgcon-2018-gap-analysis.pdf
Video Recording: at YouTube.
GeeCON – Kraków, Poland – 2018-05-10
Modern SQL: Evolution of a dinosaur
With these topics: WITH, WITH RECURSIVE, OVER, XMLTABLE, FETCH FIRST, OFFSET, System Versioning, LISTAGG.
Video recording: Coming soon.
Reactions:
- Axel Fontaine on Twitter
Excellent talk on SQL by @MarkusWinand
- Voted #1 talk of the conference by the audience.
April 2018
German: Grazer Linux Tage – Graz, Austria – 2018-04-28
Modernes SQL in Open-Source Datenbanken
With these topics: WITH, WITH RECURSIVE, GROUPING SETS, FILTER, BOOLEAN tests, OVER, System Versioning.
Video recording: YouTube, ccc.de.
March 2018
Voxxed Days Vienna – Vienna, Austria – 2018-03-12 – 2018-03-13
Modern SQL: A lot has changed since SQL-92
With these features: WITH, WITH RECURSIVE, GROUPING SETS, FILTER, OVER, FETCH FIRST, OFFSET, System Versioning, MATCH_RECOGNIZE
Video recording: YouTube.
Reactions:
- @blalasaadri auf Twitter
After watching the talk by @MarkusWinand at #VoxxedVienna I am aware that I don’t know #SQL.
- @michaeltecourt auf Twitter
Great talk about modern SQL, so much knowledge packed in a 1h session
- @GottfriedSzing auf Twitter
Maybe that’s the reason I haven’t seen FILTER in the wild #voxxedvienna