PASS logo

November 15-18

Seattle & online

2021 Summit video library

PostgreSQL for the SQL Server DBA: What to Know When You’re Called In To Help!

Ryan Booz

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.