I’ve just delivered a session for Redgate’s SQL in the City Streamed conference. The recording is here:
In the session I describe fifteen database DevOps anti-patterns:
- Fear every change
- Wait until you are already screwed
- Build a tangled web of databases
- Customize each production instance
- Don’t use a standard source control process
- Impose new process on underlings
- Don’t provide any training
- Use the wrong model/migration approach
- Hot-fix all the problems in production
- Don’t use branching or tagging
- Use branches to solve every problem
- Re-invent the wheel
- Have a functional stand-off
- Create a DevOps teams/role
- Give up.
The slides are here:
I referenced various blog posts, docs pages and videos during my talk. Here’s a list:
- From 20 to 2 million releases a year, Alistair Hann (t)
- Deploying cross-database dependencies to different environments, Chris Heppell and Peter Gerrard
- How to build multiple database versions from the same source: object filters, Alex Yates (b|t)
- How Redgate Helped Define Our Process, Bob Walker (b|t)
- TPS Reports scene from Office Space (1999), Twentieth Century Fox (imdb)
- Octopus Deploy documentation: SQL Server Databases, Paul Stovell (b|t)
- Declarative Database Development, Gert Drapers (b|t)
- Critiquing two different approaches to delivering databases: Migrations vs state, Alex Yates (b|t)
- A successful Git branching model, Vincent Driessen (b|t)
- DevOps Topologies, Matthew Skelton (b|t)
Other talks I’ve delivered
- DevOps 101 for data professionals – how your jobs will change
- Database version control and deployment – model or migration scripts
- Getting CI right for SQL Server
- My full speaker schedule
The self promotion bit
If you are looking for database DevOps training or consultancy my company, DLM Consultants, can probably help. We offer on-site consultancy as well as online workshops. Our full public workshops schedule is here.
To read more about our services or to contact us head to www.dlmconsultants.com.