Ryan is a Solutions Engineer at pganalyze focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA and product manager for more than 20 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.

Ryan is a long-time DBA, starting with MySQL and Postgres in the late 90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He’s at the top of his game when he's learning something new about the data platform or teaching others about the technology he loves.

Presentations

23x

PostgreSQL Hands-On Training Day

A full PostgreSQL training day adjacent to the SCaLE LA event. 6 hours total, running for a full day as a single track (with 90 minute lunch break). Attendees can attend some or all of the event. Aimed both at new Postgres users and those migrating from other db systems. 

See Presentation
23x

PostgreSQL for the Beginner - Hour 1 of Postgres Training Day

Join us to hear about using Postgres for the very first time. 

See Presentation
23x

Getting Started with SQL - Hour 2 of Postgres Training day

From basics to advanced, this course will get you comfortable with SQL functions in Postgres.

See Presentation
23x

Postgres DBA Basics - Hour 3 of Postgres Training Day

This session will review the basic jobs, terminology, and technical details for DBA tasks in Postgres. 

See Presentation
23x

Postgres Troubleshooting - Hour 4 of Postgres Training Day

This session will review essential troubleshooting for Postgres, reviewing how to monitor and log Postgres, using Postgres’ internal catalogs, and common problems and fixes. 

See Presentation
23x

Postgres Configuration and Performance Tuning - Hour 5 of Postgres Training Day

This session will review essential performance tuning and configurations for Postgres.

See Presentation
23x

Postgres Query Tuning - Hour 6 of Postgres Training Day

This session will review essential query performance tuning and for Postgres, an essential skill for developers working with Postgres daily.

See Presentation
21x

Transforming Data with the Power of PostgreSQL and SQL

PostgreSQL has a plethora of features to help developers slice and dice massive amounts of data. In most cases, knowing how to use CTEs, recursive CTEs, and CROSS JOINs can significantly improve your data transformation tasks.

By the end of this session, you will understand how to approach data challenges differently, using the power of PostgreSQL and SQL to work more effectively.

See Presentation
20x

For Your Eyes Only: Roles, Privileges, and Security in PostgreSQL

Security is an essential, yet often misunderstood, part of effectively managing a PostgreSQL cluster. As the popularity and adoption of PostgreSQL continues to grow, the interaction of roles, privileges, and object ownership is a recurring theme of confusion in forums and mailing lists.

In this session we’ll demystify how ownership and permissions work in PostgreSQL so that you can more effectively manage your database landscape.

See Presentation
20x

We All Deserve Arrays: The Undervalued PostgreSQL Superpower

Arrays are an essential part of software development. Among modern databases, however, only PostgreSQL has dedicated datatypes, functions, and indexes built to efficiently work with arrays. In fact, I think arrays are a hidden superpower of PostgreSQL, fully utilized as a data type, usable in pl/pgSQL, and essential for a myriad of built-in functions to process data more efficiently.

Come learn about how powerful and useful arrays can be in your daily PostgreSQL development.

See Presentation