SQLpassion BLOG

Attend my Online Training in November: PostgreSQL for the SQL Server Professional

06/23/2025 / By / PostgreSQL / Leave a Comment

Are you a seasoned SQL Server professional looking to broaden your horizons and step into the world of PostgreSQL? Do you want to leverage your existing SQL Server expertise while mastering the unique features of PostgreSQL? If so, I’ve got exciting news for you! I’m thrilled to announce that I’m running again my brand-new, two-day …

Attend my Online Training in November: PostgreSQL for the SQL Server Professional + read more

Maximizing 40G NIC Performance on Linux with Intel XL710 and Cisco Nexus Switches

06/16/2025 / By / Linux, Performance Tuning / Leave a Comment

In this comprehensive technical walkthrough, I’ll take you through a real-world journey of troubleshooting and tuning a high-performance 40 Gbit Ethernet setup using Intel XL710 network cards connected through a Cisco Nexus 3064 switch. The goal was simple but challenging: to achieve near line-rate performance using iperf3 between two Linux (Proxmox) systems. When I first started testing …

Maximizing 40G NIC Performance on Linux with Intel XL710 and Cisco Nexus Switches + read more

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

06/11/2025 / By / PostgreSQL, SQLServer / Leave a Comment

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

06/04/2025 / By / Performance Tuning, SQLServer / Leave a Comment

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

SQLpassion Performance Tuning Training Plan – Signup

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.