I‘m Klaus Aschenbrenner, a Microsoft Certified Master for SQL Server
» I help people to bring their SQL Server & PostgreSQL
installations to a new level of excellence. «
SQLpassion Offerings
SQLpassion helps businesses get the most out of SQL Server & PostgreSQL – from smooth setups to better performance and long-term stability. As a Microsoft Certified Master, I offer tailored consulting, hands-on workshops, and share my expertise at international events – all with a clear focus on delivering real results.
Read one of my latest blog posts:
GIN Indexes in PostgreSQL
If you come from SQL Server (like in my case), PostgreSQL indexing can feel familiar at first – B-tree indexes exist, composite indexes exist, covering indexes exist. And then you run into queries like this: or this: At that point, most SQL Server developers ask two questions: What are these operators? Why does PostgreSQL need
Level Up Your Skills in 2026: Live Online Trainings for Database & Infrastructure Professionals
The first half of 2026 is packed with live, instructor-led online trainings designed for professionals who want to go deeper – not just collect features, but truly understand how things work and how to use them effectively in production. Whether you are a SQL Server professional, expanding into PostgreSQL, Linux, automation, or even systems programming
GiST and SP-GiST Indexes in PostgreSQL
When SQL Server developers begin working with PostgreSQL, indexing usually feels familiar at first. B-tree indexes behave as expected, query plans look readable, and the query planner makes reasonable choices. But PostgreSQL also introduces new index types like GiST and SP-GiST. They do not map cleanly to anything in SQL Server, and documentation often describes
Watch one of my latest YouTube videos:
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
Online Recording: Exploring PostgreSQL for SQL Server Developers and DBAs
On January 9 I have done an online presentation about Exploring PostgreSQL for the SQL Server Developers and DBAs for the Cloud Data Driven User Group. You can find the recording of the whole session (around 105 minutes) here to watch: If you’d like to explore the differences between SQL Server and PostgreSQL in greater depth,
SQL Server Quickie #48 – Azure SQL Managed Instance
Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking about Azure SQL Managed Instance. If you are interested in learning more about this very interestingh topic, I highly recommend to check-out my live training about it that I run from November 27 – 28, 2024.
