SQLpassion BLOG

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

Introducing my new PostgreSQL Quickies Series on YouTube

09/15/2025 / By / PostgreSQL, PostgreSQL Quickies / Leave a Comment

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

Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL

09/08/2025 / By / PostgreSQL, SQLServer / Leave a Comment

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 …

Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL + 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.