Learning PostgreSQL as a SQL Server User
2025TL; DR
Pick up the tools, tips and tricks you need to learn PostgreSQL.
Session Details
More and more organizations are hosting their data on multiple platforms. One of the fastest growing relational platforms is PostgreSQL. While the root behaviors of tables and relationships between them are the same, there remains a very distinct set of differences between PostgreSQL and other platforms.
If you've been a SQL Server user, developer, DBA, and your organization is now adding PostgreSQL to the mix, you may have a somewhat steep learning curve ahead. This session is meant to reduce the size of that hill you're going to climb as you add PostgreSQL skills. We'll cover the common aspects of both platforms, the subtle differences between the two, and, of course, some of the unique behaviors to separates PostgreSQL from SQL Server. You'll get a good introduction to the core behaviors of PostgreSQL and the appropriate language to use when working with that data platform. All of this is designed to flatten out that learning curve and get you started supporting PostgreSQL just as well as you currently support SQL Server.
If you've been a SQL Server user, developer, DBA, and your organization is now adding PostgreSQL to the mix, you may have a somewhat steep learning curve ahead. This session is meant to reduce the size of that hill you're going to climb as you add PostgreSQL skills. We'll cover the common aspects of both platforms, the subtle differences between the two, and, of course, some of the unique behaviors to separates PostgreSQL from SQL Server. You'll get a good introduction to the core behaviors of PostgreSQL and the appropriate language to use when working with that data platform. All of this is designed to flatten out that learning curve and get you started supporting PostgreSQL just as well as you currently support SQL Server.
3 things you'll get out of this session
Understand the differences between SQL Server and PostgreSQL.
Learn about the tools available to help you with PostgreSQL.
Discover the learning resources available to you as you continue your PostgreSQL journey.
Speakers
Grant Fritchey's other proposed sessions for 2026
Aren’t we all tired of AI? - 2026
Inside SQL Server 2025 Part 1 - 2026
Inside SQL Server 2025 Part 2 - 2026
Intelligent Query Processing: From Insight to Impact - 2026
Query Performance Enhancements in SQL Server 2025 - 2026
Grant Fritchey's previous sessions
Managing the Challenge of Monitoring Growing, Multi-platform Database Estates
Our session will present best practices and real-world examples for monitoring in multi-platform environments.
The New Database Landscape - Revealing Shifts and Charting the Next Horizon
From personal journeys between database platforms, to insights from Redgate's customer base, and findings from our 2024 State of the Database Landscape report, in this session you'll hear a variety of viewpoints about the evolving world of databases.