Kendra Little

@UCrJ8WLrVoKxL94mKv2akxTA - 9.3K subscribers

For twenty years, Kendra has coaxed SQL Server into doing things it does not want to do: scaling under duress, performing under scrutiny, behaving during peak traffic like a well-adjusted adult. These are her adventures.

Home Videos Live Playlists

Rita the Raccoon Writes SQL

Rita the Raccoon Writes SQL Kendra Little

418 views - 2 years ago

My sessions at PASS Data Community Summit 2023

My sessions at PASS Data Community Summit 2023 Kendra Little

259 views - 2 years ago

Why to attend PASS Data Community Summit 2023

Why to attend PASS Data Community Summit 2023 Kendra Little

153 views - 2 years ago

Dear SQL DBA - Down Tools Week 2020

Dear SQL DBA - Down Tools Week 2020 Kendra Little

1.2K views - 5 years ago

3 Things that Shouldn't be Normal in Database Development

3 Things that Shouldn't be Normal in Database Development Kendra Little

1.7K views - 5 years ago

Dear SQL DBA: Everything I Never Wanted to Know About Collation

Dear SQL DBA: Everything I Never Wanted to Know About Collation Kendra Little

5.4K views - 5 years ago

The Manager's Guide to Git Training for DBAs

The Manager's Guide to Git Training for DBAs Kendra Little

1.1K views - 5 years ago

SSMS Shortcuts - Session Management

SSMS Shortcuts - Session Management Kendra Little

2.2K views - 5 years ago

SSMS Shortcuts - Indenting, commenting, scripting, and TSQL hacks

SSMS Shortcuts - Indenting, commenting, scripting, and TSQL hacks Kendra Little

6.5K views - 5 years ago

SSMS Shortcuts - XEvents Wizard Secrets

SSMS Shortcuts - XEvents Wizard Secrets Kendra Little

646 views - 5 years ago

SSMS Shortcuts - Execution Plans

SSMS Shortcuts - Execution Plans Kendra Little

737 views - 5 years ago

SSMS Shortcuts - Diagnosis for Stack Dumps

SSMS Shortcuts - Diagnosis for Stack Dumps Kendra Little

954 views - 5 years ago

SSMS Shortcuts - Pinning and Custom Keyboard Shortcuts

SSMS Shortcuts - Pinning and Custom Keyboard Shortcuts Kendra Little

2.8K views - 5 years ago

SSMS Shortcuts - Object Explorer Details

SSMS Shortcuts - Object Explorer Details Kendra Little

2.9K views - 5 years ago

SSMS Shortcuts - IntelliSense

SSMS Shortcuts - IntelliSense Kendra Little

5.3K views - 5 years ago

SSMS Shortcuts - Splitter Bar and Quick Find

SSMS Shortcuts - Splitter Bar and Quick Find Kendra Little

888 views - 5 years ago

SSMS Shortcuts - Tabs/Spaces, Regex, Typing on Multiple Lines

SSMS Shortcuts - Tabs/Spaces, Regex, Typing on Multiple Lines Kendra Little

3.3K views - 5 years ago

SSMS Shortcuts - Stupid Pet Tricks

SSMS Shortcuts - Stupid Pet Tricks Kendra Little

768 views - 5 years ago

SSMS Shortcuts - Thanks for Watching

SSMS Shortcuts - Thanks for Watching Kendra Little

313 views - 5 years ago

SSMS Shortcuts - Welcome

SSMS Shortcuts - Welcome Kendra Little

1.6K views - 5 years ago

Course: Tuning a Stored Procedure - Integrating the Changes, and Other Improvements

Course: Tuning a Stored Procedure - Integrating the Changes, and Other Improvements Kendra Little

1.9K views - 5 years ago

Course: Tuning a Stored Procedure - Tuning the Slow Query

Course: Tuning a Stored Procedure - Tuning the Slow Query Kendra Little

2.1K views - 5 years ago

Course: Tuning a Stored Procedure - Finding the Slow Query with Query Store

Course: Tuning a Stored Procedure - Finding the Slow Query with Query Store Kendra Little

16.3K views - 5 years ago

Course: Tuning a Stored Procedure - The Problem

Course: Tuning a Stored Procedure - The Problem Kendra Little

1.8K views - 5 years ago

Course: Tuning a Stored Procedure - Trace Flag 7412 and Live Query Plans

Course: Tuning a Stored Procedure - Trace Flag 7412 and Live Query Plans Kendra Little

2.5K views - 5 years ago

Course: Tuning a Stored Procedure - Finding the Slow Query with the Plan Cache

