For details about SQL Saturday Redmond, including the exact location, you can go here.

SQL Server Internals for Performance

We all know that the answer to almost any SQL Server tuning question is “It Depends!”

In this seminar, I’ll tell you what you need to know in order to figure out what it actually depends on! How can you answer these “It Depends” questions in your own environment? We’ll look at what kinds of tuning changes can be made to enhance your system or application performance, and what areas of SQL Server Internals you need to understand to make the best choice for you when trying to answer the following questions:

UPDATE locks are not really a separate kind of lock, but rather are a hybrid of SHARED and EXCLUSIVE locks. And contrary to what you might think, UPDATE locks are not just acquired for UPDATE operations. A transaction acquires this kind of lock when SQL Server executes a data modification operation but first needs to perform a search to find the resource to modify.

SQL Server Internals

Kalen Delaney teaches the most advanced SQL Server courses in the world. Her 5-day course “SQL Server Internals and Tuning” is designed for advanced SQL Server professionals who want to know how SQL Server really works, in order to take maximum advantage of its potential.