Kalen Delaney has been working with SQL Server for over 32 years, providing advanced SQL Server training to clients around the world. She was a SQL Server MVP for 25 years, since 1993, until starting to work for Microsoft. She has been writing about SQL Server almost as long as she has been using it. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server 2016 Internals: In-memory OLTP, from Red Gate.   

Kalen Delaney's Sessions

Behind the Query Store…SQLBits 2019

Look inside Query Store to see what it does and how it works

Behind the Query Store…SQLBits 2019

Look inside Query Store to see what it does and how it works

Behind the Query Store…SQLBits 2019

Look inside Query Store to see what it does and how it works

Behind the Query Store…SQLBits 2019

Look inside Query Store to see what it does and how it works

Behind the Query Store…SQLBits 2019

Look inside Query Store to see what it does and how it works

Exploring Statistics: Where estimated rowcount comes fromSQLBits 2017

A look inside SQL Server distribution statistics

What Happened? Exploring the Plan CacheSQLBits 2015

In this session, we'll explore SQL Server's plan cache, including techniques for discovering what plans are in cache, how often they've been run, and whether they contain any sub-optimal operators. Knowing what's happened is the first step in tuning.

Seeking SQL Server SecretsSQLBits 2013

In this session, I’ll tell you about some of my favorite undocumented features, and also tell you some of my tricks for discovering more undocumented secrets.

Seeking SQL Server SecretsSQLBits 2013

In this session, I’ll tell you about some of my favorite undocumented features, and also tell you some of my tricks for discovering more undocumented secrets.

Seeking SQL Server SecretsSQLBits 2013

In this session, I’ll tell you about some of my favorite undocumented features, and also tell you some of my tricks for discovering more undocumented secrets.