SQLpassion BLOG

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

Remaining SQLpassion Online Trainings for the year 2020

10/19/2020 / By / Uncategorized / Leave a Comment

Time goes by, and this crazy year comes slowly to its end. Therefore, I’m announcing today the SQLpassion Online Trainings for the remaining year. I have scheduled the following 2 trainings: SQL Server on Linux, Docker, and Kubernetes: November 26, 2020 SQL Server Query Tuning Workshop – Online Edition: December 8 – 10, 2020 Because …

Remaining SQLpassion Online Trainings for the year 2020 + 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.