After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling to a country where everyone speaks a language I mostly understand – but with a different accent and some unfamiliar slang. At first glance, SQL is SQL. But once I started writing real queries in PostgreSQL, I realized that my habits from T-SQL …
From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences + read more
Over the past 25 years, I’ve worked with SQL Server in all kinds of environments: startups, mid-size companies, and global enterprises. And no matter the industry or infrastructure, one thing is always true: When SQL Server slows down, everything slows down! Reports take forever. Blocking brings processes to a halt. Deadlocks frustrate both users and …
Why I Created the SQL Rescue Sprint – And How It Works + read more
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
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. …
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, …
Online Recording: Exploring PostgreSQL for SQL Server Developers and DBAs + 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.
