SQL Server is a leading enterprise database solution for good reason. However, it’s not the only popular RDBMS used in an increasingly cloud-first, price conscious world.
PostgreSQL is arguably becoming one of the most used alternatives today, and in 2021 all three major cloud platforms have one-click deployments for spinning up new instances. All of this adds up to the increased likelihood that you will be asked to manage an alternative RDBMS like PostgreSQL in the next 3-5 years.
In this session we’ll look at 10 areas of PostgreSQL through the lens of a SQL Server DBA to familiarize yourself with the main differences between the two platforms.
By the end of the session you will have enough information to connect to PostgreSQL with free tooling, modify common T-SQL to run correctly, get information about the state of the database, and help with basic query tuning.
Ryan Booz, Developer Advocate at Timescale
Ryan is a Developer Advocate at Timescale, the supercharged time-series database built on PostgreSQL Prior to Timescale, Ryan worked for more than 17 years as a developer, DBA and product manager in multiple ISVs delivering SaaS products based on time-series data.
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 and the #SQLFamily and has a desire to bring some of that community spirit into the growing PostgreSQL world. 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.
Sadly, the recording of this presentation did not work as well as expected. The slides, on the other hand, we were able to salvage!