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 …
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
Today I’m quite happy to announce my upcoming SQLpassion Trainings for the next few months. Currently I have scheduled the following online trainings: Design, Deploy, and Optimize SQL Server on VMware SQL Server on Linux, Docker, and Kubernetes SQL Server Performance Tuning & Troubleshooting Workshop I’m quite happy to provide a brand-new training about how …
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.
