What’s the state of database DevOps adoption?

Traditional methods of developing and deploying software are being replaced by newer, more agile techniques such as DevOps.

The speed of business today affects every part of the organisation, and IT is no exception. That’s why traditional methods of developing and deploying software that split up the process into multiple teams and departments are being replaced by newer, more agile techniques such as DevOps. This removes silos to get people, process and tools working together to make the product delivery lifecycle faster and more predictive. 

DevOps is fundamentally changing the IT landscape – and that includes areas such as the database, which has often not been part of the traditional development model. New research that we recently carried out shows exactly how much of an impact it is having. Our global study of 1,000 organisations surveyed database professionals using SQL Server, ranging from C-level executives and IT directors/managers to database developers and administrators (DBAs). Half of them employed 500 people or more. The overall message was clear – DevOps is becoming mainstream, and more and more people see the database as central to the process.

We uncovered five key findings from the research:

DevOps is becoming the norm

Eighty per cent of respondents have either already adopted a DevOps approach (47 per cent of people) or plan to over the next two years (33 per cent). That left just 20 per cent saying they weren’t planning to change to DevOps in the next two years. The bigger the company, the more likely the organisation is to move to DevOps – 59 per cent of companies with over 1,000 employees had already switched to the methodology.

Potentially reflecting the competition in these markets, IT services and retail are leading the way when it comes to adoption, with over 50 per cent using DevOps now. They were followed by finance and healthcare, while organisations in government, manufacturing, education and the not for profit sectors lagged behind with less than 40 per cent of companies having moved to DevOps.

Skills are the greatest challenge

The greatest obstacle to moving to a DevOps way of working was a perceived lack of appropriate skills (cited by 21 per cent of respondents), ahead of a lack of alignment between the development and operations teams (20 per cent). Only 9 per cent said that their executive leadership didn’t support the shift. However, for those not planning to adopt DevOps 35 per cent of respondents said a lack of awareness of the business benefits was the greatest challenge.

When it came to integrating database changes into the DevOps process, consistency was top of the list of obstacles, with 32 per cent believing that synchronising application and database changes would be the biggest challenge, followed by overcoming different approaches to application and database development (25 per cent). 19 per cent said preserving and protecting business critical data would be an issue.

Companies are integrating applications and databases

The old picture of companies made up of silos of developers and database administrators that don’t work together is far from the truth. 58 per cent of companies said the integration between the two was either good (38 per cent) or great (20 per cent), meaning teams work together on either a planned or ad hoc basis. Just 12 per cent classed integration as poor, with DBAs working in silos. 

Whether they had adopted DevOps or not, three quarters (75 per cent) of companies had teams that included developers who were working across databases and applications, with just 25 per cent having dedicated database developers. In 60 per cent of companies developers were responsible for building database deployment scripts, compared to 35 per cent of DBAs, although in the majority (52 per cent) of organisations DBAs deployed database changes to production systems. 

Reducing risk key to moving to DevOps

When asked what the major challenges were with traditional database deployment practices, over a quarter (26 per cent) pointed to an increased risk of failed deployments or downtime when making changes. This was followed by slow development and deployment cycles and an inability to respond quickly to changing business requirements (both 18 per cent). 16 per cent cited poor visibility of the change management process as another issue. This shows the vital importance of fast, successful database changes and deployments to business today. 

For companies with 5,001-10,000 employees slow development and release cycles were seen to be more of a drawback than application downtime, while for organisations with more than 10,000 employees, the inability to respond quickly to changing business requirements is deemed to be a slightly more significant downside.

With DevOps providing a way of overcoming these issues, no wonder it is gaining traction so quickly. 26 per cent said the main driver for adopting it would be to increase the speed of delivery, while 17 per cent thought it would free up developers for more added value work. Comparing results from developers and DBAs did highlight some differences – developers wanted to be able to focus on added value work, while DBAs saw it as a way of reducing application downtime and to improve collaboration.

Practices are not consistent between the database and applications

Despite the levels of integration within organisations, there is still a gap between how companies operate and automate when it comes to applications and databases. For example, while 81 per cent of respondents use version control with their applications, just 58 per cent apply it to database development. Even amongst those who are most advanced with DevOps practices are not applied equally across both. While the majority of those who have adopted DevOps are doing issue tracking, continuous integration, test automation and automated deployment for their application code, only a fifth of respondents apply the same to their database development. Clearly, there is still more that can be done to bring the two together through common practices and use of third party tools. 

As our survey shows, applying DevOps across both applications and databases speeds up software delivery, frees developers to do more value-added work and increases the rate at which database changes are delivered. At a time when IT organisations need to be operating in a faster, more seamless manner to help companies to thrive in more competitive markets, it is time for everyone involved to find out more about how introducing DevOps can transform how they operate. What’s stopping you exploring database DevOps? To download the full management report on the research findings click here.

Matt Hilbert, Technology Writer, Redgate Software

ABOUT THE AUTHOR

Matt Hilbert is a technology writer at Redgate Software with 20 years’ experience working for lots of the world’s biggest tech companies – and many of the smallest.