Shift-Left: A DevOps and Database Story

on YouTube ↗23m

" summary

Code changes get performance-gated during CI so regressions fail before production. Uses Plan Explorer for query plans and index advice and SQL Sentry hooked into Visual Studio Team Services style pipelines to record deployment markers and system metrics. A recent demo surfaces nearly 200,000 key lookups after a deploy, lets the team reject the release, add an INCLUDE index, and re-run the pipeline to confirm reads and latency drop, enabling quick iteration instead of firefighting in production.

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

• 23mShift-Left: A DevOps and Database StoryKevin Kline · SQLBits 2022
• 23mShift-Left: A DevOps and Database StoryKevin Kline · SQLBits 2019
• 50mBringing DevOps to the DatabaseSteve Jones · SQL Server Virtual Conference 2021
• 20mExcellent Database Adventure: From Code Errors to Reliable ReleasesDave, James Hemson · SQLBits 2022
• 48mDevOps Discovery: Navigating the Database LandscapeHuxley Kendell, David Ong · SQLBits 2019
• 48mDevOps Discovery: Navigating the Database LandscapeHuxley Kendell, David Ong · SQLBits 2022
• 01h 00mContinuous Integration and Delivery for DatabasesJimmy Bogard · NDC London 2020
• 01h 10mContinuous Integration for the BI DeveloperWolfgang Strasser · Global Azure 2021