Post reply

SQL Server T-SQL Boot Camp 3-5 days anywhere in the United States

  • June 21, 2013 at 3:54 pm

    #276635

    I have a team of coders that I need to train how to code better in SQL 2005 and 2008. Is there a Microsoft approved partner that anyone knows about that I can send 2-4 people to train them on coding? I don't want to send them to DBA courses, because they are simply coders. I just want to beef up their coding knowledge so we can improve performance, technique, and efficiency.

  • June 21, 2013 at 4:40 pm

    #1626524

    I suppose that you're searching for something different than the Microsoft course 2778

    http://www.microsoft.com/learning/en/us/course.aspx?ID=2778A#fbid=EN0FHZ0dEvf

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • June 23, 2013 at 12:35 am

    #1626590

    You might check with Paul Randal's company, SQL Skills. If they can't help you, I'm sure they could recommend someone.

  • June 23, 2013 at 5:32 pm

    #1626626

    SQL_Enthusiast (6/21/2013)

    I have a team of coders that I need to train how to code better in SQL 2005 and 2008. Is there a Microsoft approved partner that anyone knows about that I can send 2-4 people to train them on coding? I don't want to send them to DBA courses, because they are simply coders. I just want to beef up their coding knowledge so we can improve performance, technique, and efficiency.

    I don't know what your budget is but such training can get pretty expensive.

    The things that made me a better coder were things that made me understand how SQL Server works behind the scenes. The portal into that is learning how to read and understand execution plans and some in-depth knowlege of how indexes work behind the scenes. I learned a good portion of those things by reading Grant Fritchey's book on execution plans and by watching some of Kimberly Tripp's videos on how indexes work.

    Grant's Book - http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2

    My favorite "movie" on indexing - http://technet.microsoft.com/en-US/sqlserver/gg508879.aspx

    Of course, you also have to spend some time practicing or you won't remember any of it. 😀

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

  • June 24, 2013 at 8:53 am

    #1626809

    This is exactly what I was looking for. Thank you

Viewing 5 posts - 1 through 4 (of 4 total)

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