Bild von Markus Winand

Konferenzen bieten eine enorme Themenvielfalt.

Da darf SQL auch nicht fehlen.

Markus Winand spricht auf Konferenzen

Die folgenden Konferenzen haben die Vorträge von Markus Winand bereits bestätigt.

Mai 2018

PgCon.org – Ottawa, Kanada – 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.

Vor der eigentlichen Konferenz finden Tutorials und eine Unconference statt. Teilnahmegebühr CAD 45,— – 195,—. PgCon.org ⇗

Juni 2018

AOUG Anwenderkonferenz – Wien, Österreich – 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.

Teilnahmegebühr von € 103 (Frühbucherpreis für AUOG Mitglieder) bis € 205 (Vollpreis). Zur Konferenz ⇗

Juli 2018

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.

Teilnahmegebühr £149. Zur Konferenz ⇗

Prag PostgreSQL Meetup – Prag, Tschechische Republik – 2018-07-30

Details werden noch bekannt gegeben.

September 2018

JavaZone – Oslo, Norwegen – 2018-09-12 – 2018-09-13

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!

Tickets ab NOK 6.590,— zzgl. USt. (2 Tage Konferenz, 1 Tag Workshops auf „solange Platz ist“-Basis). Zur Konferenz ⇗

BASTA! – Mainz, Deutschland – 2018-09-25 - 2018-09-27

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!

Tickets ab € 440,— (ein Tage, frühbucher bis 3. Mai) bis € 2349,— (5-Tage, Vollpreis). Mein Vortrag.

DevConf 2018 – Krakau, Polen – 2018-09-26 - 2018-09-28

Modernes SQL: Evolution eines Dinosauriers

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!

Tickets ab PLN 499,— bis PLN 899,—. Zur Konferenz ⇗

Mit Markus Winand verbinden

Markus Winand auf LinkedInMarkus Winand auf XINGMarkus Winand auf Twitter