Crossing The Streams: Adding PostgreSQL to Your SQL Server Skillset
summary
Redgate adds PostgreSQL to its toolset and the migration is practical not theoretical: expect demos of spinning up Postgres on AWS RDS and Docker, using Azure Data Studio and DBeaver, storing code on GitHub and deploying with Flyway. Emphasis lands on backups and restores, security, availability and automation; beware versioned docs and mixed-quality community advice. Claim: 78% of companies run multiple databases, so learning Postgres focuses on concrete restores, a few key extensions, and pragmatic DevOps patterns that actually work.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 2:14Why companies use multiple platforms
- 3:42Redgate’s PostgreSQL response
- 5:55PostgreSQL growth drivers
- 7:41PostgreSQL community power
- 9:27PostgreSQL learning tools
- 12:43PostgreSQL docs pitfalls
- 14:51SQL Server transition mistakes
- 16:38Building PostgreSQL skills
- 18:05PostgreSQL security & recovery
- 19:27Redgate’s multi-platform future
related talks
20mManaging the Challenge of Monitoring Growing, Multi-platform Database Estates
52mManaging PostgreSQL changes for the Agile DBA
46mPostgres for the SQL Server DBA
48mDevOps Discovery: Navigating the Database Landscape- 20mManaging the Challenge of Monitoring Growing, Multi-platform Database Estates
01mHighlight from- 48mDevOps Discovery: Navigating the Database Landscape
30mPostgreSQL—more relevant than ever