Ryan Booz
Developer Advocate at Redgate
State College, Pennsylvania, United States
Actions
Ryan is an Advocate at Redgate 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.
Awards
Area of Expertise
Topics
PostgreSQL Query Optimizations and Where to Find Them: A Beginners Guide
Creating fast, efficient queries and applications requires effort. Despite ongoing improvements in hardware, query planning, data storage, and AI, users care about one thing above all—how quickly queries respond. Even in 2024, improving problematic queries often requires human expertise. When called upon to help, knowing where to begin and which tools to reach for first is crucial.
In this session, we'll explore the beginner's toolbox of primary settings, indexes, tools, features, and SQL tips. Starting with EXPLAIN plans, we'll cover ad hoc settings for query improvement, indexing strategies, partitioning, and essential SQL techniques. You'll leave with practical ideas to tackle unexpected issues in your day-to-day PostgreSQL application management.
Mastering PostgreSQL Partitioning - Part 2: Advanced Questions and Demos
PostgreSQL partitioning continues to gain popularity and adoption. While many users understand the basics of creating partitions, they often seek practical guidance about their pros and cons, ideal use cases, and potential pitfalls.
In this follow-up session to "Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance," we'll explore partitioning strategies for different data types, examine maintenance tools like pg_partman, address default partition challenges, investigate how partitioning affects query planning and execution, review recent PostgreSQL improvements, and discuss methods for managing partition growth over time.
Partitioning is one of PostgreSQL's greatest strengths. Come learn how to use and manage it more effectively.
Getting Started with Flyway Community: Managing Databases as Code
Flyway is a popular open-source tool for managing schema migrations throughout your database and application lifecycle. While getting started with Flyway can be challenging—especially with an existing database and when managed migrations are a new concept—this session will help you succeed.
In this session, I’ll introduce the free Flyway Desktop client, Database DevOps concepts, including using CI/CD pipelines for database deployments, and integrating Flyway into your development workflow. You'll learn about branching strategies, handling out-of-order migrations, using the community portal to track pipeline and database drift, and more.
By the end of this session, you'll be ready to implement Flyway in your existing database projects, manage ongoing migrations, and set up automated database deployments that are both safe and predictable.
1 Billion Row Challenge: Comparing Postgres, DuckDB, and Extensions
In late 2023, the Java community started a challenge to find the most efficient way to process a file with 1 billion rows of data. Unsurprisingly, many database communities quickly took on the same challenge with varying results. Postgres, in many cases, performed the worst without close attention to settings and efficient resource utilization. But, with a little more effort, could it compete head-to-head?
In this session, we’ll look at the original challenge and how to approach it with vanilla Postgres beyond the basics. Next, we’ll explore how the increasingly popular in-memory analytics database, DuckDB, handles the same challenge. Finally, we’ll explore recent opportunities to integrate the two databases together to provide a powerful analytical engine with Postgres for the best of both worlds.
Transforming Data with the Power of PostgreSQL and SQL
With the power of PostgreSQL, modern data transformation can happen inside the database rather than with external tools. This is known as the extract, load, and transform (ELT) pattern using built-in functions and SQL features to work with data regardless of the form. Once the data is loaded, knowing how to utilize Common Table Expressions (CTEs), recursive CTEs, and CROSS JOINs can significantly improve your data transformation tasks.
In this session, I’ll explain and demonstrate how each of these features can be used together to build powerful queries that utilize additional PostgreSQL features and functions. Transforming JSON, text, and even emoji into sources of data-driven insights.
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.
PostgreSQL Introduction for the SQL Server Developer or DBA
PostgreSQL is one of the fastest growing databases in the world. Every major cloud provider has one-click installations or full-blown serverless options that support PostgreSQL. With open source licensing and time-tested stability, there’s a reason many businesses are using PostgreSQL for new projects, while at the same time, analyzing the ROI of converting existing applications. In fact, Amazon Web Services released Bablefish in 2021, an extension that allows SQL Server applications to transparently use PostgreSQL.
All of this adds up to the increased likelihood that you will be asked to develop an application using PostgreSQL in the next few years.
In this pre-conference session, I’ll introduce you to PostgreSQL from the perspective of a former SQL Server developer that struggled through the transition. I’ll help you make the most of what you already know as a SQL Server user and teach you how to navigate the differences successfully.
In this session we’ll cover:
- An introduction to PostgreSQL, including some of the high-level differences from SQL Server
- Installation
- Tools for connecting and running queries
- Configuration
- A deep-dive on SQL through hands-on exercises
- Adding functionality through extensions
- Indexing
- Query tuning
- Stored procedures
- Functions and triggers
- Community
Learning a new database technology doesn’t have to be scary. By the end of this pre-conference workshop, you’ll have the knowledge and confidence to use your database skills in a new way. Whether at work or with a new hobby project, you’ll be ready to dive in and lead the team when PostgreSQL is the database being used.
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, I’ll start by defining the Principle of Least Privileges and how this philosophy influences roles and privileges in PostgreSQL. Next, I’ll demonstrate the importance of object ownership in PostgreSQL, how group and user roles can work in unison to effectively manage permissions, multiple ways to manage default privileges, and which privileges should always be modified in any new PostgreSQL database. Finally, I’ll discuss how recent releases are laying a foundation for more flexible and robust security management in the years ahead.
By the end of this session, you will understand how roles work in PostgreSQL, how they impact your daily work, and how to effectively communicate security best practices with others on your team. You’ll leave with a solid information to start creating roles that effectively manage access to your cluster and data.
Intro to PostgreSQL: What to Know When You're Called In To Help!
PostgreSQL has risen to be the dominant choice for new projects and cost-saving migrations in an increasingly cloud-first, price-conscious world. Additionally, all three major cloud providers have invested heavily in PostgreSQL and their own forks, signaling a continued shift in the DBMS market. This increases the likelihood that you will be asked to manage an alternative RDBMS like PostgreSQL in the next 3-5 years.
In this session, I'll briefly introduce the history of PostgreSQL and what has allowed it to shine in this modern age. Next, we'll look at 10 areas of PostgreSQL including community, tooling, configuration, data types, and SQL differences. As a former SQL Server developer, I'll demonstrate how to transfer the knowledge you already have to how PostgreSQL works so that you can succeed faster on your next project.
By the end of the session, you will have enough information to connect to PostgreSQL with free tooling, modify common SQL to run correctly, get information about the state of the database, and help with basic query tuning.
Database DevOps: Options for database change management
Whether you are the DBA for an Agile, Sprint-based team, or a developer with DBA responsibilities, you may feel like the development bottleneck at every turn. Managing migrations with your ORM of choice is easy but often error-prone and hard to manage as the project grows. Or worse yet, maybe your schema and change management is a folder full of poorly commented SQL scripts saved to a shared folder or local drive.
Surely there's a better, SQL-centric way to manage databases as code, validate changes, and deploy updates - right? Yes, there is!
This talk will explore what database DevOps is and how open-source and paid tools like Flyway can help you manage database schema and code changes while incorporating agile CI/CD practices.
By the end of the session, you'll be ready to tame your rogue application databases, managing changes and migrations with ease, and become the envy of the development team.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top