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 …
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 will also populate the database …
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 …
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
On June 24, 2019 I’m running a one-day long webinar about SQL Server Query Tuning Fundamentals. In this one-day long webinar you will learn about: How to access your data through Indexes Heap Tables Clustered Index Non-Clustered Index Index Scans Index Seeks Execution Plans Overview Estimated Execution Plan Actual Execution Plan Data Access Operators Join …
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.
