Pro SQL Server 2008 Administration

By Ken Simmons , Sylvester Carstarphen

  • eBook Price: $34.99
  • Print Book Price: $49.99
Buy eBook Buy Print Book
This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-2373-3
  • User Level: Intermediate to Advanced
  • Publication Date: August 26, 2009
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • SQL Server T-SQL Recipes
  • Energy Efficient Servers
  • Pro PowerShell for Database Developers
  • Pro SQL Server Wait Statistics
  • Introducing SQL Server
  • Expert SQL Server in-Memory OLTP
  • Expert T-SQL Window Functions in SQL Server
Full Description

Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server.

  • Introduces new administration features of SQL Server 2008
  • Shows how to manage a SQL Server 2008 database at professional level
  • Provides guidance on performance optimization

What you’ll learn

  • Take advantage of the new administrative features in SQL Server 2008
  • Make intelligent decisions when choosing an installation or upgrade path
  • Define and implement database policies to create a consistent, predictable environment throughout the organization
  • Automate repetitive Tasks for increased productivity
  • Create baseline monitors using Performance Monitor, Profiler, and System Dynamic Management views
  • Identify and resolve long-running, I/O, and CPU-intensive queries

Who this book is for

This book is for junior and seasoned database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server 2008.

Table of Contents

Table of Contents

  1. New Feature Overview
  2. Pre-Installation Considerations
  3. Choosing a High Availability Solution
  4. Installing Microsoft SQL Server 2008
  5. Upgrading to Microsoft SQL Server 2008
  6. Post Installation
  7. Multi-Server Administration
  8. Managing Security within the Database Engine
  9. Administering Database Objects
  10. Indexing for Performance
  11. Managing Backups
  12. Restore and Recovery Strategies
  13. Automating Routine Maintenance
  14. Monitoring Your Server
  15. Auditing SQL Server
  16. Managing Query Performance
  17. Secrets to Excelling as a Professional DBA
  18. What's Next?
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

No errata are currently published

Best-Sellers

    1. Pro SQL Server Internals

      $41.99

      View Details

    2. Pro T-SQL Programmer\'s Guide

      $41.99

      View Details

    3. Expert T-SQL Window Functions in SQL Server

      $17.99

      View Details

    4. Pro T-SQL Programmer\'s Guide

      $41.99

      View Details