DevOps approaches are often used for Application deployments, but we see that the Database is still being manually deployed and often very late at night by tired DBA's.
You can leverage Octopus Deploy & tools such as DBUp to automate these deployments so that they can be deployed with the application automatically or even ahead of time.
In this session, Derek will cover topics such as rollbacks vs rolling forward, zero-downtime database deployments and also talk about how to ensure that a DBA can have a chance to review changes before they run in Production and allow them to have a bit more sleep than they are used to.
We will also cover how to use Octopus to back up & restore copies of the database, randomizing data, running SQL maintenance tasks and running SQL administration tasks using Octopus Runbooks.
Derek has worked across the world in London, Melbourne, Singapore and now from home in Glasgow, Scotland, for Octopus Deploy as a CI/CD Architect in the Customer Success team. Derek works with and helps Octopus Deploy’s biggest clients with their CI/CD pipeline and helps enable their success with Octopus Deploy.
Derek’s passion is in automating ‘all of the things’. Professionally and personally he spends a lot of time automating home, personal and professional projects. Derek has been working in the DevOps and automation world for about 6 years using a mixture of different products deploying to On-Premise, AWS and Azure.