Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

SQL etc

Posted May 15, 2003

DBA Call to Action: Make an Impact - Page 2

By James Koopmann

Take Ownership of Your Database

There is mass confusion as to what DBAs are supposed to be doing. Not only do companies not recognize the need, they do not recognize what they should be asking of their DBA. Just because there is a database involved, people think that it requires a DBA, after all, a DBAs first name is DATABASE. This in itself gives DBAs great control of vital corporate information. As a DBA, you hold the keys to what is done and when it is done in the database. You are responsible for validating everything that is implemented and your job is on the line when things go south. You are responsible for who owns what pieces of data and who is able to see what pieces of data. You are responsible for determining when the best time for application changes to hit the production database is. You should be involved in the scheduling of when changes happen and when they will be ready. All eyes focus on you when something goes wrong. Let's start protecting our company's vast amounts of data.

Security is a hot topic today that begs for DBAs to take control. Do you as a DBA fully understand every method of connection to the database, all the users who are defined within your system and to what permissions they have access? Do you have mobile users? Do you have web access? You, as a DBA need to know all of the potential pitfalls and potential problems you may encounter when it comes to security. Can you trust all of your developers to be cautious and not mess with the production system or have you sufficiently locked down the accounts they use. There have been occasions when I didn't trust even myself to just "tool" around with a production system and you definitely should not trust anyone else to be completely safe. Data tampering will most likely happen from within the corporate walls and this alone should force you to lock down production databases.

Data Should Be Your Middle Name

Let's face it, databases are all about storing data and accessing it. Your main concern is to provide a mechanism that provides for safe storage and retrieval of company information. Along with this, is providing for the security and reliability that information will be there when needed. Do not get hung up on the way that anyone else does things. If you do, you may find yourself in a trap. Make sure you validate methods and provide solutions that work for your company.

Find a New Feature

Don't have enough to do yet? One of the things I like best is to find a new feature, either in the current release we are using in production or the next version that is on the horizon. The benefit you can give to your company is to research new features, determine what works, and then how to implement, if that new feature is going to bring easier administration, lower cost of ownership, improved performance, or just make people happier. I can pretty much date myself, but I can remember working for a shop way back when, and implementing SQL*NET. What an immediate impact this had on the company I was working for, even though they had been working with Oracle for a while and the previous DBA never knew or thought of turning on this feature. Take a chance and find something that will make a difference in the way others work. Just don't forget to tell someone the new feature is available and follow up on usage to safeguard your new baby as it grows. Make sure you are able to sell you new feature to management. Come up with a method to determine the savings that will be experienced using a new feature or piece of technology. This savings can range from actual monetary savings to having a more productive work environment.

Take Time for Yourself and Your Company Will Benefit

If you are not taking two to three hours a day to develop and maintain your advantage in the industry, you are not only hurting yourself, you are killing the company for which you are working. Just think, if you were asked to go to a meeting where you were put on the line to provide insight into the progress of your particular platform along side of any new technology. Would you be ready and able to talk intelligently? If you are under the gun every day, day in and day out, trying to fight fires and are constantly being pulled in all directions, you need to find a way to hide yourself for at least one hour initially. You need to find a way to convince your management that the future is just as important as the current day's disaster. If you cannot seem to get quiet time around the office, have your management ok it for you to attend a user group or vendor technical sessions. These are typically only a day and most are just a few hours. This allows you to get up to speed quickly on new technology without having to search the net for it or continually being interrupted during your enrichment hour.

Are You Stuck

If you are unable to foster change within your company, by all means, do it outside your company. If there is one thing that I have learned, it is that there are lot more companies than the one I am working for and, along with myself, there are hundreds of people that need assistance in solving problems. Go out there and hit newsgroups, magazines, conferences, local user groups or wherever you find database issues; contribute to the cause and complexity of providing solutions to the mass of data management issues that surround us. The worst thing that can happen is that you will have fun, gain knowledge and begin a few relationships that are always important to anyone truly concerned with making an impact.

» See All Articles by Columnist James Koopmann

SQL etc Archives

Latest Forum Threads
SQL etc Forum
Topic By Replies Updated
MySQL rollback UAL225 0 August 21st, 09:56 PM
Complex Search Query Galway 0 May 20th, 10:04 PM
change collation at once supercain 2 May 15th, 06:18 AM
SQL Features, tools and utilities question Neomite 1 April 10th, 09:13 AM