On April 22, 2021 I will run an SQLpassion Online Training about Statistics & Plan Caching in SQL Server. Statistics are used by SQL Server to estimate how many rows are returned for a given query. Based on that assumption, the Query Optimizer compiles a physical Execution Plan, which is ...

It’s now more than 1 year ago since I was sitting the last time in a real airplane. All my SQL Server related work happens these days entirely online: all my training sessions (public and private) are happening online, and also all my various customer engagements. Covid-19 has changed everything ...

As you might know, I’m quite addicted to flight simulation, and I’m also running my own a flight simulation center in Vienna (which is currently closed because of Covid-19). And last year Microsoft released Microsoft Flight Simulator 2020 (MSFS 2020). Therefore, I thought it would be a great idea to ...

On February 25, 2021 I will run an SQLpassion Online Training about Locking, Blocking, and Deadlocking in SQL Server – one of my favourite topics! Locks are used by SQL Server to isolate database users from each other. Unfortunately, incompatible locks lead to blocking situations. And blocking situations always hurt ...

This Wednesday I have the pleasure to speak about Latches, Spinlocks, and Latch Free Data Structures at the EightKB Online Conference. This year they are expecting more than 1500 attendees and they have a great lineup with well-known international speakers: Amit Bansal speaks about SQL Server Memory Internals and Troubleshooting Bob Pusateri ...