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 …
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 …
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
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 …
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.
