SQLpassion BLOG

Running PostgreSQL with PgBouncer on Mac OS Using Docker Compose

09/01/2025 / By / PostgreSQL / Leave a Comment

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

What’s New in SQL Server 2025

08/25/2025 / By / SQL Server / 2 Comments

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 …

What’s New in SQL Server 2025 + read more

The Reckless Race: How Generative AI Could Break Society

08/08/2025 / By / Artificial Intelligence / 2 Comments

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

My First Sprint Triathlon: From Doubt to Triumph at Aloha Tri Traun

08/04/2025 / By / Triathlon / Leave a Comment

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

The Best of Both Worlds: How I Built My Ideal Dual-Boot System with Ubuntu 24.04 and Windows 11

07/28/2025 / By / Linux / 3 Comments

For several years of my professional life, I’ve lived between worlds – Linux for development, Windows for daily comfort and gaming, and macOS when the polish and ecosystem just made things feel… nice. But I’ve always felt like I was cheating on one platform with another. No single environment ever gave me the full stack …

The Best of Both Worlds: How I Built My Ideal Dual-Boot System with Ubuntu 24.04 and Windows 11 + read more

SQLpassion Performance Tuning Training Plan – Signup

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.