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
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
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
Today I want to show you a very quick blog posting how easy it is to upgrade SQL Server on Linux. As you know from my previous blog posting I’m currently running in my Home Lab a Linux Ubuntu Virtual Machine, where I have installed SQL Server 2019 CTP 2.3. Last week Microsoft has released …
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.
