Klaus Aschenbrenner

SQLpassion Online Training about Intelligent Query Processing

11/13/2019 / By / Performance Tuning, SQLServer / Leave a Comment

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

10/10/2019 / By / Kubernetes, Linux, Performance Tuning, SQLServer, VMware / Leave a Comment

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

Scalar Valued Functions in SQL Server 2019

06/18/2019 / By / Performance Tuning, SQLServer / 2 Comments

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 …

Scalar Valued Functions in SQL Server 2019 + read more

Benchmarking the VMware LSI Logic SAS Controller against the PVSCSI Controller

06/10/2019 / By / SQLServer, VMware / 2 Comments

In today’s blog posting I want to talk more about the differences between the LSI Logic SAS and the VMware Paravirtual (PVSCSI) Controller that you can use in your VMware based Virtual Machines to attach VMDK files. LSI Logic SAS Controller If you add VMDK files to your Virtual Machine, VMware vSphere uses by default …

Benchmarking the VMware LSI Logic SAS Controller against the PVSCSI Controller + read more

SQLpassion Performance Tuning Training Plan – Signup

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.