Last Thursday I had the chance to attend the PGDay Austria conference, and it turned out to be one of the most inspiring community events I’ve been to in a long time. Not only did I listen to great talks about PostgreSQL internals, I also gave my very first lightning talk – nervously stepping on stage …
PostgreSQL is a powerful, feature-rich database system, but its architecture differs in significant ways from Microsoft SQL Server. One of the most important differences lies in how connections are handled. While SQL Server multiplexes many client requests across worker threads inside a single process, PostgreSQL spawns a dedicated backend process for every client connection. This …
Running PostgreSQL with PgBouncer on Mac OS Using Docker Compose + read more
Microsoft has officially lifted the curtain on SQL Server 2025, and it is shaping up to be one of the most significant releases in years. Rather than just another incremental update, this version brings transformative features around AI, hybrid analytics, performance, and security. In this post, we’ll walk through the highlights of SQL Server 2025 and what …
The Sudden Rise of Generative AI In late 2022, the world witnessed the public release of generative AI systems powerful enough to write essays, produce code, and create art at a level that, until recently, seemed years away. Within months, these tools were in the hands of hundreds of millions of people. The technology’s spread …
The Reckless Race: How Generative AI Could Break Society + read more
750 meters swimming, 25 kilometers cycling, 5 kilometers running. My first sprint-distance triathlon is officially in the books – and what an emotional rollercoaster it’s been. It all happened at the Aloha Tri Traun Triathlon. But to be honest, the lead-up to this day wasn’t promising. Just a few days earlier, during my final bike …
My First Sprint Triathlon: From Doubt to Triumph at Aloha Tri Traun + read more
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
