Performance Tuning

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 Statistics & Plan Caching

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

SQLpassion Online Training in April

Today I’m quite happy to announce my upcoming SQLpassion Online Training for April. I have reworked the content of my already famous SQL Server Performance Troubleshooting Workshop, were I concentrate now more on the current VM and Hypervisor configuration for SQL Server. I will also give you a lot of different tips and tricks around …

SQLpassion Online Training in April + read more

SQLpassion Online Training about Intelligent Query Processing

It’s now a week ago, since Microsoft has finally released SQL Server 2019. Therefore, I’m running on December 9, 2019 an online training about Intelligent Query Processing in SQL Server 2017/2019. The Intelligent Query Processing feature family includes new functionalities that improve the performance of existing OLTP/OLAP workloads with almost no query rewrites. During this …

SQLpassion Online Training about Intelligent Query Processing + read more

Upcoming SQLpassion Online Trainings

Today I’m quite happy to announce my upcoming SQLpassion Trainings for the next few months. Currently I have scheduled the following online trainings: SQL Server on Linux, Docker, and Kubernetes SQL Server Performance Troubleshooting I’m quite happy to provide a brand-new training about how to run SQL Server on Linux, Docker, and Kubernetes. The first …

Upcoming SQLpassion Online Trainings + read more