Redgate Intros New
March 27, 2020
development and release cycles, coupled with the inability to respond
quickly to changing business requirements, are prompting companies to
ditch siloed database development in favor of Database DevOps, according
to the latest research from Redgate Software’s 2020 State of Database
DevOps Report. As priorities shift and companies deploy database changes
weekly or more frequently, Redgate’s new SQL Monitor now ensures that
DevOps teams can monitor and track deployments at all times.
The desire to make the most of DevOps is encouraging companies to
automate deployments to make them reliable, repeatable and consistent.
This increasing pace of deployments, however, comes at a price. A deeper
dive into the 2020 report shows that errors are creeping into the
development process in the rush to release faster. Redgate first
recognized issues arising in 2019, when the percentage of companies
planning to automate database deployments within a year increased to 52%
compared to 45% in the 2018 report. This indicated that more than half
the users of Redgate’s own monitoring solution would need a way of
tracking deployments, regardless of which automation tool they used.
In response, the latest version of Redgate’s SQL Monitor offers a new
PowerShell API so that deployments from any third-party automation tool
like TeamCity, Bamboo or Octopus Deploy can appear as annotations on the
timeline graph for the server. Users can easily gauge whether their
deployments have had any adverse effect, and drill down in seconds to
the precise cause.
know that companies are adopting automated processes to help keep up
with the pace of innovation, which is why the new SQL Monitor release
enables them to deploy changes efficiently and find the root cause of a
problem fast before users are ever affected,” said Kendra Little, DevOps
advocate for Redgate Software. “We’re also seeing the real value of
Redgate’s Database DevOps Report in its ability to track these issues
over time. We can now see trends emerging, help identify where companies
could hit a snag in the database DevOps process, and address it quickly.
It’s like a customer feedback loop, incorporating data from over 5,000
participants over four years.”
Redgate’s 2020 Database DevOps
Report shows that while 37% of companies use a third-party monitoring
tool to alert them to deployment issues, another 37% still write their
own monitoring scripts, and 22% rely on their customers to alert them
when they have a problem. Additionally, the report found that some 30%
of respondents require hotfixes for more than one in ten deployments.
This is worrying when 66% of SMBs and 60% of enterprises say they will
have a fully automated database deployment process in place within a
year. Without effective monitoring in place, it risks errors requiring
hotfixes reaching production, and in more than one in five cases,
companies being unaware of them until customer complaints start rolling