Klaus Aschenbrenner

Solar-Powered, Proxmox-Driven: A Tour of My Ultimate SQL Server Home Lab

Back in 2018, I wrote a blog post about my Home Lab environment, which I had built around VMware vSphere to showcase various SQL Server workloads and demonstrate how to troubleshoot performance-related problems. Since then, a lot has changed – especially with the acquisition of VMware by Broadcom. In the past, I was a subscriber …

Solar-Powered, Proxmox-Driven: A Tour of My Ultimate SQL Server Home Lab + read more

Mastering Memory Safety & Performance with Rust – a 1 day Intensive Online Training on June 24, 2025

Are you an experienced developer in C, C++, C#, or Java looking for a modern language that gives you control without the chaos? Join me for a fast-paced, 1-day online training and discover why Rust is redefining systems programming – combining the power of C/C++ with the safety of high-level languages. 🚀 Why You Should Attend …

Mastering Memory Safety & Performance with Rust – a 1 day Intensive Online Training on June 24, 2025 + read more

Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025

I’m excited to announce that on June 17 – 18, 2025, I’ll be running a special Online Live Training event focused entirely on SQL Server Query Tuning! This is a compact, intensive 2-day version of my highly acclaimed SQL Server Query Tuning Workshop – a course I delivered extensively across Europe before the COVID-19 pandemic. …

Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025 + read more

Understanding Text Data Types in PostgreSQL and SQL Server

When working with PostgreSQL, understanding its text data types is essential, especially for those coming from a Microsoft SQL Server background. While both database systems support text storage, they handle it in fundamentally different ways. PostgreSQL provides several text-related data types, each with its own purpose and behavior, and understanding their nuances can help avoid …

Understanding Text Data Types in PostgreSQL and SQL Server + read more

Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server

When it comes to database performance, query execution planning is one of the most critical factors. Every time a database receives a query, it must decide how to execute it in the most efficient way possible. This decision making process – known as query planning – can be expensive in terms of computation time, especially …

Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server + read more