Professional Microsoft SQL Server 2008 Administration and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading Professional Microsoft SQL Server 2008 Administration on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Professional Microsoft SQL Server 2008 Administration [Paperback]

Brian Knight , Ketan Patel , Wayne Snyder , Ross LoForte , Steven Wort

List Price: CDN$ 59.99
Price: CDN$ 37.61 & FREE Shipping. Details
You Save: CDN$ 22.38 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it delivered Wednesday, September 24? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Kindle Edition CDN $35.73  
Paperback CDN $37.61  
Save Up to 90% on Textbooks
Hit the books in's Textbook Store and save up to 90% on used textbooks and 35% on new textbooks. Learn more.
Join Amazon Student in Canada

Book Description

Nov. 3 2008 Wrox Programmer to Programmer
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We've provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008.

Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they'd like the production configured. Oftentimes, they're responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer.

This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts of SQL Server already. For example, this book does not show you how to create a database or walk you through the installation of SQL Server using the wizard. Instead, the author of the installation chapter may provide insight into how to use some of the more advanced concepts of the installation. Although this book does not cover how to query a SQL Server database, it does cover how to tune the queries you've already written.

Customers Who Bought This Item Also Bought

Product Details

Product Description

From the Back Cover

Professional Microsoft® SQL Server® 2008 Administration

SQL Server 2008 represents a significant jump forward in scalability and performance. Database administrators — and developers as well — will need to master new methods for effectively managing increasingly large and complex SQL Server environments.

This author team of SQL Server experts arms you with unique tips, tricks, and workarounds, including managing and monitoring SQL Server, automating administration, clustering, performance tuning, handling backup and recovery, and more. You'll learn the various tools that are available to you with the 2008 release, as well as new features such as Performance Studio, Change Data Capture, Policy-based Management, and Query Governor. With a solid understanding of SQL Server 2008, you'll be able to confidently handle even the most difficult SQL Server admin issues.

What you will learn from this book

  • Best practices for SQL Server 2008 installation

  • Tips for troubleshooting and securing the database engine

  • How to automate SQL Server

  • Ways to index your database

  • Methods for monitoring your SQL Server instance

  • How to performance tune your SQL Server instance

Who this book is for

This book is for experienced database administrators who are interested in learning best pratices for administering SQL Server 2008.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 4.7 out of 5 stars  3 reviews
10 of 11 people found the following review helpful
4.0 out of 5 stars Read this before installing SQL Server 2008 in Production May 31 2009
By D. E. Lopez - Published on
A must read for setting up SQL Server. This book walks you through planning, installation all the way through setting up maintenance (Backup and restore). In addition the book is very thorough with lots of illustrations.

The first thing I noticed was in the planning stage the book provided a considerable amount of charts to determine not only which level of SQL Server and client licenses to install but also which components should be selected. This book also high-lights the differences between 2008 and previous versions. This was especially useful because I needed a reference that would advise me on changes. I have performed various installations and was surprised to read that the "Surface Area Configurator" was replaced with Policy-Based Management.

The Automating SQL Server section was great as I mentioned previously this section in particular had very good screen shots and explanations of the different options. In addition, it had various real world tips. Security is addressed throughout the book especially in "Integration Services".

I found it interesting that a whole chapter was devoted to "Change Management". The writer adds insight into VS Team System and how it can reconcile two database schemas and provides update scripts. In addition, what technical book is created that doesn't have a section on optimization and monitoring and here is not difference.

All in all I found the book very good from a DBA Installation/Optimization stand point. Just be aware that this is not a book if you are looking for creating Views, Stored Procedures, Database Diagrams and the like.
2 of 3 people found the following review helpful
5.0 out of 5 stars Excellent book for a seasoned DBA to go into SQL Server 2008 March 31 2010
By JW - Published on
Format:Paperback|Verified Purchase
This is an excellent book for a seasoned DBA to go into SQL Server 2008.
2 of 6 people found the following review helpful
5.0 out of 5 stars Perfect Book for DBA's on SQL Server 2008 June 17 2009
By Mohammad M. Khan - Published on
Easy to follow and very well structured book for below topics

Best practices for SQL Server 2008 installation
Tips for troubleshooting and securing the database engine
How to automate SQL Server
Ways to index your database
Methods for monitoring your SQL Server instance
How to performance tune your SQL Server instance.

Look for similar items by category