SQLpassion BLOG

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