作者:Rod Colledge
出版日期:August 28, 2009
出版社:Manning Publications
页数:468
ISBN:ISBN-10: 193398872X ISBN-13: 978-1933988726
文件格式:PDF
SQL Server 2008 Administration isn’t a standard SQL Servertutorial-there are dozens of those to choose from. Instead, this bookbreaks down the role of “SQL Server Administrator” into its key focusareas and tasks and details the techniques and best practices that makean administrator effective. In this book, a reader can quickly identifya task and find the best practice associated with it. For example, areader looking for information about indexing would find step-by-stepprocedures for identifying and dropping unused indexes, creatingmissing indexes, selecting the appropriate clustered index, and soforth.
Each technique is presented in a clear, straightforward style and inthe order of the typical lifecycle of a SQL Server system. This allowsa reader to easily open the book at the appropriate page and focus onwhat you need to know for each specific situation.
While most techniques will work for all versions of SQL Server, thisbook is current for the recent final release of SQL Server 2008.
About the Author
Rod Colledge is an independent SQL Server consultant based in Brisbane,Australia. Since 1996, Rod has specialized in the development andadministration of SQL Server database systems. His recent work hasincluded the design and implementation of custom transactionalreplication and log shipping solutions, performance tuning largehigh-volume databases, and developing procedures for operationalmaintenance of large database systems. In September 2007, Rod foundedsqlCrunch.com, a website specializing in summarizing and categorizinglinks to SQL Server white papers and best practices.