SQLServer

Speaking about Latches & Spinlocks at the EightKB Online Conference

01/25/2021 / By / Conferences, SQLServer / 1 Comment

This Wednesday I have the pleasure to speak about Latches, Spinlocks, and Latch Free Data Structures at the EightKB Online Conference. This year they are expecting more than 1500 attendees and they have a great lineup with well-known international speakers: Amit Bansal speaks about SQL Server Memory Internals and Troubleshooting Bob Pusateri speaks about The Ins and …

Speaking about Latches & Spinlocks at the EightKB Online Conference + read more

SQLpassion Online Training about Statistics & Plan Caching

01/07/2021 / By / Performance Tuning, SQLServer / Leave a Comment

On January 28, 2021 I will run an SQLpassion Online Training about Statistics & Plan Caching in SQL Server. Statistics are used by SQL Server to estimate how many rows are returned for a given query. Based on that assumption, the Query Optimizer compiles a physical Execution Plan, which is finally executed by SQL Server. The …

SQLpassion Online Training about Statistics & Plan Caching + read more

SQLpassion Online Training about SQL Server on VMware

09/09/2020 / By / SQLServer, VMware / Leave a Comment

On October 8, 2020 I will run an SQLpassion Online Training about how to run SQL Server successfully on VMware vSphere. In this one-day long workshop we will look at the core resources used by SQL Server on VMware vSphere, and how you have to configure them to get the best possible performance from your …

SQLpassion Online Training about SQL Server on VMware + read more

SQLpassion Online Training about Availability Groups

05/11/2020 / By / SQLServer / Leave a Comment

On June 7, 2020 I will run an SQLpassion Online Training about SQL Server Availability Groups. You will learn in this Online Training how to deploy and run SQL Server Availability Group solutions from the initial setup to more complex scenarios where Load Balancing is also involved. Throughout the course you see step-by-step the advantages …

SQLpassion Online Training about Availability Groups + 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.