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 your end user response times. …
SQLpassion Online Training about Locking, Blocking, and Deadlocking + read more
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 speaks about The Ins and …
Speaking about Latches & Spinlocks at the EightKB Online Conference + read more
As you might know, my son Philip is quite talented in Chess, and he already competes very succesfully at the national level. He is currently listed at the 8th rank within his age group. Because a lot of people are currently very interested in chess (especially because of the Netflix movie “The Queens Gambit“), my …
On January 28, 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 finally executed by SQL Server. The …
SQLpassion Online Training about Statistics & Plan Caching + read more
As we all know the Black Friday approaches quite fast, and therefore I want to offer you a great deal from my side. During the following 2 weeks I will offer you my available Online Trainings with a 60% (!) discounted price: Design, Deploy, and Optimize SQL Server on VMware SQL Server on VMware – Best …
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.
