Beginning SQL Server 2008 Administration de Robert Walters

Beginning SQL Server 2008 Administration

Robert Walters

Grant Fritchey

Carmen Taglienti

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

Citește tot Restrânge

Cuprins

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?.

Notă biografică

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.

Caracteristici

Written by a Microsoft Data Platform Technology Specialist with extensive experience assisting large, enterprise customers Short, unintimidating, but covers the ground Emphasizes the human aspects of being a DBA – gets across what the job is like and how one must carry one's self in order to succeed