Conference Talks and Demos

The folders in this repo contain PDFs of presentations and any supporting files that I (hopefully) pointed out during the talk or demonstration. All of these are living folders and will be updated as I give the talks again or learn something new that might be helpful to others on the subject.

Please feel free to connect with me on Twitter (@ryanbooz) to provide any feedback.

---

PostgreSQL related talks (often more recent)

PostgreSQL for the SQL Server DBA

• SQL Data Saturday LA (June 2021)
• DBA Fundamentals Virtual Meetup (August 2021)

Bulk inserts with PostgreSQL

• Postgres Build 2021 (December 2021)
• PGConf.NYC (September 2022)
• FOSDEM 2023 (February 2023)

How to generate (lots) of sample data with PostgreSQL generate_series()

• FOSDEM 2022 (February 2022)

Point-in-time query tuning and observability with pg_stat_statements

• CitusCon 2022 (April 2022)

PostgreSQL Exploits, Oh My! Security best practices with PostgreSQL extensions

• Postgres Vision 2022 (June 2022)

Intro to PostgreSQL: What to know when you're called in to help

• CodeMash 2023 (January 2023)

Database DevOps: Better Database Change Management

• CodeMash 2023 (January 2023)
• Chicago PUG (January 2023)

We All Deserve Arrays: The Hidden Superpower of PostgreSQL

• PGDay LA @ SCaLE20x (March 2023)

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

• PGDay LA @ SCaLE20x (March 2023)
• CitusCon 2023 (April 2023)

Ten Things I Learned Solving Puzzles with PostgreSQL

• Postgres Conference Silicon Valley (April 2023)

SQL Server/Power BI related talks (often older)

The Agile DBA - SQL Server DevOps with SSDT

• GroupBy.org (June 2018)
• Pittsburgh SQL Server User Group (August 2018)
• CodeMash 2019 (Jan 2019)

Service Broker - Async in the DB

• SQL Saturday Philly (May 2017)
• PASS Summit 2018

The Accidental DBA

• SQL Saturday Philly (May 2017)
• SQL Saturday Pittsburgh (Sep 2017)

Power BI Custom Data Connectors

• CodeMash 2019 (Jan 2019)