Ryan Booz's guest appearances

Ryan Booz

GroupBy – Free SQL Server Training

Azure DevOps Podcast

Data on Kubernetes Community

Path To Citus Con

Jonathan Katz

Ryan Gray

David McKay

Dean Lewis

Stephen Bailey

Steve Pousty

Stateful Workloads

Nick Connolly

Jim Walker

Michael Greenberg

Matt Jarvis

Jeremy Tanner

Scott Rigby

Jeff Carpenter

Sylvain Kalache

OwlTail

Grant Fritchey

Everyone learns differently. Grant Fritchey and Ryan Booz, database advocates at Redgate focusing on PostgreSQL, talk with co-hosts Claire Giordano and Pino de Candia to explore the learning resources available to developers and users in all the corners of the PostgreSQL world. What drives you to learn: need or curiosity? What can podcasts teach us while we bike to work? Are conference talks good for growing skills, or are they better for networking? What about books? And do older books still have much to offer? It turns out, most people need much more than one approach to build their knowledge. Some of the (many) links shared in the order they were mentioned:  Talk: Ryan’s talk Point-in-time query tuning and observability with pg_stat_statements at Citus Con: An Event for Postgres 2022 Blog: Learning PostgreSQL with Grant, a series for SQL Server devs learning about Postgres   Podcast: postgres.fm, a weekly podcast about all things Postgres  Podcast: Path To Citus Con Episode 01: Working in public on open source  Blog aggregator: Planet PostgreSQL  Email Newsletters: Cooperpress, including the Postgres Weekly email  Podcast: Scaling PostgreSQL with Creston Jamison  User Groups: PostgreSQL Community User Groups  Videos: pganalyze "5 minutes of Postgres," by Lukas Fittl  Book: The Art of PostgreSQL, by Dimitri Fontaine  Book: PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta Dombrovskaya  Book: SQL Performance Explained, by Markus Winand  Blog: Modern SQL, by Markus Winand  Blog: Use The Index, Luke, by Markus Winand  Book: Database Administration, by Craig Mullins  Book: A Curious Moon, by Rob Conery  Book: The Little SQL Book, by Rob Conery, “Learn SQL While Watching Football This Weekend - Free!”  Event: PGDay Chicago  Blog: Redgate – Simple Talk  Videos: CMU Database Group’s Talks on YouTube: Quarantine (2020), First Dose (2021), Second Dose (2021),  Booster (2022)   Crunchy Data’s Postgres Playground  Blog: CYBERTEC  Blog: Citus Open Source Blog   Talk: How To Make Your Postgres Blog Posts Reach A Ton More People, by Claire Giordano  Conference: PGCon 2023, super useful to watch recorded talks after the fact  Conference: PGConf.EU, 2022, good example of an in-person event with lots of opportunities for learning  Conference: Citus Con: An Event for Postgres 2023  Conference: PGConf NYC 2023  Blog Series: PGSQL Phriday, created by Ryan Booz  Blog Series: PostgreSQL Person of the Week, by Andreas Scherbaum   Blog: Robert Haas' blog  Blog: select * from depesz;  Book: PostgreSQL 14 internals, by Egor Rogov  

