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
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 …
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. …
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
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
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
