SQLSaturday Cape Town 2018 Precon- Database DevOps – a crash course! with Alex Yates

Fri Sep 7, 08:30 - Fri Sep 7, 16:30

The River Club


Database DevOps – a crash course!

Deploying database changes, for many of us, is horrible. It’s often a manual, time-consuming and error-prone process. When it goes wrong, and it often does, the consequences can be serious. The DevOps, Continuous Delivery and Application Lifecycle Management (ALM) movements have revolutionised our ability to deliver software regularly and reliably. Unfortunately, many of us have not adopted the associated practices for our databases. There are, however, tools and techniques (technical and cultural) to implement Database DevOps/Database Lifecycle Management (DLM), allowing us to manage SQL changes efficiently and safely.

Who is this course for?
DevOps is about bringing dev and ops folk closer together, so this course is relevant whether you are a developer, a DBA or anyone else who plays a role in writing, testing or deploying SQL Server schema and data changes.

Course content
  •          Introduction to Database DevOps/DLM and an overview of the different tools that are available
  •          Discussion about the different approaches: model vs migration / shared dev DB vs dedicated dev DBs
  •          HANDS-ON LAB: Source control a database using Git, VSTS/TFS and ReadyRoll
  •          HANDS-ON LAB: Working with static data
  •          Introduction to continuous integration
  •          HANDS-ON LAB: Automating builds with VSTS/TFS and ReadyRoll
  •          Introduction to continuous integration
  •          HANDS-ON LAB: Continuous delivery to an integration database
  •          HANDS-ON LAB: Production-ready automated releases (automation while keeping DBAs happy)
What to bring
Bring a laptop. Further details regarding prerequisites will be provided nearer the time.