Azure & DevOps Podcast Ryan Booz: The State of the Database in 2025 - Episode 333
Jan 20, 2025
Ryan Booz, a PostgreSQL advocate with over 20 years of experience, dives into the evolution of databases. He discusses the crucial role of generalist developers in 2025 and the challenges of integrating different databases. The conversation touches on the future of Microsoft Fabric and how .NET developers can effectively transition to Postgres. Insights into migrating from SQL Server, the innovative edge of Postgres, and the significance of vector databases and indexing also make for a captivating listen.
AI Snips
Chapters
Books
Transcript
Episode notes
Codemash Trace Flag
- Ryan Booz attended a Codemash session on SQL Server.
- The speaker mentioned trace flag 2371, which increased statistics calculation frequency, solving a problem Ryan had with time-series data.
Unexpected Postgres
- Ryan Booz took a job expecting to work with big data on the Microsoft platform.
- The company switched to Postgres, leading him to rediscover his passion for it and the database community.
Database Specialists
- While everyone wants their database to work, deep specialists are crucial.
- Database technology has nuances requiring specialized knowledge beyond basic SQL and queries.