27 August,2013 by Jack Vamvas
Whenever I find a new SQL Server paper to read , I download , store in a folder and make time to study in-depth. There is endless amounts of SQL Server and database server management information – the key is to read everything, but keeping up to date on hardware and software development is a time-consuming task.
Occasionally I discover information which is valuable. It tends to be written well and explains concepts and processes in a succinct style. These 3 papers satisfy the criteria. I’ve read them all in-depth and they are worth the effort
Download and enjoy reading them
Performance Tuning Guidelines for Windows Server 2008 R2 - Important information for tuning Windows 2008 R2. Invaluable for understanding and communicating server administrators
Diagnosing and Resolving latch Contention on SQL Server - Focused on high concurrency applications and the SQLCAT methodology for resolving page latching issues
SQL Server 2012 Upgrade Technical Guide - if you can only read one guide on upgrading to SQL Server 2012 – read this guide. The breadth and level of detail is top-class , covering almost every aspect required for a DBA to consider. Even if you're not doing an upgrade , it's worth the knowledge you'll access