SQLServer

My upcoming Online Trainings and Speaking Engagements

Over the next few weeks I have again some online training and speaking engagements that I want to share with you today: On September 29, I’m speaking at the Future Data Driven online conference about Myths & Misconceptions around Locking and Blocking in SQL Server On October 7, I have an online training about SQL …

My upcoming Online Trainings and Speaking Engagements + read more

SQLpassion Online Training about Statistics & Plan Caching

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 finally executed by SQL Server. The …

SQLpassion Online Training about Statistics & Plan Caching + read more

SQLpassion Online Training about Locking, Blocking, and Deadlocking

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