SQL Server 2008 Administration in Action (Paperback)

Rod Colledge

ISBN 10: 193398872X / ISBN 13: 9781933988726

Published by Manning Publications, New York, 2009

About this Item

Paperback. SQL Server 2008 Administration isn't a standard SQL Server tutorial-there are dozens of those to choose from. Instead, this book breaks down the role of "SQL Server Administrator" into its key focus areas and tasks and details the techniques and best practices that make an administrator effective. In this book, a reader can quickly identify a task and find the best practice associated with it. For example, a reader looking for information about indexing would find step-by-step procedures for identifying and dropping unused indexes, creating missing indexes, selecting the appropriate clustered index, and so forth. Each technique is presented in a clear, straightforward style and in the order of the typical lifecycle of a SQL Server system. This allows a reader to easily open the book at the appropriate page and focus on what you need to know for each specific situation. While most techniques will work for all versions of SQL Server, this book is current for the recent final release of SQL Server 2008. This book presents over 100 hard-won insights that will help a SQL Server administrator tackle tasks from the everyday to the exceptional. Packed with checklists, procedures, and organizational strategies, this book condenses the wisdom of a community into a concise, easy-to-follow, desk reference. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

Seller Inventory # 9781933988726

Bibliographic Details

• Title: SQL Server 2008 Administration in Action (Paperback)
• Publisher: Manning Publications, New York
• Publication Date: 2009
• Language: English
• ISBN 10: 193398872X
• ISBN 13: 9781933988726
• Binding: Paperback
• Condition: new

About this title

Synopsis

SQL Server 2008 Administration isn't a standard SQL Server tutorial-thereare dozens of those to choose from. Instead, this book breaks down the role of"SQL Server Administrator" into its key focus areas and tasks and details thetechniques and best practices that make an administrator effective.In this book, a reader can quickly identify a task and find the best practiceassociated with it. For example, a reader looking for information about indexingwould find step-by-step procedures for identifying and dropping unusedindexes, creating missing indexes, selecting the appropriate clustered index,and so forth.

Each technique is presented in a clear, straightforward style and in the order ofthe typical lifecycle of a SQL Server system. This allows a reader to easily openthe book at the appropriate page and focus on what you need to know for eachspecific situation.

While most techniques will work for all versions of SQL Server, this book is currentfor the recent final release of SQL Server 2008.

Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

About the Author

Rod Colledge is an independent SQL Server consultant based in Brisbane, Australia. Since 1996, Rod has specialized in the development and administration of SQL Server database systems. His recent work has included the design and implementation of custom transactional replication and log shipping solutions,performance tuning large high-volume databases, and developing procedures for operational maintenance of large database systems. In September 2007, Rod founded sqlCrunch.com, a website specializing in summarizing and categorizing links to SQL Server white papers and best practices.