Professional SQL Server 2005 Administration (Wrox Professional Guides)

Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005.

What you will learn from this book

• How to use some of the more advanced concepts of installation
• Techniques for properly administering development features such as SQL CLR
• Ways to secure your SQL Server from common threats
• How to choose the right hardware configuration
• Best practices for backing up and recovering your database
• Step-by-step guidelines for clustering your SQL Server

Who this book is for

This book is for experienced developers and database administrators who plan to administer or are already administering an SQL Server 2005 system and its business intelligence features.

Wrox Professional guides are planned and written by working technologists 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.

---

All Customer Reviews
Average Customer Review:
0 of 0 people found the following review helpful:

A handbook for DBAs, 2008-10-31
This book is a good reference for DBAs and IT professionals who wants to know everything about SQL Server 2005. I like the structure of contents, the examples and the way it exposes the subjects.


1 of 1 people found the following review helpful:

Good primer for a SQL 2000 Admin, 2008-04-11
I had been out of SQL 2K for several years and had a project that came up that fit best with a lot of the features of 2005. This book was a good read, lots of good examples, and got me back into the swing of things. The project went well and this book gave me the foundation I needed.


1 of 2 people found the following review helpful:

Great Book, 2007-09-14
You get a lot for your money with this book. I'm surprised that there are not more reviews.

Great job guys!


4 of 4 people found the following review helpful:

Not even close to covering the material., 2007-08-22
I am an experienced Sql Server 2000 DBA, and as I get more involved with 2005 the more this book falls short. This is because 2005 is so much more complex than 2000 that a single 700 page book simply does not cover the material. Simple things like schema ownership and management is glossed-over in the book when in fact it is a huge subject. Buy this book as it is useful, but plan on buying the Microsoft books and reading them soon. 2005 marks a major change and you can not afford to be left behind.


14 of 25 people found the following review helpful:

An Advanced Book written for Administrators, 2006-12-08
SQL Server is a major big-time database. It has numerous features with settings that can dramatically alter its performance. It can also be expanded to handle exceedly large databases with multiple servers handling a great many dips into the database updating, adding, selecting out data. There are also multiple editions of SQL Server to handle clustering, high availability and so on.

This book covers all of these and more. It begins with the architecture, goes on to installation, performance tuning, security, performance tuning, monitoring, indexing, replication, mirroring, backup, logging, and clustering.

The book is intended for people who have some experience with SQL Server, at least to the point of being able to understand what SQL is and how to get data into and out of the database. It will then cover how to tune the queries you're already written to get the maximum performance.

This is a Wrox Professional level book, it is written by professionals for the use of professionals.

Price is accurate as of the date/time indicated. Prices and product availability are subject to change. Any price displayed on the Amazon website at the time of purchase will govern the sale of this product.