PostgreSQL in a Day

PostgreSQL in a Day

Overview

If you've recently decided to start learning PostgreSQL, or, if you've recently been told you better start learning PostgreSQL, then this se

A One‑Day, Hands‑On Workshop

As organizations accelerate modernization and cloud adoption, PostgreSQL is being onboarded faster than SQL Server is being retired. For many teams, this means one thing: you’re now managing both.

This full‑day, instructor‑led workshop is designed specifically for SQL Server DBAs, architects, and developers who need to get productive with PostgreSQL quickly — without starting from square one.

Using your existing SQL Server knowledge as the foundation, we map concepts, features, and patterns directly to their PostgreSQL equivalents so you can understand what’s the same, what’s different, and what absolutely matters in production.

What You’ll Learn

  • When and why organizations choose PostgreSQL
  • SQL Server vs. PostgreSQL: a common vocabulary
  • Databases, schemas, tables, and objects
  • Roles, privileges, and security models
  • How MVCC really works in Postgres
  • VACUUM, freezing, and transaction IDs
  • Procedural languages (PL/pgSQL) and stored code
  • Running PostgreSQL in the cloud: what changes and what doesn’t
  • Where to find tools, extensions, and community resources

Who Should Attend

  • SQL Server DBAs expanding into PostgreSQL
  • Developers and architects supporting hybrid data platforms
  • Teams involved in cloud migrations or modernization projects
  • Anyone responsible for both SQL Server and Postgres environments

Why Attend?

  • Reduce the learning curve dramatically
  • Understand Postgres in terms you already know
  • Improve cross‑platform confidence and troubleshooting skills
  • Avoid common pitfalls when shifting from SQL Server to PostgreSQL
  • Walk away ready to support real production workloads

If you’re being asked to support PostgreSQL or know you will be soon this workshop gives you the clarity, confidence, and practical understanding to succeed on day one.

About the trainers:

Pat Wright

I have been a DBA for the past 20+ years, I've worked with SQL Server, Postgres and Mysql. Big data Technologies (hadoop,hive,spark). I work with data in every aspect whether reporting/storing or transforming. I also run Utah Geek Events and volunteer to help and build the community whenever I can.


Grant Fritchey

Redgate Software Product Advocate, Microsoft MVP & AWS Community Builder

Grant Fritchey is a Data Platform MVP and AWS Community Builder with over 30 years’ experience in IT, including time spent in support and development. Grant works with multiple data platforms including SQL Server and PostgreSQL as well as multiple cloud platforms. He has also developed in VB, VB.NET, C#, and Java. Grant writes books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product advocate in January 2011.

Good to know

Highlights

  • 8 hours
  • In person
  • Free parking
  • Doors at 8 AM

Refund Policy

Refunds up to 7 days before event

Location

750 Town and Country Blvd

750 Town and Country Boulevard

Houston, TX 77024

How do you want to get there?

Map
Organized by
Report this event

More events from Big Data Utah

Discover more events from Big Data Utah, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all events in Houston and filter by date, category, and more to find the perfect fit.