I actually bought this book by mistake, BUT I started reading it while I waited on the MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) (All-in-One)to arrive. It's the PERFECT book to have for either a developer or DBA! As a matter of fact, just because of this book, I'm going to start on the developer certification right after I pass my DBA tests (I have all three tests in the next two weeks!).

I've got several friends that are developers (.NET, SQL, C#, etc, etc) and they all said if they had a book like this when they were learning they would have passed their tests with half the amount of time/effort!

The best part about this book is that I've had several questions regarding the content and decided to try and email Darril (the Author) for clarification. SURPRISE, I got thoughtful, through responses to all my questions extremely fast! Thank you Darril for doing such a great job putting this book together and being such a great help!!!

On top of the book, there's two great websites & a CD with all the scripts/info that you would need!

I actually bought this book by mistake, BUT I started reading it while I waited on the MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) (All-in-One)to arrive. It's the PERFECT book to have for either a developer or DBA! As a matter of fact, just because of this book, I'm going to start on the developer certification right after I pass my DBA tests (I have all three tests in the next two weeks!).

I've got several friends that are developers (.NET, SQL, C#, etc, etc) and they all said if they had a book like this when they were learning they would have passed their tests with half the amount of time/effort!

The best part about this book is that I've had several questions regarding the content and decided to try and email Darril (the Author) for clarification. SURPRISE, I got thoughtful, through responses to all my questions extremely fast! Thank you Darril for doing such a great job putting this book together and being such a great help!!!

On top of the book, there's two great websites & a CD with all the scripts/info that you would need!

After having completed Microsoft's MCAD certification, I am using this text along with the Tom Carpenter text to prepare for MCTS and MCITP certification. Though I haven't taken the exam yet, the material appears to be covered in a thorough and in-depth fashion. Yet, it does not get bogged down in unnecessary detail.

Excellent book!

Well written and in depth, this book should cover everything necessary to pass these tests.

I have two complaints:

1) The book is laid out functionally for SQL Server, not for each test. So, for example, when you are studying for the 70-442, it may involve a portion of chapter 3, 4, 5, and 8, but all of 12 and 13. All this information is entwined with the stuff for the other tests.

2) You choose to only take one of the tests on the CD. For example - you couldn't say just test for the 70-441 test. I found the CD questions less useful than books dedicated to one test because of this.

These are minor complaints though, and I'm not really sure the issues can be avoided to begin with. Don't let them stop you from using this as your resource to pass these three tests.

For the 431 exam, I used the (Tom) Carpenter book as my primary study guide and this book as a side reference. My main reason for purchasing this book is for the next two exams (441,442). After taking the 431 test and looking up some questions I guessed at in this book, I regret not using this book as my primary study guide. This book seems to point out the exact information needed to get through the test. I look forward to using it for the next two exams. Note that the author of this book is the technical editor for the Carpenter book.

Update to previous review:
I just passed both exams (441 & 442) without difficulty and with plenty of time remaining (each exam took about 2 hours). This is definitely the book to use for these exams. The topics and sample questions are on target with the actual test. Be sure to review the topic list for each exam in the front of the book before taking the test. The 'what you need to know' section at the end of each chapter is not always accurate. Also - the explanation of cascade deletes is incorrect in the book.

For the 431 exam, I used the (Tom) Carpenter book as my primary study guide and this book as a side reference. My main reason for purchasing this book is for the next two exams (441,442). After taking the 431 test and looking up some questions I guessed at in this book, I regret not using this book as my primary study guide. This book seems to point out the exact information needed to get through the test. I look forward to using it for the next two exams. Note that the author of this book is the technical editor for the Carpenter book.

The end-of-chapter exam questions were perfect for helping me know what I know and what I don't know. I already passed the 70-431 and 70-441 exams and the questions I looked at in the back of the chapters hit the knowledge needed to pass these exams.

Unfortunately I failed the 70-442 exam before this book was released. However, after reviewing the end-of-chapter exam questions, I saw exactly what I needed to brush up on. I spent several days in a marathon study session doing the exam questions in the back of each chapter for the 70-442. For anything I missed, I studied the material in the chapter. In addition to learning what I needed for the exam, I also learned a couple things I didn't know about in SQL Server 2005. I then took and passed the 70-442.

This book was just what I needed. I only wish I had it before I took the 70-442 the first time.