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
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 …
PostgreSQL is a powerful, feature-rich database system, but its architecture differs in significant ways from Microsoft SQL Server. One of the most important differences lies in how connections are handled. While SQL Server multiplexes many client requests across worker threads inside a single process, PostgreSQL spawns a dedicated backend process for every client connection. This …
Running PostgreSQL with PgBouncer on Mac OS Using Docker Compose + 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.
