PostgreSQL in a Day

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.