[Blog] Introducing My Brand-New Online Training: PostgreSQL for the SQL Server Professional www.sqlpassion.at/archive/2025... #sqlserver #postgres #PostgreSQL #sqlpassion
Introducing My Brand-New Online Training: PostgreSQL for the SQL Server Professional! – SQLpassion
www.sqlpassion.at
January 8, 2025 at 12:38 PM
[Blog] Introducing My Brand-New Online Training: PostgreSQL for the SQL Server Professional www.sqlpassion.at/archive/2025... #sqlserver #postgres #PostgreSQL #sqlpassion
[Blog] GIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #postgres #PostgreSQL
GIN Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
January 12, 2026 at 12:57 PM
[Blog] GIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #postgres #PostgreSQL
[Blog] Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlserver
Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server – SQLpassion
www.sqlpassion.at
February 10, 2025 at 1:47 PM
[Blog] Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlserver
[Blog] Online Recording: Exploring PostgreSQL for SQL Server Developers and DBAs: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlserver #sqlpassion
Online Recording: Exploring PostgreSQL for SQL Server Developers and DBAs – SQLpassion
www.sqlpassion.at
January 20, 2025 at 11:05 AM
[Blog] Online Recording: Exploring PostgreSQL for SQL Server Developers and DBAs: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlserver #sqlpassion
[Blog] BRIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #performance #PostgreSQL #postgres
BRIN Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
January 19, 2026 at 10:21 AM
[Blog] BRIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #performance #PostgreSQL #postgres
🚀 New GitHub repo: #PostgreSQL streaming replication in Docker Compose.
✅ Works on macOS, Linux, Windows 11 - even on a Raspberry Pi 5.
Next up: Patroni + HAProxy, PgBouncer integration.
💬 Feedback & ideas welcome!
👉 github.com/SQLpassion/p...
✅ Works on macOS, Linux, Windows 11 - even on a Raspberry Pi 5.
Next up: Patroni + HAProxy, PgBouncer integration.
💬 Feedback & ideas welcome!
👉 github.com/SQLpassion/p...
GitHub - SQLpassion/pg-hadr: This repository demonstrates HA/DR concepts with PostgreSQL
This repository demonstrates HA/DR concepts with PostgreSQL - SQLpassion/pg-hadr
github.com
September 9, 2025 at 2:39 PM
🚀 New GitHub repo: #PostgreSQL streaming replication in Docker Compose.
✅ Works on macOS, Linux, Windows 11 - even on a Raspberry Pi 5.
Next up: Patroni + HAProxy, PgBouncer integration.
💬 Feedback & ideas welcome!
👉 github.com/SQLpassion/p...
✅ Works on macOS, Linux, Windows 11 - even on a Raspberry Pi 5.
Next up: Patroni + HAProxy, PgBouncer integration.
💬 Feedback & ideas welcome!
👉 github.com/SQLpassion/p...
Myth: “SQL Server is slow? Let’s buy bigger hardware.”
❌ Wrong.
Bad indexes remain bad indexes.
Like in triathlon: you can’t replace training with a new bike. 🚴
👉 Free SQL Server Health Check: www.sqlpassion.at/free-sql-ser...
#sqlserver #sqlpassion #healthcheck #performance
❌ Wrong.
Bad indexes remain bad indexes.
Like in triathlon: you can’t replace training with a new bike. 🚴
👉 Free SQL Server Health Check: www.sqlpassion.at/free-sql-ser...
#sqlserver #sqlpassion #healthcheck #performance
Free 30‑Minute SQL Server Health Check – SQLpassion
www.sqlpassion.at
September 23, 2025 at 12:18 PM
Myth: “SQL Server is slow? Let’s buy bigger hardware.”
❌ Wrong.
Bad indexes remain bad indexes.
Like in triathlon: you can’t replace training with a new bike. 🚴
👉 Free SQL Server Health Check: www.sqlpassion.at/free-sql-ser...
#sqlserver #sqlpassion #healthcheck #performance
❌ Wrong.
Bad indexes remain bad indexes.
Like in triathlon: you can’t replace training with a new bike. 🚴
👉 Free SQL Server Health Check: www.sqlpassion.at/free-sql-ser...
#sqlserver #sqlpassion #healthcheck #performance
[Blog] Understanding Text Data Types in PostgreSQL and SQL Server: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlserver
Understanding Text Data Types in PostgreSQL and SQL Server – SQLpassion
www.sqlpassion.at
February 24, 2025 at 10:09 AM
[Blog] Understanding Text Data Types in PostgreSQL and SQL Server: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlserver
I've published one about GiST indexes last week: www.sqlpassion.at/archive/2026...
GiST and SP-GiST Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
January 12, 2026 at 9:40 PM
I've published one about GiST indexes last week: www.sqlpassion.at/archive/2026...
Check it out at github.com/SQLpassion/o...
GitHub - SQLpassion/osdev: This repository contains OS development specific code and tutorials
This repository contains OS development specific code and tutorials - SQLpassion/osdev
github.com
June 17, 2026 at 9:16 PM
Check it out at github.com/SQLpassion/o...
[Blog] Spatial Data with PostGIS in PostgreSQL: www.sqlpassion.at/archive/2026... #postgres #PostgreSQL #gis #PostGIS
Spatial Data with PostGIS in PostgreSQL – SQLpassion
www.sqlpassion.at
January 26, 2026 at 11:14 AM
[Blog] Spatial Data with PostGIS in PostgreSQL: www.sqlpassion.at/archive/2026... #postgres #PostgreSQL #gis #PostGIS
[Blog] Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL: www.sqlpassion.at/archive/2025... #Postgres #PostgreSQL #SQLServer #Migrations #Overhead
Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL – SQLpassion
www.sqlpassion.at
September 8, 2025 at 3:01 PM
[Blog] Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL: www.sqlpassion.at/archive/2025... #Postgres #PostgreSQL #SQLServer #Migrations #Overhead
[Blog] Hash Indexes in PostgreSQL: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlpassion #performance #indexing
Hash Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
December 22, 2025 at 4:58 PM
[Blog] Hash Indexes in PostgreSQL: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlpassion #performance #indexing
From the archive: [Blog] The ambiguity of the ORDER BY in SQL Server: https://buff.ly/2nkcbdF #sqlserver #sqlpassion #performance
The ambiguity of the ORDER BY in SQL Server – SQLpassion
buff.ly
November 30, 2024 at 1:55 AM
From the archive: [Blog] The ambiguity of the ORDER BY in SQL Server: https://buff.ly/2nkcbdF #sqlserver #sqlpassion #performance
🚀 Big news! After years of creating SQL Server Quickies, I’ve launched my new #PostgreSQL Quickies series on YouTube.
Episode 1: Running PostgreSQL with Docker 🐳.
Short, practical, hands-on!
👉 www.sqlpassion.at/archive/2025...
Episode 1: Running PostgreSQL with Docker 🐳.
Short, practical, hands-on!
👉 www.sqlpassion.at/archive/2025...
Introducing my new PostgreSQL Quickies Series on YouTube – SQLpassion
www.sqlpassion.at
September 15, 2025 at 2:55 PM
🚀 Big news! After years of creating SQL Server Quickies, I’ve launched my new #PostgreSQL Quickies series on YouTube.
Episode 1: Running PostgreSQL with Docker 🐳.
Short, practical, hands-on!
👉 www.sqlpassion.at/archive/2025...
Episode 1: Running PostgreSQL with Docker 🐳.
Short, practical, hands-on!
👉 www.sqlpassion.at/archive/2025...
Klaus Aschenbrenner explains why SQL Server folks have to write their CREATE TABLE statements differently when moving to Postgres, because column order matters: www.sqlpassion.at/archive/2025...
Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL – SQLpassion
Cart
www.sqlpassion.at
September 8, 2025 at 5:05 PM
Klaus Aschenbrenner explains why SQL Server folks have to write their CREATE TABLE statements differently when moving to Postgres, because column order matters: www.sqlpassion.at/archive/2025...
[Blog] New on YouTube: PostgreSQL Introduction for the SQL Server Professional: www.sqlpassion.at/archive/2025... #sqlpassion #PostgreSQL #postgres
New on YouTube: PostgreSQL Introduction for the SQL Server Professional – SQLpassion
www.sqlpassion.at
December 1, 2025 at 2:13 PM
[Blog] New on YouTube: PostgreSQL Introduction for the SQL Server Professional: www.sqlpassion.at/archive/2025... #sqlpassion #PostgreSQL #postgres
Just published a deep-dive into my upgraded Home Lab:
✅ Proxmox Hypervisor
✅ 3x HP DL380 G8 servers
✅ 10/40 Gbit network
✅ Solar-powered + UPS failover
It’s fast, efficient, and built for real SQL Server workloads. 🧵👇
🔗 www.sqlpassion.at/archive/2025... #sqlserver #proxmox #homelab #virtualization
✅ Proxmox Hypervisor
✅ 3x HP DL380 G8 servers
✅ 10/40 Gbit network
✅ Solar-powered + UPS failover
It’s fast, efficient, and built for real SQL Server workloads. 🧵👇
🔗 www.sqlpassion.at/archive/2025... #sqlserver #proxmox #homelab #virtualization
Solar-Powered, Proxmox-Driven: A Tour of My Ultimate SQL Server Home Lab – SQLpassion
www.sqlpassion.at
May 12, 2025 at 12:32 PM
Just published a deep-dive into my upgraded Home Lab:
✅ Proxmox Hypervisor
✅ 3x HP DL380 G8 servers
✅ 10/40 Gbit network
✅ Solar-powered + UPS failover
It’s fast, efficient, and built for real SQL Server workloads. 🧵👇
🔗 www.sqlpassion.at/archive/2025... #sqlserver #proxmox #homelab #virtualization
✅ Proxmox Hypervisor
✅ 3x HP DL380 G8 servers
✅ 10/40 Gbit network
✅ Solar-powered + UPS failover
It’s fast, efficient, and built for real SQL Server workloads. 🧵👇
🔗 www.sqlpassion.at/archive/2025... #sqlserver #proxmox #homelab #virtualization
[Blog] Bringing 10 Gbit to my Client Devices in my Home Office: www.sqlpassion.at/archive/2025... #sqlpassion #performance #homelab #networking
Bringing 10 Gbit to my Client Devices in my Home Office – SQLpassion
www.sqlpassion.at
October 20, 2025 at 1:27 PM
[Blog] Bringing 10 Gbit to my Client Devices in my Home Office: www.sqlpassion.at/archive/2025... #sqlpassion #performance #homelab #networking
[Blog] Switching My 2019 MacBook Pro to Linux: The T2-Ubuntu Journey: www.sqlpassion.at/archive/2025... #sqlpassion #apple #linux #ubuntu
Switching My 2019 MacBook Pro to Linux: The T2-Ubuntu Journey – SQLpassion
www.sqlpassion.at
July 2, 2025 at 1:37 PM
[Blog] Switching My 2019 MacBook Pro to Linux: The T2-Ubuntu Journey: www.sqlpassion.at/archive/2025... #sqlpassion #apple #linux #ubuntu
Did you miss it? [Blog] SQLpassion Online Training in January 2018: https://buff.ly/2md1O9U #learning #performance #sqlserver #sqlpassion
SQLpassion Online Training in January 2018 – SQLpassion
buff.ly
November 30, 2024 at 2:25 PM
Did you miss it? [Blog] SQLpassion Online Training in January 2018: https://buff.ly/2md1O9U #learning #performance #sqlserver #sqlpassion
Why I Created the SQL Rescue Sprint - And How It Works: www.sqlpassion.at/archive/2025... #sqlserver #sqlpassion #sqlrescue #performance #troubleshooting
Why I Created the SQL Rescue Sprint – And How It Works – SQLpassion
www.sqlpassion.at
June 4, 2025 at 12:17 PM
Why I Created the SQL Rescue Sprint - And How It Works: www.sqlpassion.at/archive/2025... #sqlserver #sqlpassion #sqlrescue #performance #troubleshooting
[Blog] SQL Server 2025 RTM – A Technical Deep Dive into Microsoft’s Most Capable Release Yet: www.sqlpassion.at/archive/2025... #sqlserver #performance #sqlpassion
SQL Server 2025 RTM – A Technical Deep Dive into Microsoft’s Most Capable Release Yet – SQLpassion
www.sqlpassion.at
November 24, 2025 at 12:28 PM
[Blog] SQL Server 2025 RTM – A Technical Deep Dive into Microsoft’s Most Capable Release Yet: www.sqlpassion.at/archive/2025... #sqlserver #performance #sqlpassion
Did you miss it? [Blog] SQLpassion Workshops for Fall 2017: http://buff.ly/2s8Obyv #learning #sqlserver #sqlpassion #performance
SQLpassion Workshops for Fall 2017 – SQLpassion
buff.ly
December 1, 2024 at 9:20 AM
Did you miss it? [Blog] SQLpassion Workshops for Fall 2017: http://buff.ly/2s8Obyv #learning #sqlserver #sqlpassion #performance