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:

Computer Science
Klaus Aschenbrenner

Why I Avoid SMR Drives – and What the New Western Digital Warnings Reveal

Over the years, I’ve learned that high performance doesn’t just happen – neither in life nor in databases. When I transformed myself from an 85 kg couch potato into a 65 kg triathlete, I realized the same principle applies everywhere: performance is the result of conscious choices, discipline, and understanding what really goes on under

more
Performance Tuning
Klaus Aschenbrenner

Bringing 10 Gbit to my Client Devices in my Home Office

For years, my home network has been running on a simple 1 Gbit setup based on Ubiquiti hardware (Router, Rack Switches, Edge Switches, WIFI Access Points). It connects everything in our house – from my Windows and Linux workstation, my MacBook Air, and all our WIFI clients. It’s stable, efficient, and perfectly adequate for everyday

more
PostgreSQL
Klaus Aschenbrenner

Understanding Upstream vs. Downstream PostgreSQL

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

more

Watch one of my latest YouTube videos:

PostgreSQL
Klaus Aschenbrenner

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

more
PostgreSQL
Klaus Aschenbrenner

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,

more
Azure
Klaus Aschenbrenner

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.

more