PASS logo

November 14-17

In person. In Seattle

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.

Get updates

Sign up to get the latest conference information, announcements and price bump reminders direct to your inbox.

Redgate will only contact you about PASS Data Community Summit and SQL Saturday, unless you separately request emails about Redgate.