Course: Tuning a Stored Procedure - Finding the Slow Query with the Plan Cache Kendra Little

15.6K views - 5 years ago

SQLChallenge: Event Notifications - Solution

SQLChallenge: Event Notifications - Solution Kendra Little

5.9K views - 5 years ago

SQLChallenge: Event Notifications - Challenge

SQLChallenge: Event Notifications - Challenge Kendra Little

373 views - 5 years ago

SQLChallenge: Event Notifications - Setup

SQLChallenge: Event Notifications - Setup Kendra Little

201 views - 5 years ago

SQLChallenge: DDL Triggers - Solution

SQLChallenge: DDL Triggers - Solution Kendra Little

585 views - 5 years ago

SQLChallenge: DDL Triggers - Challenge

SQLChallenge: DDL Triggers - Challenge Kendra Little

358 views - 5 years ago

A Dynamic SQLChallenge: Solution

A Dynamic SQLChallenge: Solution Kendra Little

145 views - 5 years ago

A Dynamic SQLChallenge: Setup and Problem

A Dynamic SQLChallenge: Setup and Problem Kendra Little

291 views - 5 years ago

Query Writing: Peak Year - Sample Solution

Query Writing: Peak Year - Sample Solution Kendra Little

134 views - 5 years ago

Query Writing: Unique Names - Challenge

Query Writing: Unique Names - Challenge Kendra Little

204 views - 5 years ago

Query Writing: Unique Names - Sample Solutions

Query Writing: Unique Names - Sample Solutions Kendra Little

223 views - 5 years ago

Query Writing: Peak Year - Setup and Problem

Query Writing: Peak Year - Setup and Problem Kendra Little

156 views - 5 years ago

Idempotent TSQL Challenge: Possible Solutions

Idempotent TSQL Challenge: Possible Solutions Kendra Little

315 views - 5 years ago

Idempotent TSQL Challenge: The Problem

Idempotent TSQL Challenge: The Problem Kendra Little

164 views - 5 years ago

Idempotent TSQL Challenge: The Setup

Idempotent TSQL Challenge: The Setup Kendra Little

234 views - 5 years ago

Explore the slow query's execution plan

Explore the slow query's execution plan Kendra Little

511 views - 5 years ago

Dynamic SQL Kendra Little

2.8K views - 5 years ago

The challenge query - a demo

The challenge query - a demo Kendra Little

329 views - 5 years ago

Index hints and local variables

Index hints and local variables Kendra Little

2.2K views - 5 years ago

Using a temp table

Using a temp table Kendra Little

816 views - 5 years ago

Why creating an index can slow down a query - Introduction

Why creating an index can slow down a query - Introduction Kendra Little

1K views - 5 years ago

Why did the query slow down?

Why did the query slow down? Kendra Little

248 views - 5 years ago

Which solution is best?

Which solution is best? Kendra Little

146 views - 5 years ago

Rewrites that don't help

Rewrites that don't help Kendra Little

161 views - 5 years ago

Monitoring open transactions and low_water_mark_for_ghosts

Monitoring open transactions and low_water_mark_for_ghosts Kendra Little

436 views - 5 years ago

Automatic Escalation to Snapshot Isolation

Automatic Escalation to Snapshot Isolation Kendra Little

247 views - 5 years ago

Considerations on When to Use RCSI and Snapshot

Considerations on When to Use RCSI and Snapshot Kendra Little

925 views - 5 years ago

Why Do We Need Snapshot Isolation and RCSI?

Why Do We Need Snapshot Isolation and RCSI? Kendra Little

2.2K views - 5 years ago

How Snapshot and RCSI Provide Consistent Results

How Snapshot and RCSI Provide Consistent Results Kendra Little

834 views - 5 years ago

Demo- Read Committed Returns Incorrect Data

Demo- Read Committed Returns Incorrect Data Kendra Little

332 views - 5 years ago

Why Read Committed is the Default Isolation Level and What to Do Next

Why Read Committed is the Default Isolation Level and What to Do Next Kendra Little

2.4K views - 5 years ago

Differences Between RCSI and Snapshot Isolation

Differences Between RCSI and Snapshot Isolation Kendra Little

2.1K views - 5 years ago

What is the Read Committed Isolation Level?

What is the Read Committed Isolation Level? Kendra Little

1.5K views - 5 years ago

Keys and Includes - Tracing buffer latches on seeks and scans

Keys and Includes - Tracing buffer latches on seeks and scans Kendra Little

182 views - 5 years ago

Keys and Includes - Explore the index pages and their links

Keys and Includes - Explore the index pages and their links Kendra Little

456 views - 5 years ago