SQLServer

Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL

Last Thursday I had the chance to attend the PGDay Austria conference, and it turned out to be one of the most inspiring community events I’ve been to in a long time. Not only did I listen to great talks about PostgreSQL internals, I also gave my very first lightning talk – nervously stepping on stage …

Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL + read more

From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences

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

Why I Created the SQL Rescue Sprint – And How It Works

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

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

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