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. …
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
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
Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking about Azure SQL Managed Instance. If you are interested in learning more about this very interestingh topic, I highly recommend to check-out my live training about it that I run from November 27 – 28, 2024.
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major milestone for ARM-powered devices. This new release opens the door for users to install Windows 11 on their own ARM-based hardware. About a year ago, I invested in the Windows Dev Kit, which runs on the ARM Snapdragon Compute Platform. However, …
Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices + read more
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.
