Post reply

Tasks of Senior SQL Server Experts/Data Scientists

  • May 9, 2019 at 12:21 pm

    #3638984

    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

    I want to be the very best
    Like no one ever was

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

  • May 9, 2019 at 1:47 pm

    #3639059

    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.

    Change is inevitable... Change for the better is not.

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

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

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