The Agile Database: Best Practices
Agile development is gaining mainstream adoption across the enterprise, resulting in shorter and shorter release cycles. It’s what the business is demanding in order to stay competitive. But while developers have benefited from new development tools, innovation for the database has lagged behind.
Read this white paper to learn what Agile means for database development, common challenges faced by DBA teams in the move towards Agile, and best practices DBAs can employ to support Agile workflows and increased velocity.
Database Source Control Enables Agile Applications
At Datical, we believe that database changes should be treated as tier-one artifacts in your release cycle. To truly achieve the necessary visibility and traceability into database changes such that they can be managed by the larger release process, it’s necessary to store those database changes in your version control system. Doing so makes the lives of the DBA team easier while simultaneously allowing them to provide more nimble support to application development. This, in turn, enhances the ability of IT to support the strategic needs of the business.
Extending Branch/Merge Strategy to Database Changes
Though you realize the benefits of Enterprise Agile, available tools and methods only address your application code. Changes to Application Schema still rely on SQL scripts, which are difficult to manage, require manual intervention during deployments, and increase uncertainty about the state of the Database. In this white paper you’ll learn how extending your existing branching and merging strategy to your database changes will allow you to release applications faster, avoid unnecessary deployment errors, and increase application quality.
The Path to Agile Application Releases
Companies are racing to adopt automation and dynamic environments to deliver applications faster, lower costs, and respond to constant change. They’re realigning their organizations, investing in tools and the strategic underpinnings required – Agile/Lean Development, DevOps, Cloud, Continuous Delivery, Big Data, and more. But, even with all of these innovations and investments, critical application release failures continue to exist for one simple reason - nothing has been done to improve database schema change delivery. This critical foundation of enterprise applications is virtually ignored.
Survival Kit - Technical eBook
Companion to The Path to Agile Application Releases, this eBook provides details about Datical's patent-pending data model approach for managing data structure specific content across application versions as they advance from Development to Test, Staging, and Production environments.
Datical DB Rules Engine - Policy-Based Management for Database Change Validation
Download this white paper to learn how you can:
- Automate SQL review using a safe and repeatable method, while remaining firmly in control
- Enforce your corporate, technical and regulatory database standards using rules customized for your organization
- Assess the impact of pending database changes before you deploy, with detailed reporting on policy violations and performance issues to assist troubleshooting efforts
- Reduce deployment risk and operating costs
- Support initiatives for increased release velocity, like Agile and Continuous Delivery
Download white paper
The DevOps Database
Database Change Management is a unique challenge when adopting an Agile development practice or implementing DevOps patterns. Developers design and author application schema changes based on the needs of the business. DBAs are on the hook for providing a secure and high performing data platform and protecting the integrity of the organization’s priceless data. In companies where these two groups are isolated, the goals of each can soon become opposed and forward progress can grind to a halt. This white paper explores Database Change Management using the "3 Ways" of DevOps - Applying systems thinking, Amplifying feedback loops, and Embracing a culture of continual experimentation and learning.
The Business Case for DevOps
DevOps has become quite the buzzword in IT over the past couple of years. But IT professionals are still working on figuring out exactly what “DevOps” is, and are consequently struggling to communicate the proposed benefits to the business, which in turn is what the business requires in order to trigger investment in new tools and processes. Regardless of where you are in your understanding, DevOps represents discontinuous innovation in software development, and for those companies willing to invest in new processes and tooling now, while the doctrine is still emerging, DevOps represents a sustainable competitive advantage for the business, and that’s something that any business leader will understand.
Infographic: The Cost of One Wrong Database Change
Results from an independent research study conducted by Simon Management Group reveal the hidden costs of manual database deployments.