Performance Tuning

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

02/02/2026 / By / Performance Tuning, SQLServer / Leave a Comment

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning Fundamentals will take place! This hands-on session is designed to help DBAs, developers, and consultants deeply understand how SQL Server executes queries and how you can systematically improve performance with smarter indexing and execution-plan analysis. If you’re still on the fence …

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday! + read more

Why I Avoid SMR Drives – and What the New Western Digital Warnings Reveal

10/24/2025 / By / Computer Science, Performance Tuning, Uncategorized / Leave a Comment

Over the years, I’ve learned that high performance doesn’t just happen – neither in life nor in databases. When I transformed myself from an 85 kg couch potato into a 65 kg triathlete, I realized the same principle applies everywhere: performance is the result of conscious choices, discipline, and understanding what really goes on under …

Why I Avoid SMR Drives – and What the New Western Digital Warnings Reveal + read more

Bringing 10 Gbit to my Client Devices in my Home Office

10/20/2025 / By / Performance Tuning / Leave a Comment

For years, my home network has been running on a simple 1 Gbit setup based on Ubiquiti hardware (Router, Rack Switches, Edge Switches, WIFI Access Points). It connects everything in our house – from my Windows and Linux workstation, my MacBook Air, and all our WIFI clients. It’s stable, efficient, and perfectly adequate for everyday …

Bringing 10 Gbit to my Client Devices in my Home Office + 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

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.