Beginning SQL Server 2008 Administration

by Robert Walters, Grant Fritchey, Carmen Taglienti

Overview

Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing SQL Server 2008 database. From college students, to experienced database administrators from other platforms, to those already familiar with SQL Server and wanting to fill in some gaps of knowledge, this book will bring all readers up to speed on the enterprise platform Microsoft SQL Server 2008.

• Clearly describes relational database concepts
• Explains the SQL Server database engine and supporting tools
• Shows various database maintenance scenarios

Product Details

ISBN-13:	9781430224136
Publisher:	Apress
Publication date:	10/07/2009
Series:	Expert's Voice in SQL Server
Edition description:	1st ed.
Pages:	400
Product dimensions:	7.50(w) x 9.20(h) x 1.00(d)

About the Author

Rob Walters is a data platform technology specialist for Microsoft. His extensive experience with Microsoft SQL Server began over 10 years ago when he worked as a consultant for Microsoft Consulting Services in Denver, Colorado. Shortly after the dot-com bubble burst, Walters returned to Microsoft s headquarters and worked as a program manager in the SQL Server product unit. There, he owned various features within SQL Server including SQL Server Agent, various management features, and the security for the database engine. Walters has co-authored three patents for technologies used within SQL Server. Walters has also co-authored Programming Microsoft SQL Server 2005 by Microsoft Press, and Pro SQL Server 2005, Accelerated SQL Server 2008, and Beginning SQL Server 2008 Database Administration by Apress. He holds a bachelor's of science degree in electrical engineering from Michigan State University and a master's degree in business administration from Seattle University. When not at work, he is very active in his community as an on-call firefighter.

Table of Contents

• The Database Administration Profession
• Planning and Installing SQL Server 2008
• What's in the Toolbox?
• Creating Tables and Other Objects
• Transact-SQL
• SQL Server Internals
• Storage Management Strategies
• Database Backup Strategies
• Database Restore Strategies
• Common Database Maintenance Tasks
• Automation Through SQLCMD and PowerShell
• Database Maintenance Plans
• Performance Tuning and Optimization
• SQL Server Security
• Auditing, Encryption, and Compliance
• SQL Server in the Enterprise
• Where to Go Next?