Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2012-06-16 : 10:41:10
|
| Hi All,I am attending interviews for these days as a 5+ years of exp in SQL Server Dev.Most of the people are asking performance tuning level,about indexes,SQL profiler and some other advanced concepts.Frankly speaking i didnt get a choice to work in these concepts.moreover we dont have really such complex environment.but i have to change my job and i want to learn all these concepts.Please guide me how to learn?are there any books or links i can refer.Please help me in this.I really want to improve my skills as a senior developer.TIA. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-06-16 : 17:17:22
|
| Probably the best free resources for advanced SQL Server training are the MCM Readiness videos:http://www.sqlskills.com/T_MCMVideos.asphttp://technet.microsoft.com/en-us/sqlserver/ff977043.aspx (alternate link)There's also the MCM Readiness reading list: http://www.sqlskills.com/MCM.asp (also linked in the earlier SQLSkills link)Much of the material is geared towards administrators and architects, but that doesn't mean it's not beneficial to developers. There is a track for development in that list.I also highly recommend the SQLSkills Immersion events. They may seem expensive but the return on investment is excellent. You basically get Paul and Kimberly (and Jonathan and Joe and Bob) for $75/hour for an entire week, AND THEY TEACH YOU how to fix problems yourself using their knowledge and techniques. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-06-17 : 02:10:33
|
| Another good starting point is SQL Servers Books Online. The 2008 version is good. There's a lot of information to get you started. After you've understood the concepts - get some hands-on experience, which could be as simple as setting up a SQL Server on a laptop and applying the techniquesJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-06-17 : 03:19:47
|
| I HATE when people want to learn stuff only for getting through an interview or pass a certification.Only free men can negotiate.. |
|
|
|
learntsql
524 Posts |
Posted - 2012-06-18 : 03:00:00
|
| Thanks for your reply guys... |
|
|
|
|
|
|
SQL Advanced concepts help?