The Great DBA Series : The Advocate

    By: Jeffrey Ross Garbus on Oct 01, 2013

    What’s wrong with the database? It’s a common question that occurs in most places I have entered into and I have heard it way too often. When an issue with an application occurs the first question is “What’s wrong with the database?” The dbms becomes an easy target for developers to use against an ailing system often because it's the part of the system they least understand (and perhaps sometimes because the developers outnumber the DBAs). Often the question comes from developers, and I’m sure ego has a little bit to do with it; there cannot possibly be anything wrong with their perfectly tested code. But often, the issues arise from lack of familiarity with scripting, coding, or indexing for the particular database platform.

    Several years ago I got to spend time with an internet startup and became part of its database operations. This company and its DBA’s spent the vast majority of their time putting out fires, most of which were related to issues caused by deployments. This company, like many of its type, was very fast paced and development oriented. As a consequence, the multiple development teams were rapidly creating new functionality on a daily basis. The expectation from the managers and the developers was that DBA’s would implement their changes as soon as the changes were “ready.” The faster these new features were deployed the better the situation would be for the application and the company.

    However, the company had grown significantly between the time it started and the time I came onboard. The database backend had also grown in size and complexity. The problem was, there was no input in the development and the deployment of the changes with anyone from the DBA team. The status quo became a vicious cycle.

    Login to read the article. Not a member? Create a free account!

    Released: October 1, 2013, 9:55 am | Updated: January 27, 2014, 6:18 pm
    Keywords: ASE DBA Article | Technical Journal | Alvin Chang | ASE | Data Management | DBA | Jeff Garbus | Lyle Fernquist


     

     

    TwitterLLinkedinLFacebook

    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk