Welcome!

Open Source Cloud Authors: Yeshim Deniz, Pat Romanski, Liz McMillan, Zakia Bouachraoui, William Schmarzo

Related Topics: SYS-CON MEDIA, Java IoT, Microservices Expo, Open Source Cloud, Agile Computing

SYS-CON MEDIA: News Item

SMG Research Reveals DBA Tools Not Effective for Managing Database Change

Database Schema Changes Rank High Among Contributing Factors

New research from Simon Management Group reveals that despite the high percentage of companies who use DBA tools, a majority of companies still struggle with database change and configuration management issues that impede the first-time success rate of business-critical application deployments.

Commissioned by Datical, Inc., the study examines the views of application development and deployment professionals in large organizations with $100 million or greater in IT department spending. The companies surveyed have similar characteristics including a large number of applications in use, frequent database application change requests per week, adoption of agile development methodologies, and greater variation in the skills of their SQL programmers.

Findings from the analysis of nearly 100 verified responses point to a number of key issues:

  • Multiple databases, platforms - On average, companies use three different types of databases with MS SQL Server and Oracle being the most common.
  • High number of applications and changes - Companies support an average of 183 applications and IT receives requests for database application changes about four times per day. 42 percent of change requests require in-depth database schema knowledge.
  • Lack of skills in-house - On average, it takes 70 developers to support these applications, and only 39 percent of those organizations believe their in-house SQL programming expertise is adequate enough to manually update the schema.
  • Dependencies and change velocity - Across the board, the pain caused by database application changes is highest for managing the velocity of changes and application dependencies.
  • Application failures - Companies average a 7 percent application failure rate, or 12 business critical failures per year.

However, the pain levels and types of change depend upon the use of agile development methodologies. Among 45 percent of companies using agile for development and test:

  • The pain among high agile users is greatest for velocity of changes, application dependency management and deployments that require manual intervention; whereas
  • The pain for low agile users is highest for managing dependencies, missing steps in documentation and scripts, and deployments that require manual intervention.

Two-thirds of the organizations surveyed report that using DBA tools do not mitigate these issues when updating the database schema.

"Large organizations still rely on manual scripting to implement a high volume of database changes - opening themselves up to risks and errors when deploying the very applications that drive revenue for their business," said Daniel Nelson, Datical CEO and co-founder. "By taking steps to eliminate manual scripting, automate and forecast the impact of change in production, these companies can reduce their risk, accelerate releases, speed time to market and cut cost."

 

More Stories By Pete Pickerill

Pete Pickerill is Vice President of Products and Co-founder of Datical. Pete is a software industry veteran who has built his career in Austin’s technology sector. Prior to co-founding Datical, he was employee number one at Phurnace Software and helped lead the company to a high profile acquisition by BMC Software, Inc. Pete has spent the majority of his career in successful startups and the companies that acquired them including Loop One (acquired by NeoPost Solutions), WholeSecurity (acquired by Symantec, Inc.) and Phurnace Software.

IoT & Smart Cities Stories
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand using interactive visualizations and salary indicator tools to maximize earning potential. Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team at D...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
Atmosera delivers modern cloud services that maximize the advantages of cloud-based infrastructures. Offering private, hybrid, and public cloud solutions, Atmosera works closely with customers to engineer, deploy, and operate cloud architectures with advanced services that deliver strategic business outcomes. Atmosera's expertise simplifies the process of cloud transformation and our 20+ years of experience managing complex IT environments provides our customers with the confidence and trust tha...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
AI and machine learning disruption for Enterprises started happening in the areas such as IT operations management (ITOPs) and Cloud management and SaaS apps. In 2019 CIOs will see disruptive solutions for Cloud & Devops, AI/ML driven IT Ops and Cloud Ops. Customers want AI-driven multi-cloud operations for monitoring, detection, prevention of disruptions. Disruptions cause revenue loss, unhappy users, impacts brand reputation etc.
The Japan External Trade Organization (JETRO) is a non-profit organization that provides business support services to companies expanding to Japan. With the support of JETRO's dedicated staff, clients can incorporate their business; receive visa, immigration, and HR support; find dedicated office space; identify local government subsidies; get tailored market studies; and more.
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. As they do so, IT professionals are also embr...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility.
Today's workforce is trading their cubicles and corporate desktops in favor of an any-location, any-device work style. And as digital natives make up more and more of the modern workforce, the appetite for user-friendly, cloud-based services grows. The center of work is shifting to the user and to the cloud. But managing a proliferation of SaaS, web, and mobile apps running on any number of clouds and devices is unwieldy and increases security risks. Steve Wilson, Citrix Vice President of Cloud,...
When Enterprises started adopting Hadoop-based Big Data environments over the last ten years, they were mainly on-premise deployments. Organizations would spin up and manage large Hadoop clusters, where they would funnel exabytes or petabytes of unstructured data.However, over the last few years the economics of maintaining this enormous infrastructure compared with the elastic scalability of viable cloud options has changed this equation. The growth of cloud storage, cloud-managed big data e...