Tasks of Senior SQL Server Experts/Data Scientists

  • ktflash

    Ten Centuries

    Points: 1016

    Ahoi,

    i have started working with SQL for a year now. Ive managed to get along at work.

    My work includes:

    - SSIS ( ETL soley using TSQL)

    --SSAS

    --Backups (Ola Hallengren)

     

    I am far from being an expert in what i am currently doing, but as i said i am getting along.

    Not that there are tasks that couldn't be complex within this workload, but what is there outside of these tasks that more experienced people (seniors/data scientists/...)  within the sql server business are working on.

     

    I am asking for 2 reasons:

    - Curiosity

    - I like reading about this kind of stuff in my free time and i would like to take a peek into these kind of topics

     

     

    Thanks

    Trying to improve

  • Jeff Moden

    SSC Guru

    Points: 994555

    The four biggees (there are certainly more) that I can think of are...

    1. Practice doing restores and setup something to do restores "under the gun" for when something goes wrong.  As a wise man once said, you shouldn't have a backup plan... you should have a restore plan.
    2. Learn how to find and fix code performance/resource usage problems.  IMHO, 99% of all issues will manifest themselves in code.  Performance is in the code... or not. 😀
    3. Learn how current "Best Practices" index maintenance and usage may actually be causing more issues than they fix and what to do about it.  This goes right along with item 2 above.
    4. Learn how to be auto-magically alerted for blocking issues.

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

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

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