SQLpassion BLOG

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

10/24/2025 / By / Computer Science, Performance Tuning, Uncategorized / Leave a Comment

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

10/20/2025 / By / Performance Tuning / Leave a Comment

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

10/13/2025 / By / PostgreSQL / Leave a Comment

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

From Couch-Potato to Triathlete – and What This Means for Your SQL Server

09/21/2025 / By / SQLServer / Leave a Comment

Do you know if your SQL Server is really running at its best? To help you answer that question, I’ve recently launched a free 30-minute SQL Server Health Check. In this short session, I take a focused look at your system’s “vital signs” and point out the hidden issues that might be slowing you down. It’s …

From Couch-Potato to Triathlete – and What This Means for Your SQL Server + 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.