Pitfalls with SQL rollbacks and automated database deployments

While it’s possible to perform SQL rollbacks to revert database changes, the question is, should you? Rolling back a database change isn’t as straightforward as rolling back a code change. Databases are the lifeblood of applications. An unsuccessful rollback can result in bad or deleted data. This article goes through the pitfalls which result... Read more

Octopus Deploy

6 April 2020

Octopus Deploy

6 April 2020

Designing an automated database deployment process: case study

In my previous article, How to design an automated database deployment process, I wrote about the steps companies and organizations should take to introduce automation to their database deployments. In this article, I’m going talk about the challenges I faced when I embarked on my own automation journey. Prior to joining Octopus Deploy, I... Read more

Andrea Giardina

24 March 2020

Andrea Giardina

24 March 2020

How PASS won the DBTA Database DevOps Innovation Award for fully automating their database deployments

On March 2, DBTA announced PASS as the winner of its inaugural Database DevOps Innovation Award. Redgate is extremely pleased with the news because we’ve really enjoyed working with PASS, and their team really deserves this recognition for what they’ve achieved since 2018. The journey at PASS to a streamlined database change process provides... Read more

Philip Liddell

19 March 2020

Philip Liddell

19 March 2020

Timestamps and Repeatable Migrations

In Flyway 6.3.0 we introduced a new feature. The ability to use the ${flyway:timestamp} placeholder (See Placeholders for more details). This placeholder will insert the current date in the format yyyy-MM-dd HH:mm:ss as its value. Now, this has some very obvious uses such as storing the date a migration was executed into your database. However, there is something more complex... Read more

Annabel Bradford

19 March 2020

Annabel Bradford

19 March 2020

There’s no place like home to join us at Redgate Streamed

Redgate is closely monitoring developments related to the COVID-19 outbreak and has already put in place measures to ensure the safety of our employees while still fully supporting our customers. We back the decision many conference organisers have made, by postponing their events until later in the year or switching them to virtual events.... Read more

Jeremiah Peschka

10 March 2020

Jeremiah Peschka

10 March 2020

Key actions to take with your monitoring system in preparation for COVID-19

You may think of monitoring as helping you optimize your server performance and ensure availability, particularly in times of technical crisis. But did you know, monitoring helps your teams work together in times of human-based crisis as well. Organizations everywhere are taking action to ensure business continuity and to minimize customer impact, whether employees... Read more

Kendra Little

10 March 2020

Kendra Little

10 March 2020

How Database DevOps can support remote working in the age of Coronavirus

As cases of COVID-19 spread worldwide and concerns mount, organizations everywhere are responding with efforts to maintain the flow of business while keeping employees and their families safe. Development and IT teams everywhere are either validating that their team may effectively work from home or have already moved to a full-time working-from-home policy. Teams... Read more