PostgreSQL

Introducing my new PostgreSQL Quickies Series on YouTube

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

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

Running PostgreSQL with PgBouncer on Mac OS Using Docker Compose

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

Attend my Online Training in November: PostgreSQL for the SQL Server Professional

Are you a seasoned SQL Server professional looking to broaden your horizons and step into the world of PostgreSQL? Do you want to leverage your existing SQL Server expertise while mastering the unique features of PostgreSQL? If so, I’ve got exciting news for you! I’m thrilled to announce that I’m running again my brand-new, two-day …

Attend my Online Training in November: PostgreSQL for the SQL Server Professional + read more

From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences

After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling to a country where everyone speaks a language I mostly understand – but with a different accent and some unfamiliar slang. At first glance, SQL is SQL. But once I started writing real queries in PostgreSQL, I realized that my habits from T-SQL …

From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences + read more