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 ...

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, ...

Read more

Troubleshooting NUMA Node Imbalance Problems

My goal for last week was to get familiar with the HammerDB load generator and test-drive the TPC-C workload in my powerful Home Lab. This sounds like an easy task, because HammerDB automates all the necessary tasks for you. You can create the schema of the TPC-C database, and HammerDB ...

Read more

Scalar Valued Functions in SQL Server 2019

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 ...

Read more

Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top