Post reply

urgent

  • December 20, 2018 at 4:08 pm

    #382499

    Hi i'm new here and i want to study sql server administration. I will be happy to receive your help and advices.

  • December 20, 2018 at 10:30 pm

    #2017011

    Welcome.  I suggest that you first download a free copy of SQL Server 2016 or 2017 Developers Edition, install it on your computer, buy a book on the subject and study it.  Then ask questions about things that you're read about and tried but still don't understand.

    Also, you might want to lose the word "urgent" to get people's attention.  All you're going to do is piss people off with that word.  Things are usually "urgent" because someone hasn't studied or planned.

    --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)

  • December 21, 2018 at 1:42 am

    #2017022

    Thanks..

  • January 2, 2019 at 8:28 am

    #2017746

    Jeff Moden - Thursday, December 20, 2018 10:30 PM

    Also, you might want to lose the word "urgent" to get people's attention.  All you're going to do is piss people off with that word.  Things are usually "urgent" because someone hasn't studied or planned.

    Or something is literally on fire.

    Also, take advantage of the Stairways series here on SSC. Look in the upper left side of the screen here and you'll see a link to the collection. Find the intro ones on T-SQL, and others. It's a great, free, learning resource. This is in addition to what Jeff has already advised.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • January 2, 2019 at 9:18 am

    #2017755

    And it it doesn't "piss someone off" it is a quick way to get ignored for a few days.

  • January 2, 2019 at 4:49 pm

    #2017813

    Hi my friend, 

    I was in your shoes 1 year ago and just studying is not going to help. Try to setup lab or please practice and practice.  
    Let me tell you I am not a senior DBA but understand and want to help.

    Simple things you can do is :
    1. Understand sql server architecture.. 
    2. Create maintenance plans 
    3. Setup log shipping ( it is simple) 
    4. Create alerts for jobs which your maintenance plan is going to run. 
    5. Reason your learning why there is separate error log for sql server and for sql agent?
    6. What are different type of alerts sev 16....20 etc. 
    7. Please buy a book to learn T-sql (T-SQL FundamentalsBook by Itzik Ben-Gan). I feel this is good book for t-sql.  When you fire T-sql what is the first step that is executed is it select or something else. Have a clear map and then build on it. 
    8. Understand when you fire a sql query what happens...( I know it is deep) but have a general idea.
    9. Try to analyze your error log, learn troubleshooting. 
    10. Practice, practice and practice. 
    11. List is long but these are couple of simple things which I did and it helped me.

    SQL stairways are just beautiful 🙂 

    Please do not be a stranger to SSIS or SSRS, they will be on your table on day. Please make a plan to learn them as well.

    I am learning everyday like you .

    Thanks and happy new year!

  • January 3, 2019 at 5:28 am

    #2017838

    sizal0234 - Wednesday, January 2, 2019 4:49 PM

    Hi my friend, 

    I was in your shoes 1 year ago and just studying is not going to help. Try to setup lab or please practice and practice.  
    Let me tell you I am not a senior DBA but understand and want to help.

    Simple things you can do is :
    1. Understand sql server architecture.. 
    2. Create maintenance plans 
    3. Setup log shipping ( it is simple) 
    4. Create alerts for jobs which your maintenance plan is going to run. 
    5. Reason your learning why there is separate error log for sql server and for sql agent?
    6. What are different type of alerts sev 16....20 etc. 
    7. Please buy a book to learn T-sql (T-SQL FundamentalsBook by Itzik Ben-Gan). I feel this is good book for t-sql.  When you fire T-sql what is the first step that is executed is it select or something else. Have a clear map and then build on it. 
    8. Understand when you fire a sql query what happens...( I know it is deep) but have a general idea.
    9. Try to analyze your error log, learn troubleshooting. 
    10. Practice, practice and practice. 
    11. List is long but these are couple of simple things which I did and it helped me.

    SQL stairways are just beautiful 🙂 

    Please do not be a stranger to SSIS or SSRS, they will be on your table on day. Please make a plan to learn them as well.

    I am learning everyday like you .

    Thanks and happy new year!

    Just wanted to say, nice, helpful, clear post. Love to see newer people picking up the baton and moving forward. Keep up the good work.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • January 3, 2019 at 7:42 am

    #2017862

    Grant Fritchey - Thursday, January 3, 2019 5:28 AM

    sizal0234 - Wednesday, January 2, 2019 4:49 PM

    Hi my friend, 

    I was in your shoes 1 year ago and just studying is not going to help. Try to setup lab or please practice and practice.  
    Let me tell you I am not a senior DBA but understand and want to help.

    Simple things you can do is :
    1. Understand sql server architecture.. 
    2. Create maintenance plans 
    3. Setup log shipping ( it is simple) 
    4. Create alerts for jobs which your maintenance plan is going to run. 
    5. Reason your learning why there is separate error log for sql server and for sql agent?
    6. What are different type of alerts sev 16....20 etc. 
    7. Please buy a book to learn T-sql (T-SQL FundamentalsBook by Itzik Ben-Gan). I feel this is good book for t-sql.  When you fire T-sql what is the first step that is executed is it select or something else. Have a clear map and then build on it. 
    8. Understand when you fire a sql query what happens...( I know it is deep) but have a general idea.
    9. Try to analyze your error log, learn troubleshooting. 
    10. Practice, practice and practice. 
    11. List is long but these are couple of simple things which I did and it helped me.

    SQL stairways are just beautiful 🙂 

    Please do not be a stranger to SSIS or SSRS, they will be on your table on day. Please make a plan to learn them as well.

    I am learning everyday like you .

    Thanks and happy new year!

    Just wanted to say, nice, helpful, clear post. Love to see newer people picking up the baton and moving forward. Keep up the good work.

    I agree with Grant (as always), good to see helpful posts like this one.
    😎
    I've got one more suggestion to add to the list, start answering questions on the SQLServerCentral forums, pick a question every day, research it and post the answer. This will be worth more than any course, book or self made up exercise as the questions are real problems, which would be hard to dream up unless you are in the middle of it. Further, if the answers are incorrect, they will be corrected.

Viewing 8 posts - 1 through 7 (of 7 total)

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