Skip to main content
SpringerLink
Log in
Apress

Beginning SQL Server 2008 Administration

  • Book
  • © 2009

Overview

Authors:
  1. Robert E. Walters
    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Grant Fritchey
    View author publications

    You can also search for this author in PubMed   Google Scholar

  3. Carmen Taglienti
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • 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

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

Access this book

Log in via an institution
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

Licence this eBook for your library

Institutional subscriptions

Table of contents (17 chapters)

  1. Front Matter

    Pages i-xxii
    Download chapter PDF

  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
    Download chapter PDF
Back to top

Keywords

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

Publish with us

Policies and ethics

Back to top

Search

Navigation