Dave Stokes

My wife recently discovered a draft horse rescue not too far from our house that was in need of volunteers. Patch's Place takes animals that are too old, too infirm, or have other issues that prevent them from being rehomed elsewhere.

The learning curve for PostgreSQL can be nearly verticle for those caught up in the terminology. So if you find yourself stuck between MIN and CMAX, or have no idea what those things are, then you should be in this talk.

MERGE() is a powerful function for processing data like transaction logs. It is powerful as it allows you to insert, update, or delete data in one statement instead of using an application that requires numerous round trips between the server and the application to do the same tasks (which is much more resource and time intensive).

Almost every organization that I interact with wants a high availability system for PostgreSQL. This clearly depicts an active trend toward an increase in utilizing PostgreSQL for critical business applications.

Adding an index to a table is a popular way to try and speed up queries. But MySQL has several types of indexes and many options. Which is best for your need? Do you need to ignore indexes for hash joins? Can functional indexes help the optimizer plan for a better query? And how do you test an...

Are you an accidental DBA? Suddenly find out that, in addition to your other duties, you have to keep the database humming along too? Well, this is the session for you! In this talk, you'll learn the five things you HAVE TO DO to keep a database happy and healthy. Even if your enterprise needs a...

Percona Monitoring and Management (PMM) is an open source database observability, monitoring, and management tool for MySQL, PostgreSQL, and MongoDB that simplify operations, optimize performance, and improve the security of your database services. This session will cover the installation of...

The new releases of MySQL Server in 2021 had some very interesting changes. This session covers the highlights, the contributions, and changes made during the last year.