Dear Past Me on My First Day as a DBA

  • Pam Mooney

    SSC Veteran

    Points: 220

    Comments posted to this topic are about the item Dear Past Me on My First Day as a DBA

  • This was removed by the editor as SPAM

  • Cebisa

    SSC Enthusiast

    Points: 112

    Thank you for this well written article.

    I like your links. I have to say that the longer you work with databases, the more likely you will overlook the application front end. Even a short overview of what you are supporting makes a difference.

    You definitely do work with all departments in the company, which is an aspect of the job that I like.

    I find code review always a little tricky. Keep inind that you are not out to find fault in someone's code, but bridging a gap and learning together.

  • pamelamooney1966

    SSC Veteran

    Points: 271

    Hi Cebisa,

    I am glad you enjoyed the article, and agree completely with your point on code review.  In fact, I think that viewpoint applies to incident resolution, change management, and other areas of our job.  Assigning fault is not nearly as productive as resolving the issue at hand and learning from it.  My boss tells the story of a woman he trained to be his clerical assistant many years ago.  The woman made an error that cost hundreds of dollars, and expected to be fired for it.  He said, "Why would I fire you?  I just spent hundreds of dollars to train you not to do that!"  I love that story, and thought it was a great testament to why he is a great manager.

  • dgosh1

    Newbie

    Points: 9

    Thank you Pamela.  Excellent article.  I found it very helpful and encouraging.

  • pamelamooney1966

    SSC Veteran

    Points: 271

    @dgosh1 - I am glad you did!  Are you new to the field?

  • Jeff Moden

    SSC Guru

    Points: 997336

    Cebisa wrote:

    You definitely do work with all departments in the company, which is an aspect of the job that I like.

    Heh... when I first heard of "DevOps", my thought was "Where the hell have you people been?  DBAs have been doing this for decades." 😀

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • shane.green 1227

    SSC Enthusiast

    Points: 161

    Thank you for a great article - although the internet wasn't the same 20 years ago when I started....

    I have had the fortune and/or misfortune to be the sole Database Designer, Developer, and Operational DBA for most of that time.  The biggest thing that I would like to tell my past self would be "go to the meetings with other professionals".  The bit that is quite often missing is the professional peer review of the design phase (a lot of places don't have multiple DBAs working for them unless they are big) - like with everything "there are multiple ways to skin a cat" and what works for one solution may not for another.

    The other thing is to learn the differences between database systems - the solutions don't necessarily translate well and just cause it work well in SQL Server doesn't mean that it will work well in Oracle or Postgres.  This bit is especially important when understanding "transaction boundaries" between systems.

  • pamelamooney1966

    SSC Veteran

    Points: 271

    @shane.green 1227 - I agree entirely, and I know I need to learn more about the differences between the systems myself!

  • krivera 53070

    SSC Rookie

    Points: 38

    Pamela, thank you for your "DBA in Training" series. They are both inspiring and practical. The links you include have proven to be excellent resources; and I have made a dedicated bookmarks folder to keep them handy.

    I've been in IT for over 20 years, but sitting in an SDA's chair since 2018. Your description of what that feels like is right on target. It's reassuring to know that the database profession is still developing, and explains why I've had such a hard time finding a linear path to success. By contrast, the OSI model of computer networking, along with server and hardware maintenance seem so concrete to me, compared to the abstractions of SQL.

  • pamelamooney1966

    SSC Veteran

    Points: 271

    Thank you for making my day!  I am glad to know that they are helping.  This is a subject that is near and dear to me - helping people, especially those trying to break in or who are just starting.  I hope you will keep reading - there is more to come.

     

Viewing 11 posts - 1 through 11 (of 11 total)

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