SQLpassion BLOG

How SQL Server Professionals Can Master PostgreSQL – Without Wasting Months on Trial & Error

Over the past few years, I’ve noticed a major shift in the database world. More and more companies are moving away from Microsoft SQL Server and embracing PostgreSQL. At first, I didn’t think much of it. After all, SQL Server had been my professional home for decades. But then, one project after another started involving …

How SQL Server Professionals Can Master PostgreSQL – Without Wasting Months on Trial & Error + read more

SQL Server 2025 Unleashed Live Training – A New Era Begins

I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on December 10, 2025 – a deep-dive day dedicated to exploring the next generation of Microsoft’s flagship database platform. For more than 25 years, I’ve been helping companies around the world get the most performance, scalability, and reliability out of SQL Server. …

SQL Server 2025 Unleashed Live Training – A New Era Begins + read more

Why I Avoid SMR Drives – and What the New Western Digital Warnings Reveal

Over the years, I’ve learned that high performance doesn’t just happen – neither in life nor in databases. When I transformed myself from an 85 kg couch potato into a 65 kg triathlete, I realized the same principle applies everywhere: performance is the result of conscious choices, discipline, and understanding what really goes on under …

Why I Avoid SMR Drives – and What the New Western Digital Warnings Reveal + read more

Bringing 10 Gbit to my Client Devices in my Home Office

For years, my home network has been running on a simple 1 Gbit setup based on Ubiquiti hardware (Router, Rack Switches, Edge Switches, WIFI Access Points). It connects everything in our house – from my Windows and Linux workstation, my MacBook Air, and all our WIFI clients. It’s stable, efficient, and perfectly adequate for everyday …

Bringing 10 Gbit to my Client Devices in my Home Office + read more

Understanding Upstream vs. Downstream PostgreSQL

When you install PostgreSQL on a Raspberry Pi or on your favorite Linux distribution, the very first surprise often comes right after the installation finishes: the configuration files are not where the official documentation says they should be. Instead of finding postgresql.conf inside the data directory, you discover that Debian places it under /etc/postgresql/<version>/<cluster>/. To make sense of …

Understanding Upstream vs. Downstream PostgreSQL + read more