Tips for New DBAs

  • Lighten up Francis.

    LOL!

    Good stuff! Made my AM.

  • Ignacio A. Salom Rangel (2/12/2010)


    Great article!

    thanks, Ignacio!

    This is actually a repost.

    I've been surprised at the modest amount of success the article has enjoyed.

    It's mostly preaching to the choir, but it's news for people who never sang in a choir before 🙂

  • Great article, thanks!

    I would most emphatically add this to your excellent list:

    Learn Your Business

    It is impossible for you, as a DBA, to participate in discussions about data access, security, reliability, etc. if you don't understand what your company does, who your customers are (both internal and external), and the critical finances that drive your business. This is true whether you work for a small non-profit or a large corporation. It's true for government, education, and commerce.

    By learning your business, you will also make your life easier 🙂 You'll anticipate when those periodic crunches are going to be, when your databases will be hammered with updates, etc.

    Thanks again,

    Rich

  • Rich,

    That is brilliant!

    I will add that to a list of things to include in future revisions.

  • SQLBOT (2/12/2010)


    Rich,

    That is brilliant!

    I will add that to a list of things to include in future revisions.

    Thanks, Craig. I guess we've all worked at places where some or all of the IT staff doesn't really care about what the organization's core mission is: they wear their ignorance with scornful pride.

    No fun for anyone, and the organization suffers. If you aren't contributing to the success of the organization, what are you doing working there?

    Rich

  • Very good! I would go so far as to suggest that experienced DBA's should read this as well as new ones.

    It is sometimes easy to forget the basics of what we do and why.

  • Great article, lots of good discussion as well.

    As a contractor I've been hired to basically "firefight" the company's sql server problems and you do sometimes become the "Hero DBA" which like most positions of power can be quite seductive - you gain respect from your collegues; it builds your confidence and helps with the decision regarding your contract extension. 😉

    However the flip side is working with the Hero DBA who just loves to be called out in the middle of the night to rescue some failed backup and then loves to tell everyone about it. Then the same thing happens when he/she goes on holiday, no documentation and your left with the client wanting to know why their website has been down for over 24hrs! :w00t:

    Yes, documentation is the way to go - the geek in me even likes to produce it, how wrong is that. 😛

    In reply to blandy's post, I find it pays to have a paranoid attitude ALWAYS as a DBA - today you might be looking after all that widget data, however tomorrow you might just find that execellent SQL DBA post (with great holidays and medical dental, etc) at a missile building company or simply at a bank - start with good habits (CIA is certainly one them) and you'll go far in life...

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]
  • I apologize in advance for my comments (a little bit), and mean no insult directly at any DBA but...

    Do you ever take a moment and think about how many DBA's go to work every day and work with the most mundane data? Are you aware that not everyone is going to work at the CIA every day? Have ever thought about men and women who are DBAs or workers using SQL Server who count widgets day-in and day-out? This is something that just drives me nuts about some DBAs and some of the authors who and pretend that every byte of data in the world is somehow 'vital' and at risk.

    ...

    Sheesh!!! Ever wonder why the world is paranoid?

    ...again, sorry for the rant - but this has to be said in respect for hard working DBAs who are not working with James Bond and MI6 or the CIA.

    -------------------------------

    The problem is the field requires a dilligence to value and protect data as if ones own personal information were contained in the data.

  • When the data at your company reflects on the bottom line and helps define your business, then it is the most critical in the world. When it means protecting your job and excelling at what you do - it is the most critical data in the world.

    Would it be fun to work at a "spy" agency, maybe. Their data may not be all that interesting, and maybe it is.

    Nice re-print of the series. I have enjoyed reading it.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • It may be "widgets" that are stored in the database, but as long as the company is in the business of making them, or selling them, and thus tracking those sales, then the DBA's responsibility of maintaining that data, backing it up, and always making it available to everyone else in the company, and the IRS as well, than the role of the DBA cannot be minimized or under-estimated. A company's data is its life blood. Bottom line. Regardless of what content that data is. If it's not available or accurate on a daily basis see how fast the company's business comes to a halt. What do think would happen in this country if all the DBA's were unionized and went out on strike? Think that would be a little worse than a baseball or football strike? Like a mentor of mine once said "I don't care what data you are tracking, but make it unavailable for just 15 minutes and see how many angry phone calls you get." As long as this is the case, the DBA will always be one of the most important individuals in your company whether you want to realize it or not. 🙂

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"

  • ZETM (2/12/2010)


    This is something that just drives me nuts about some DBAs and some of the authors who and pretend that every byte of data in the world is somehow 'vital' and at risk.

    It's not that every byte of data is vital, but that you might not realize what is vital. I used to import wood for a living, well manage the systems for those guys. Our inventory was vital for that company. If a competitor got it, they could potentially mess with our supply chain, or make deals for customers. I wouldn't have thought it mattered, but it did to them once I dug in.

    Lots of data, like salaries, etc., isn't vital, but it doesn't necessarily need to be disclosed. As a result you should consider most of your data important and just secure it. It doesn't take a lot more effort, but it doesn't take much less to develop bad habits and have your data insecure.

    It's like SQL Injection. Your company's home page might not be a big deal. But if it gets hacked or injected, you can bet it will happen on the day that the President has just pointed someone to it. It won't kill the business, but it could kill your day (or job)

  • I think you should have read the article more carefully before ranting on about something so completely off the subject. A DBA that "protects" his data is not doing so against evil terrorist cells or alien invasion, but rather from user (internal or external) corruption, be it intentional or accidental. Next time take a deep breath and make sure you understand the message before venting.

  • Steve,

    I actually replied to someone's post putting part of their post in mine to illustrate my point which was:

    The problem is the field requires a dilligence to value and protect data as if ones own personal information were contained in the data.

  • Sorry, didn't realize that. Your post comes across differently.

  • Brings up an interesting point. I sometimes quote large texts from others to respond to and put a long dashed line beneath.

    I should have done a better job of pointing out my comments....!!

Viewing 15 posts - 46 through 60 (of 65 total)

You must be logged in to reply to this topic. Login to reply