Welcome!

The DevOps Database

Pete Pickerill

Subscribe to Pete Pickerill: eMailAlertsEmail Alerts
Get Pete Pickerill via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories by Pete Pickerill

Recently, the Agile Austin DevOps SIG invited Datical to talk about the impact of DevOps practices on database change management. This was a great opportunity for us to talk to folks about our approach to managing application schema change in IT organizations that have moved or are moving to more responsive and agile planning, development, and delivery processes.  It was a lively discussion with some great feedback from the audience. In framing the discussion, I relied heavily on "The Three Ways" of DevOps.  The Three Ways are the principles that underpin the DevOps patterns that Gene Kim discusses in detail in his novel "The Phoenix Project" and in the"The DevOps Cookbook", written by John Allspaw, Patrick Debois, Damon Ewards, Jez Humble, Kim, Mike Orzen, & John Willis.  Here's a quick summary of The Three Ways: The First Way: Systems Thinking - This Way stresses... (more)

The DevOps Database | Part 3

In the third post in this series, I’d like to talk about the Second Way of DevOps: Amplifying Feedback Loops.  Here’s a refresher on The Second Way from my introductory post in this series: The Second Way: Amplify Feedback Loops – This Way deals primarily with facilitating easier and faster communication between all individuals in a DevOps organization.  The goals of this step are to foster better understanding of all internal and external customers in the process and to develop an accessible body of knowledge to replace the dependence on expertise scattered across individuals. ... (more)

SMG Research Reveals DBA Tools Not Effective for Managing Database Change

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 ... (more)

The Advantages of a Model-Based Approach

The vast majority of schema management today is handled through the generation, review, and execution of SQL scripts.  These scripts can be tiny or huge; they can encapsulate the creation and relationships of several objects or they can describe a one-time alteration to a single object.  Once executed they generally leave no history of their passing other than the presence of the pieces they create, delete or modify; you can be dependent on hundreds of small scripts or on one giant script to build out new environments or evaluate existing ones.  You’re left with a schema that is ... (more)

Agile Development for the Database By @Datical | @DevOpsSummit [#DevOps]

All too often, database development is an afterthought in Agile Development.  Developers perfect how best to implement a solution in code, but tend to spend too little time on representing that solution in the Database.  This is unfortunate, given that 65% of your change requests require changes to the application schema, according to independent research conducted by Simon Management Group.  This finding implies that Database changes are every bit as important as the Application Code, and should be treated as tier-one artifacts in your release process. At Datical, we typically ... (more)