DevOps Discovery: Navigating the Database Landscape
summary
Redgate demonstrates a pipeline: Test Data Manager creates masked, containerized clones in ~30s and claims it can reduce a 5TB production dataset to ~100MB per developer, supporting SQL Server, Postgres, MySQL and Oracle. Flyway generates versioned migration scripts, rollbacks and drift checks and now covers 50+ platforms for CI/CD. SQL Prompt adds Prompt Plus that queries your actual schema with GPT-4 and SQL Monitor gives a single-pane estate dashboard, alerts and baselining.
AI-written summary · about
chapters (8)
- 0:00DevOps and database challenges
- 1:10Three pillars of DevOps adoption
- 3:59DevOps trends and challenges
- 8:09Test data management
- 17:26AI SQL coding with SQL Prompt
- 24:32Flyway deployment automation
- 39:04Monitoring databases with SQL Monitor
- 45:44Summary and future
related talks
48mDevOps Discovery: Navigating the Database Landscape- 48mDevOps Discovery: Navigating the Database Landscape
47mEfficiency up, failed releases down; compliant production data for your test and dev environments
49mThe New Database Landscape - Revealing Shifts and Charting the Next Horizon- 49mThe New Database Landscape - Revealing Shifts and Charting the Next Horizon
46mA Database DevOps Pipeline
50mBringing DevOps to the Database
36mUnlocking the Benefits of Database DevOps and Automation