Pro SQL Server 2008 Administration [NOOK Book]

( 1 )

Overview

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

See more details below
Pro SQL Server 2008 Administration

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.99 List Price

More About This Book

Overview

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

  2. New Feature Overview

  4. Pre-Installation Considerations

  6. Choosing a High Availability Solution

  8. Installing Microsoft SQL Server 2008

  10. Upgrading to Microsoft SQL Server 2008

  12. Post Installation

  14. Multi-Server Administration

  16. Managing Security within the Database Engine

  18. Administering Database Objects

  20. Indexing for Performance

  22. Managing Backups

  24. Restore and Recovery Strategies

  26. Automating Routine Maintenance

  28. Monitoring Your Server

  30. Auditing SQL Server

  32. Managing Query Performance

  34. Secrets to Excelling as a Professional DBA

  36. What's Next?


Read More Show Less

Product Details

  • ISBN-13: 9781430223740
  • Publisher: Apress
  • Publication date: 8/26/2009
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 592
  • File size: 25 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Ken Simmons is a database administrator and developer specializing in Microsoft SQL Server and .NET. He is currently working with a global electronic payment service provider in Columbus, Georgia. He has been working in the IT industry since 2000 and holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005.

Ken is highly active in the online community and often participates in the SQL forums on MSDN and SQLServerCentral. He enjoys sharing tips that he discovers by writing articles for SQLServerCentral and MSSQLTips.com. He has also formed an SQL Server Users Group in Columbus, Georgia, for SQL Server professionals to come together to share knowledge and resources. When he is not working, Ken enjoys traveling with his wife, Susan, and son, Nathan, and can often be found on a cruise ship, at a Disney resort, or at the beach in his hometown of Pensacola, Florida.


Sylvester Carstarphen is a senior database administrator for a customer relationship management company, where he is heavily involved in the performance monitoring and tuning of the company's very large databases. Sylvester started his database administration career almost six years ago at a Fortune 500 financial corporation, where he rapidly progressed from DBA I, to DBA II, senior DBA, and finally, working manager of database support in four years. His role consisted of managing six SQL Server administrators and an environment of more than 100 SQL Servers with more than 150 application databases. In search of opportunities to increase his performance tuning skills, Sylvester took on a new role with the company to help solve their major performance issues. Sylvester has a bachelor's degree in computer science from Wofford College in South Carolina, and a master's degree in applied computer science with a concentration in software development from Columbus State University. Sylvester enjoys playing video games and spending time with his wife and two American Staffordshire Terriers.
Read More Show Less

Customer Reviews

Average Rating 3
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(1)

2 Star

(0)

1 Star

(0)

Your Rating:

Review Guidelines
Add Recommendations
Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews

  • Posted February 11, 2010

    more from this reviewer

    SQL Server 2008 Administration

    This book is for junior and seasoned database administrators this book is only about database administration and the new techniques introduced in SQL Server 2008. This book covers the foundational topics such as installation, index creation, and backup and recovery. This book talks about the new features available in SQL Server 2008 that will make your job easier. It also covers business and regulator-driven topics like auditing and managing security. SQL Server administration is an extensive subject that covers everything from the critical decisions you need to make before installing SQL Server to managing and tuning queries running on existing systems. This book can work as a go-to guide when you need to make an important decision. There is also code you can download from Apress to practice with while reading the book. With the release of Microsoft SQL Server 2008 has introduced many new features that increase scalability, manageability, availability, programmability, and security across the enterprise I recommend this book.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.
Sort by: Showing 1 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)