SQLServer

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

Online Recording: Exploring PostgreSQL for SQL Server Developers and DBAs

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

Understanding Concurrency Control in SQL Server and PostgreSQL: A Comparative Analysis

Concurrency control is a cornerstone of database management systems, ensuring data consistency and integrity when multiple users access or modify data simultaneously. SQL Server and PostgreSQL implement concurrency control differently, reflecting their distinct architectural philosophies. In this blog post, I will explore the concurrency methods used by these systems, focusing on the methods of pessimistic …

Understanding Concurrency Control in SQL Server and PostgreSQL: A Comparative Analysis + read more