DevOps Discovery: Navigating the Database Landscape

on YouTube ↗48m

" summary

Redgate demos a concrete DevOps stack: Test Data Manager creates masked clones, shrinking a 5 TB → 100 MB per dev image and provisioning it in about 30 seconds to provision; SQL Prompt expands into Prompt Plus inside SSMS (EAP) to generate and optimize queries using local schema context; Flyway detects developer changes, auto-generates versioned migration and rollback scripts and orchestrates CI/CD; SQL Monitor gives a single-pane estate view with alerts, Postgres support and drift detection and rollback scripts for deployments.

AI-written summary · about

" chapters (8)

1. 0:00DevOps and database challenges
2. 1:10Three pillars of DevOps adoption
3. 3:59DevOps trends and challenges
4. 8:09Test data management
5. 17:26AI SQL coding with SQL Prompt
6. 24:32Flyway deployment automation
7. 39:04Monitoring databases with SQL Monitor
8. 45:44Summary and future

" related talks

• 48mDevOps Discovery: Navigating the Database LandscapeHuxley Kendell, David Ong · SQLBits 2019
• 48mDevOps Discovery: Navigating the Database LandscapeHuxley Kendell, David Ong · SQLBits 2022
• 01h 00mDevOps for Your Relational Database FoundationsBrian A. Randell · NDC London 2021
• 23mShift-Left: A DevOps and Database StoryKevin Kline · SQLBits 2022
• 50mBringing DevOps to the DatabaseSteve Jones · SQL Server Virtual Conference 2021
• 49mThe New Database Landscape - Revealing Shifts and Charting the Next HorizonGrant Fritchey, Danielle Summers · SQLBits 2022
• 47mEfficiency up, failed releases down; compliant production data for your test and dev environmentsGrant Fritchey, Chris Hawkins · SQLBits 2019
• 49mThe New Database Landscape - Revealing Shifts and Charting the Next HorizonGrant Fritchey, Danielle Summers · SQLBits 2019