June 21, 2013 at 3:54 pm
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
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
June 23, 2013 at 12:35 am
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
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
Change is inevitable... Change for the better is not.
June 24, 2013 at 8:53 am
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