~/talk

Shift-Left: A DevOps and Database Story

on YouTube 23m
Talkat SQLBits 2022 · 2022-03-08..03-12· [databases, devops-and-delivery]

speaker

name:Kevin Kline
links:none on file

resources

video:https://youtu.be/y3UMHA4GFnU
slides:none on file

summary

Claims that shifting database performance testing left into development prevents production slowdowns, and shows it using SQL Sentry and the free Plan Explorer integrated into a Visual Studio/TFS pipeline. The demo surfaces precise signals — spikes in key lookups, missing-index warnings, and hundreds of thousands of reads — and marks deployments so teams can reject regressions. Fixes are concrete: add an index or INCLUDE columns, redeploy, and watch reads and execution plans drop.

AI-written summary · about

chapters (10)

  1. 0:00Introduction
  2. 3:17Plan Explorer tool features
  3. 5:47DevOps basics
  4. 8:45Shift-left performance testing
  5. 10:51Demo setup
  6. 12:40Interpreting monitoring graphs
  7. 14:50Monitoring in CI/CD
  8. 17:23Deployment impacts on queries
  9. 19:28Fixing key lookup anti-patterns
  10. 21:37Summary

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.