Everyone learns differently. <a href="https://twitter.com/GFritchey" rel="nofollow" target="_blank">Grant Fritchey</a> and <a href="https://twitter.com/ryanbooz" rel="nofollow" target="_blank">Ryan Booz</a>, database advocates at Redgate focusing on PostgreSQL, talk with co-hosts <a href="https://hachyderm.io/@clairegiordano" rel="nofollow" target="_blank">Claire Giordano</a> and <a href="https://www.linkedin.com/in/pinodecandia/" rel="nofollow" target="_blank">Pino de Candia</a> to explore the learning resources available to developers and users in all the corners of the PostgreSQL world. What drives you to learn: need or curiosity? What can podcasts teach us while we bike to work? Are conference talks good for growing skills, or are they better for networking? What about books? And do older books still have much to offer? It turns out, most people need much more than one approach to build their knowledge.  Some of the (many) links shared in the order they were mentioned: <ul> <li>Talk: Ryan’s talk <a href="https://www.youtube.com/watch?v=wTmKGyiqoCk&amp;list=PLlrxD0HtieHjSzUZYCMvqffEU5jykfPTd&amp;index=34&amp;pp=iAQB" rel="nofollow" target="_blank">Point-in-time query tuning and observability with pg_stat_statements</a> at Citus Con: An Event for Postgres 2022</li> <li>Blog: <a href="https://www.red-gate.com/simple-talk/databases/postgresql/manipulating-data-in-postgresql-learning-postgresql-with-grant/" rel="nofollow" target="_blank">Learning PostgreSQL with Grant</a>, a series for SQL Server devs learning about Postgres  </li> <li>Podcast: <a href="http://postgres.fm/" rel="nofollow" target="_blank">postgres.fm, a weekly podcast about all things Postgres</a> </li> <li>Podcast: <a href="https://pathtocituscon.transistor.fm/episodes/working-in-public-on-open-source" rel="nofollow" target="_blank">Path To Citus Con Episode 01: Working in public on open source</a> </li> <li>Blog aggregator: <a href="https://planet.postgresql.org/" rel="nofollow" target="_blank">Planet PostgreSQL</a> </li> <li>Email Newsletters: <a href="https://cooperpress.com/publications/" rel="nofollow" target="_blank">Cooperpress, including the Postgres Weekly email</a> </li> <li>Podcast: <a href="https://www.scalingpostgres.com/" rel="nofollow" target="_blank">Scaling PostgreSQL with Creston Jamison</a> </li> <li>User Groups: <a href="https://www.postgresql.org/community/user-groups/" rel="nofollow" target="_blank">PostgreSQL Community User Groups</a> </li> <li>Videos: <a href="https://www.youtube.com/playlist?list=PLhqxwIAgz78HZhWyu3UyKrCWNk7VWjVpj" rel="nofollow" target="_blank">pganalyze "5 minutes of Postgres," by Lukas Fittl</a> </li> <li>Book: <a href="https://theartofpostgresql.com/" rel="nofollow" target="_blank">The Art of PostgreSQL, by Dimitri Fontaine</a> </li> <li>Book: <a href="https://www.amazon.com/PostgreSQL-Query-Optimization-Ultimate-Efficient/dp/1484268849" rel="nofollow" target="_blank">PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta Dombrovskaya</a> </li> <li>Book: <a href="https://www.amazon.com/Performance-Explained-Everything-Developers-about/dp/3950307826" rel="nofollow" target="_blank">SQL Performance Explained, by Markus Winand</a> </li> <li>Blog: <a href="https://modern-sql.com/" rel="nofollow" target="_blank">Modern SQL, by Markus Winand</a> </li> <li>Blog: <a href="https://use-the-index-luke.com/" rel="nofollow" target="_blank">Use The Index, Luke, by Markus Winand</a> </li> <li>Book: <a href="https://www.amazon.com/Database-Administration-Complete-Practices-Procedures-ebook/dp/B009PM38TE" rel="nofollow" target="_blank">Database Administration, by Craig Mullins</a> </li> <li>Book: <a href="https://bigmachine.io/products/a-curious-moon/" rel="nofollow" target="_blank">A Curious Moon, by Rob Conery</a> </li> <li>Book: <a href="https://bigmachine.io/little-sql-book/" rel="nofollow" target="_blank">The Little SQL Book, by Rob Conery</a>, “Learn SQL While Watching Football This Weekend - Free!” </li> <li>Event: <a href="https://2023.pgdaychicago.org/" rel="nofollow" target="_blank">PGDay Chicago</a> </li> <li>Blog: <a href="https://www.red-gate.com/simple-talk/" rel="nofollow" target="_blank">Redgate – Simple Talk</a> </li> <li>Videos: CMU Database Group’s Talks on YouTube: <a href="https://www.youtube.com/watch?v=PFUZlNQIndo&amp;list=PLSE8ODhjZXjagqlf1NxuBQwaMkrHXi-iz" rel="nofollow" target="_blank">Quarantine (2020)</a>, <a href="https://www.youtube.com/watch?v=TAdiilOOvNI&amp;list=PLSE8ODhjZXjbeqnfuvp30VrI7VXiFuOXS" rel="nofollow" target="_blank">First Dose (2021)</a>, <a href="https://www.youtube.com/watch?v=JLlIAWjvHxM&amp;list=PLSE8ODhjZXjbDOFN4U4-Uv95-N8sgzs5D" rel="nofollow" target="_blank">Second Dose (2021)</a>,  <a href="https://www.youtube.com/watch?v=spYEOcFZz2I&amp;list=PLSE8ODhjZXjZdLET4InoSZ3App6WSQHXE" rel="nofollow" target="_blank">Booster (2022)</a> </li> <li> <a href="https://www.crunchydata.com/developers/playground" rel="nofollow" target="_blank">Crunchy Data’s Postgres Playground</a> </li> <li>Blog: <a href="https://www.cybertec-postgresql.com/en/blog/" rel="nofollow" target="_blank">CYBERTEC</a> </li> <li>Blog: <a href="https://www.citusdata.com/blog/" rel="nofollow" target="_blank">Citus Open Source Blog </a> </li> <li>Talk: <a href="https://speakerdeck.com/clairegiordano/how-to-make-your-postgres-blog-posts-reach-a-ton-more-people-claire-giordano-pgconf-eu-2022" rel="nofollow" target="_blank">How To Make Your Postgres Blog Posts Reach A Ton More People, by Claire Giordano</a> </li> <li>Conference: <a href="https://www.pgcon.org/2023/" rel="nofollow" target="_blank">PGCon 2023</a>, super useful to watch recorded talks after the fact </li> <li>Conference:<a href="https://2022.pgconf.eu/" rel="nofollow" target="_blank"> PGConf.EU, 2022</a>, good example of an in-person event with lots of opportunities for learning </li> <li>Conference: <a href="https://aka.ms/cituscon-playlist" rel="nofollow" target="_blank">Citus Con: An Event for Postgres 2023</a> </li> <li>Conference: <a href="https://2023.pgconf.nyc/" rel="nofollow" target="_blank">PGConf NYC 2023</a> </li> <li>Blog Series: <a href="https://www.pgsqlphriday.com/%20" rel="nofollow" target="_blank">PGSQL Phriday</a><a href="https://www.pgsqlphriday.com/" rel="nofollow" target="_blank">, created by Ryan Booz</a> </li> <li>Blog Series: <a href="https://postgresql.life/" rel="nofollow" target="_blank">PostgreSQL Person of the Week, by Andreas Scherbaum </a> </li> <li>Blog: <a href="http://rhaas.blogspot.com/" rel="nofollow" target="_blank">Robert Haas' blog</a> </li> <li>Blog: <a href="https://www.depesz.com/" rel="nofollow" target="_blank">select * from depesz;</a> </li> <li>Book: <a href="https://edu.postgrespro.com/postgresql_internals-14_en.pdf" rel="nofollow" target="_blank">PostgreSQL 14 internals, by Egor Rogov</a> </li> </ul>

