Beginning SQL Server 2008 Administration

ISBN-13: 9781430224136 / Angielski / Miękka / 2009 / 400 str.

Robert Walters

Opis

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

Spis treści

1. The Database Administration Profession
2. Planning and Installing SQL Server 2008
3. What's in the Toolbox?
4. Creating Tables and Other Objects
5. Transact-SQL
6. SQL Server Internals
7. Storage Management Strategies
8. Database Backup Strategies
9. Database Restore Strategies
10. Common Database Maintenance Tasks
11. Automation Through SQLCMD and PowerShell
12. Database Maintenance Plans
13. Performance Tuning and Optimization
14. SQL Server Security
15. Auditing, Encryption, and Compliance
16. SQL Server in the Enterprise
17. Where to Go Next?

O autorze

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.