
Pro SQL Server 2008 Administration
APress
Published on 27. August 2009
Book
Paperback/Softback
XXIV, 592 pages
978-1-4302-2373-3 (ISBN)
Description
Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server.
- Introduces new administration features of SQL Server 2008
- Shows how to manage a SQL Server 2008 database at professional level
- Provides guidance on performance optimization
More details
Edition
1st ed.
Language
English
Place of publication
Berkeley
United States
Target group
Popular/general
Illustrations
XXIV, 592 p.
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 31 mm
Weight
1097 gr
ISBN-13
978-1-4302-2373-3 (9781430223733)
DOI
10.1007/978-1-4302-2374-0
Schweitzer Classification
Other editions
Additional editions

Ken Simmons | Sylvester Carstarphen
Pro SQL Server 2008 Administration
E-Book
10/2009
APress
€46.00
Available for download
Persons
Ken Simmons is a database administrator and developer specializing in Microsoft SQL Server and .NET. He is currently working with a global electronic payment service provider in Columbus, Georgia. He has been working in the IT industry since 2000 and holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005. Ken is highly active in the online community and often participates in the SQL forums on MSDN and SQLServerCentral. He enjoys sharing tips that he discovers by writing articles for SQLServerCentral and MSSQLTips.com. He has also formed an SQL Server Users Group in Columbus, Georgia, for SQL Server professionals to come together to share knowledge and resources. When he is not working, Ken enjoys traveling with his wife, Susan, and son, Nathan, and can often be found on a cruise ship, at a Disney resort, or at the beach in his hometown of Pensacola, Florida.
Content
Introducing Microsoft SQL Server 2008.- New Feature Overview.- Pre-Installation Considerations.- Choosing a High-Availability Solution.- Getting Started.- Installing Microsoft SQL Server 2008.- Upgrading to Microsoft SQL Server 2008.- Post-Installation.- Administering Microsoft SQL Server 2008.- Multi-Server Administration.- Managing Security Within the Database Engine.- Administering Database Objects.- Indexing for Performance.- Managing Backups.- Restore and Recovery Strategies.- Automating Routine Maintenance.- Troubleshooting and Tuning.- Monitoring Your Server.- Auditing SQL Server.- Managing Query Performance.- Conclusion.- Secrets to Excelling As a Professional DBA.- What's Next?.