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
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
Just a few weeks ago I published a blog posting about the new features of SQL Server 2025, exploring where Microsoft is taking its flagship database engine. Today, I want to continue in the same spirit – but this time from the PostgreSQL side of the world. PostgreSQL 18 was released just last week, and …
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
For many years I have been publishing my SQL Server Quickies – short, focused videos that explain specific database topics in just a few minutes. These quick sessions have helped countless developers and DBAs to sharpen their skills without the need to spend hours in front of lengthy tutorials. Now it’s time to expand this concept into …
Introducing my new PostgreSQL Quickies Series on YouTube + 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.
