SQLpassion BLOG

My upcoming Online Speaking Engagements

Over the next few weeks I have some online speaking engagements that I want to share with you today. On May 7 (this Friday) I’m speaking at the DataPlatformGeeks Virtual Symposium about Locking Misconceptions in SQL Server. On May 11 I will speak at the Swedish User Group about Deadlocking in SQL Server. On May …

My upcoming Online 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

Building an AMD Ryzen system for Microsoft Flight Simulator 2020

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 build an AMD Ryzen system …

Building an AMD Ryzen system for Microsoft Flight Simulator 2020 + 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