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
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 …
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
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 …
One of the coolest new performance improvements in SQL Server 2019 is a better support for Scalar Valued Functions. As you (hopefully) know, Scalar Valued Functions always introduced a huge amount of performance problems – based on their implementation in SQL Server. Scalar Valued Functions prior SQL Server 2019 I don’t know a database which …
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.
