The Great DBA Series [Part 1]

    By: Jeffrey Ross Garbus on Jan 02, 2013

    There are two kinds of people in the world; those who understand binary - and those who don’t. OK, those “two kinds of people” jokes were old when I started with this technology, back in the late ‘80s, but there really are at least two kinds of DBAs: Production DBAs and Development DBAs.

    In general, Production DBAs are responsible for making sure the system stays up, stable and in many places, scalable. In general, Development DBAs work with devel- opment teams to design databases, initially tune queries, scale systems, and perform initial predictive analysis. Depending on the company, the number of DBAs, and history there, possibilities certainly exist for overlap and shared responsibilities or the opposite, infrequently, a more adversarial relationship.

    This series of articles will cover everything from how to keep your server up and running to techniques for a Development DBA to constructively interactively with development teams to the importance of personal integrity as well as transactional integrity.

    In a respectful nod to our new friends who are moving their systems from Oracle to ASE environments, and may not have as much hands-on experience in that environment, we’re going to start this series with the production DBA tasks. We’re going to start with the list of things the ASE DBA needs to do (yes, there will be a lot of overlap with other DBMS), and in a subsequent set of articles discuss practical application of each task.

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

    Released: January 2, 2013, 6:30 pm | Updated: January 31, 2014, 9:33 pm
    Keywords: ASE DBA Article | Technical Journal | ASE | ASE DBA | Data Management | Data Security | Data Storage | Jeff Garbus | Performance & Tuning




    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