Speaker

Kendra Little

Kendra Little

Consultant and Cartoonist

Kendra Little (she/her) helps DBAs and Developers get the most out of the SQL Server engine with SQL Comics and consulting services at CatalyzeSQL.com. Kendra is a Microsoft Certified Master in SQL Server and a well-known speaker and expert on database performance tuning and management. She has extensive cross-silo experience in consulting, Database DevOps and performance tuning for the Microsoft Data Platform. Kendra specializes in training software developers and IT professionals to troubleshoot the toughest database problems and implement automation while keeping data safe.

Area of Expertise

  • Information & Communications Technology

Topics

  • Database Administration
  • DevOps & Automation
  • performance tuning

Performance Tuning Azure SQL Database

Azure SQL Database is much more than SQL Server running on someone else's server: the database engine from SQL Server has been adapted-- and in some configurations, radically transformed-- to handle cloud-native workloads. In this session we will cover how to identify the right service tier for your workload, how to identify and manage high CPU scenarios, and how to identify and fight blocking, deadlocks, and slow running queries in Azure SQL Database.

Defuse the Deadlock!

Deadlocks strike fear in the hearts of even experienced database administrators. In this session we will walk through an example deadlock and show how to find and interpret the deadlock graph to understand what is happening. We will examine, rate, and test ways to defuse the deadlock. You'll leave the session with an understanding of the questions to ask and avenues to explore the next time you're hit by a deadlock.

Learn GitHub by Contributing to Micorosoft Docs

Git has become an essential tool for everyone in IT, but many database professionals lag behind and haven't yet learned Git. In this demo-packed session, I'll show you how to learn Git by using GitHub to contribute to Microsoft Documentation. We'll start with an overview of Git and GitHub, then walk through an example of forking a repo, cloning it, creating a branch, committing and pushing a change, and creating a Pull Request.

The Case of the Slow Temp Table: A Performance Tuning Problem

A community member sent me an interesting question: why would using a temp table cause a stored procedure to slow down dramatically? Why would the procedure use massively more logical reads against a temp table than it does against a user database table? In this session we reproduce the problem, then use built-in tools in SQL Server to diagnose and understand what is happening. We use the results to make a plan to keep the stored procedure fast.

Kendra Little

Consultant and Cartoonist