SQLpassion BLOG

Building a VS Code Debugging Workflow for a Custom x64 Operating System with QEMU and GDB

Designing and debugging your own operating system is one of the most fulfilling but technically demanding projects you can undertake as a systems programmer. You have to build every abstraction yourself – memory management, privilege levels, system calls, user-space transitions, and interrupt handling – all while dealing with the quirks of real hardware and complex …

Building a VS Code Debugging Workflow for a Custom x64 Operating System with QEMU and GDB + read more

Switching My 2019 MacBook Pro to Linux: The T2-Ubuntu Journey

After years of using macOS, I recently decided to install Linux on my old (unused) 13-inch MacBook Pro from 2019 – the one with the infamous Touch Bar and Apple’s T2 security chip. It wasn’t just an experiment. I wanted a fully working x64 based Linux desktop without buying any new hardware, and therefore I …

Switching My 2019 MacBook Pro to Linux: The T2-Ubuntu Journey + read more

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

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

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

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