SQLpassion BLOG

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

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 Online Training in June 2019

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 …

SQLpassion Online Training in June 2019 + read more

Save 50% on my SQL Server Performance Tuning & Troubleshooting Workshop

As you might know, I’m running next week in Utrecht/Netherlands my SQL Server Performance Tuning & Troubleshooting Workshop. The agenda of this deep-dive workshop is quite impressive: Performance Tuning Fundamentals Extended Events Working with large Databases Transactions & Currency Lock Escalations Deadlocking Latches & Spinlocks Troubleshooting TempDb Performance Monitoring Performance Troubleshooting If you are interested …

Save 50% on my SQL Server Performance Tuning & Troubleshooting Workshop + read more

SQL Server on Linux – how does it actually work?

Over the last few weeks I have already written a lot about how to run SQL Server on Linux, Docker, and Kubernetes. But I haven’t yet talked about how SQL Server can actually run on Linux. Therefore, it’s time today to unveil this little secret 🙂 . Drawbridge When Microsoft first thought about SQL Server …

SQL Server on Linux – how does it actually work? + read more