This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the application code. Read more
Join us this February for our Redgate Summit: The Future of Database DevOps, where you’ll discover the latest trends in DevOps, brand new insights from the 2021 State of Database DevOps report, an introduction and technical demos of Redgate’s solutions for database DevOps, and more. Who is it for? Redgate Summit is designed to... Read more
Sometimes, people start their DevOps journey by getting their database into source control, but then, they don’t deploy from source control. Instead, they continue their manual deployments to production. Quickly they find that the database code in their production instances and the database code in their source control system don’t match. Alternatively, you may... Read more
When it comes to deploying databases, one of many challenges that arises is dealing with your master data, lookup data, or sometimes even reference data. It’s those tables that store the lists of choices like a Suffix to a name such as Dr., or Ms. Or something else. In fact, during a recent panel... Read more
I think this is my single favorite question that came up at the recent panel discussion: How do you get DB folks who just go in and make changes to understand they need DevOps, source control, change management, etc.? There’s a lot to answer in this question, however, to keep this down to a... Read more
There were so many questions asked at a recent presentation that I just didn’t have time to answer them all. However, many of them were really interesting, so I promised to address them over time as blog posts. The next question is: I manage an ETL team that supports highly customized code for all... Read more
Another great question that I think I can try to answer: I always gets bogged down in the details and worry about doing it wrong and making a mess that is difficult to maintain. How do you deal with this? I’m doing a series of blog posts on the questions from a recent panel... Read more
The next question in this series of blog posts I want to tackle is: What’s the smallest recommended size of development team that can reasonably set up and manage a DevOps process? These questions all came from a panel discussion during PASS Summit. The audience interaction was amazing and we had so many great... Read more
I recently took part in a panel discussion at the PASS Virtual Summit 2020 entitled: Challenges to Implementing Database DevOps. The interaction with the attendees was stupendous. We received all sorts of questions. Most of them were answered during the event, but a few were not. I’m going to create a series of blog... Read more
Recently, I was lucky enough to co-host a webinar with James Phillips, VP of Corporate Technology at Mizuho, a leading global bank with a worldwide network of financial and business centers. He joined me to talk about how the bank had introduced database DevOps, why they did it, and the challenges they had along... Read more
