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.

Juli 2018

PostgreSQL España – Madrid, Spanien – 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.

Gratis Anmeldung auf Meetup.com ⇗

Prag PostgreSQL Meetup – Prag, Tschechische Republik – 2018-07-30 (6pm)

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.

Gratis Anmeldung auf Meetup.com ⇗

August 2018

FrOSCon – Bonn-Rhein-Sieg, Deutschland – 2018-08-25 – 26

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.

Kostenfrei. Zur Konferenz ⇗

In Eigener Sache: 5-tägige SQL-Schulung in Wien

Mitte September führe ich eine 5-tägige SQL-Schulung durch, die dein SQL-foo auf den nächsten Level hebt. Den Inhalt und weitere Details gibt es hier. Noch sind Plätze verfügbar.

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