Skip to main content
  • Book
  • © 2009

Beginning SQL Server 2008 Administration

Apress
  • 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

  • 8578 Accesses

Buy it now

Buying options

eBook USD 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 44.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (17 chapters)

  1. Front Matter

    Pages i-xxii
  2. The Database Administration Profession

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 1-8
  3. Planning and Installing SQL Server 2008

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 9-40
  4. What’s in the Toolbox?

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 41-73
  5. Creating Tables and Other Objects

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 75-95
  6. Transact-SQL

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 97-116
  7. SQL Server Internals

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 117-126
  8. Storage Management Strategies

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 127-149
  9. Database Backup Strategies

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 151-182
  10. Database Restore Strategies

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 183-210
  11. Common Database Maintenance Tasks

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 211-238
  12. Automation Through SQLCMD and PowerShell

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 239-262
  13. Database Maintenance Plans

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 263-286
  14. Performance Tuning and Optimization

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 287-326
  15. SQL Server Security

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 327-345
  16. Auditing, Encryption, and Compliance

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 347-371
  17. SQL Server in the Enterprise

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 373-394
  18. Where to Go Next?

    • Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Pages 395-399
  19. Back Matter

    Pages 401-410

About this book

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

About the authors

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.

Bibliographic Information

  • Book Title: Beginning SQL Server 2008 Administration

  • Authors: Robert E. Walters, Grant Fritchey, Carmen Taglienti

  • DOI: https://doi.org/10.1007/978-1-4302-2414-3

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books

  • Copyright Information: Robert Walters and Grant Fritchey and Carmen Taglienti 2009

  • Softcover ISBN: 978-1-4302-2413-6Published: 07 October 2009

  • eBook ISBN: 978-1-4302-2414-3Published: 26 March 2010

  • Edition Number: 1

  • Number of Pages: 400

  • Topics: Database Management

Buy it now

Buying options

eBook USD 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 44.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access