DC's Weblog

SQL Server 2005 Resources

Thanks very much to all who attended our SQL Server 2005 sessions at TechEd India 2006. I remember many attendees asking for the links on the resources slides of both sessions - so I thought it would be convenient to put it here. Cheers - DC

SQL Server 2005 – Operations
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx

Whitepapers
 Troubleshooting Performance Problems in SQL Server 2005
 http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
 Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005
 http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx
 Statistics Used by the Query Optimizer in SQL Server 2005
 http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx
 SQL Server 2000 I/O Basics
 http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

Webcasts
Troubleshooting Performance Problems In SQL Server 2005
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275646&EventCategory=5&culture=en-US&CountryCode=US
Performance Diagnosis in SQL Server 2005
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275586&EventCategory=5&culture=en-US&CountryCode=US
Suportability features for SQL Server 2005
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275593&EventCategory=5&culture=en-US&CountryCode=US

PASS 2005 PSS Service Center Labs
http://www.microsoft.com/downloads/details.aspx?FamilyID=9b8098a7-e75f-462a-b296-e80199c9f323&displaylang=en

Blogs
SQLCAT: http://blogs.msdn.com/sqlcat
WINCAT: http://blogs.msdn.com/wincat
Slava Oks’ blog: http://blogs.msdn.com/slavao

Product Feedback
http://lab.msdn.microsoft.com/productfeedback/

External Links:
NUMA FAQ: http://lse.sourceforge.net/numa/faq

Books:
Inside Microsoft SQL Server 2005: Query Processing and Optimization (Vol 3)
The Guru's Guide to SQL Server Architecture and Internals (SQL Server 2000)