An interesting question came up at the Redgate Summit a few weeks ago: What approach do you take to maintain database releases/changes in-flight that haven’t been applied to Production after them being wiped out after a database refresh? I have to assume that the person asking this question has not taken even the first... Read more
In 2020, Deloitte reported on The four trends that define insurance and showed that the future of the insurance marketplace is going to be significantly different. Life and Property and Casualty insurers, for example, estimated that 93% of their volume already came from propositions that were not offered five years ago. New propositions were... Read more
Flyway can validate your migrations according to its own conventions, giving you the confidence you need to apply new migrations. However, as the lifetime of a project increases, there will inevitably be hotfixes, deleted migrations and other changes that break the conventions of Flyway’s validation. In these cases you need a way to tell... Read more
“It worked on my machine“. You’ve likely either heard this from a colleague or thought this yourself when a Flyway migration failed during a production deployment. The fact is that unfortunately, bad migrations slip through to the release process despite our best efforts. Thankfully, there are solutions to this – testing your Flyway migrations... Read more
The ultimate goal for automating deployments can be the hands-free deployment of all code, including the database, from development to production. However, for many of us, the complete automation of all deployments with zero manual intervention will always remain a goal. We may have systems that are simply too complex for a 100% automated... Read more
My blog post from February 1 explains that Redgate took the opportunity to purchase the assets of PASS with the main goal of supporting the community. The PASS association ran for 21 years bringing together a community to connect, share, and learn. The community of course lives on, however the association no longer exists... Read more
This question was raised at the recent Redgate Summit: How does the implementation of a microservices architecture affect the implementation of a database DevOps approach? I could even rephrase it a little: Does a microservices architecture affect a database DevOps approach? Microservices is, or isn’t, one of the hot new trends, depending on how... Read more
I work in computers and my son works in manufacturing, but both of us loathe a single phrase: We have always done it this way. Please allow me to be clear on this. If you can back up this statement with “Because…”, and you list out valid points, even if I disagree with them,... Read more
When you begin to automate your deployments, you’re also going to start automating your testing. After all, a deployment, in and of itself, is a test. However, pretty quickly, you are going to come to the question that’s the title of this post: Who is responsible for building tests? I have two flippant answers... Read more
When I first started trying to figure out how to automate database deployments, over 15 years ago, I will freely admit, I was both skeptical and reluctant. I had to be dragged up to the notion that automating getting the database code out the door wasn’t just an excuse by the developers to find... Read more
