PostgreSQL

New on YouTube: PostgreSQL Introduction for the SQL Server Professional

12/01/2025 / By / PostgreSQL / Leave a Comment

In November, I delivered a webcast titled “PostgreSQL Introduction for the SQL Server Professional” – a compact introduction to the most important architectural and conceptual differences between SQL Server and PostgreSQL. You can find here now the recorded version of the webcast: What This Webcast Covers This session is designed for SQL Server professionals who …

New on YouTube: PostgreSQL Introduction for the SQL Server Professional + read more

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

11/03/2025 / By / PostgreSQL, SQLServer / 2 Comments

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

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

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

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.