Beginning SQL Server 2008 Administration

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

Full description

Bibliographic Details
Main Authors: Walters, Robert, Fritchey, Grant (Author), Taglienti, Carmen (Author)
Format: eBook
Language:English
Published: Berkeley, CA Apress 2009, 2009
Edition:1st ed. 2009
Subjects:
Online Access:
Collection: Springer eBooks 2005- - Collection details see MPG.ReNa
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?