My favorite ways to learn more about PostgreSQL with Grant Fritchey & Ryan Booz

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.   Topics of Discussion: [1:23] Ryan’s background and his love of helping people with their data. [6:06] What are some features of Postgres that really intrigued Ryan? [6:12] What are some of the choices in the database world that people should be well versed in? [11:00] Is there a marketplace for these extensions? [15:00] Google, Amazon, Microsoft, and many others have been very interested over the last 3‒4 years in the open-source code base. [15:50] Is there any environment or platform where Postgres can’t run? [17:24] Can we use a downsized database engine? [19:19] Ryan discusses Amazon Redshift. [23:58] What’s the state of the modern Redgate tools? [26:42] What are the top three tools developers should reach for? [27:00] What are the features of Flyway?   Mentioned in this Episode: Clear Measure Way Architect Forum Software Engineer Forum Programming with Palermo — New Video Podcast! Email us at programming@palermo.network Clear Measure, Inc. (Sponsor)  .NET DevOps for Azure: A Developer’s Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon!  Jeffrey Palermo’s Twitter — Follow to stay informed about future events! Architect Tips — Video podcast!  Azure DevOps Ryan Booz Ryan on Sessionize Flyway   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

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. Topics of Discussion: [1:23] Ryan’s background and his love of helping people with their data. [6:06] What are some features of Postgres that really intrigued Ryan? [6:12] What are some of the choices in the database world that people should be well versed in? [11:00] Is there a marketplace for these extensions? [15:00] Google, Amazon, Microsoft, and many others have been very interested over the last 3‒4 years in the open-source code base. [15:50] Is there any environment or platform where Postgres can’t run? [17:24] Can we use a downsized database engine? [19:19] Ryan discusses Amazon Redshift. [23:58] What’s the state of the modern Redgate tools? [26:42] What are the top three tools developers should reach for? [27:00] What are the features of Flyway? Mentioned in this Episode: <a href="https://clearmeasure.com/clear-measure-way/" rel="nofollow" target="_blank">Clear Measure Way</a> <a href="https://clearmeasure.com/architect-forum/" rel="nofollow" target="_blank">Architect Forum</a> <a href="https://clearmeasure.com/software-engineer-forum/" rel="nofollow" target="_blank">Software Engineer Forum</a> <a href="https://palermo.network/programming-with-palermo" rel="nofollow" target="_blank">Programming with Palermo</a> — New Video Podcast! Email us at <a href="mailto:programming@palermo.net">programming@palermo.net</a>work <a href="http://clearmeasure.com/" rel="nofollow" target="_blank">Clear Measure, Inc.</a> (Sponsor) <a href="https://www.amazon.com/NET-DevOps-Azure-Developers-Architecture/dp/1484253426" rel="nofollow" target="_blank"> .NET DevOps for Azure: A Developer’s Guide to DevOps Architecture the Right Way, by Jeffrey Palermo</a> — Available on Amazon! <a href="https://twitter.com/jeffreypalermo?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor" rel="nofollow" target="_blank"> Jeffrey Palermo’s Twitter</a> — Follow to stay informed about future events! <a href="http://architecttips.clearmeasure.com/" rel="nofollow" target="_blank">Architect Tips</a> — Video podcast! <a href="https://azure.microsoft.com/en-ca/services/devops/?&amp;OCID=AID736756_SEM_7eul5uID" rel="nofollow" target="_blank"> Azure DevOps</a> <a href="https://www.linkedin.com/in/ryanbooz/" rel="nofollow" target="_blank">Ryan Booz</a> <a href="https://sessionize.com/ryan-booz" rel="nofollow" target="_blank">Ryan on Sessionize</a> <a href="https://www.red-gate.com/products/flyway/" rel="nofollow" target="_blank">Flyway</a> Want to Learn More? Visit <a href="http://azuredevopspodcast.clear-measure.com/" rel="nofollow" target="_blank">AzureDevOps.Show</a> for show notes and additional episodes.

Ryan Booz- Modern Databases - Episode 245

https://go.dok.community/slack https://dok.community/ ABSTRACT OF THE TALK What's the deal with Postgres in Kubernetes? To get some answers as well as more questions, we're bringing together Álvaro Hernandez from Ongres, Ryan Booz from Timescale, and Gabriele Bartolini from EDB for an "Ask Us Anything" session. Send us your questions on Slack!

<a href="https://go.dok.community/slack" rel="nofollow" target="_blank">https://go.dok.community/slack</a> <a href="https://dok.community/" rel="nofollow" target="_blank">https://dok.community/</a> ABSTRACT OF THE TALK What's the deal with Postgres in Kubernetes? To get some answers as well as more questions, we're bringing together Álvaro Hernandez from Ongres, Ryan Booz from Timescale, and Gabriele Bartolini from EDB for an "Ask Us Anything" session. Send us your questions on Slack!

Dok Specials - Ask Us Anything About Postgres // Gabriele Bartolini, Ryan Booz & Álvaro Hernández