SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills (Paperback)

by Joseph L. Jorden (Author)
Key Phrases: setup for this task, witness server, existing backup set, Object Explorer, Notification Services, Database Mail (more...)

Editorial Reviews

Product Description
Develop the skill you need in the real world.

Hit the ground running with the street-smart training you'll find in this practical book. Using a "Year in the life" approach, it gives you an inside look at SQL Server 2005 database administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of SQL Server 2005 administration, including:
* Installing and configuring SQL Server
* High availability and disaster recovery
* Maintenance and automation
* Monitoring and troubleshooting

An Invaluable study tool

This no-nonsense book also maps to the common tasks and objectives for Microsoft's MCTS SQL Server (TM) 2005 Implementation and Maintenance exam (70-431). So whether you're preparing for certification or seeking practical skills to break into the field, you'll find the instruction you need, including:
* Upgrading from a previous version of SQL Server
* Configuring an operating mode
* Restoring a database
* Creating a Transact-SQL user-defined type
* Using Windows(r) System Monitor to Monitor performance

THE STREET SMARTS SERIES is designed to help current or sparing IT professionals put their certification to work for them. Full of practical, real world scenarios, each book features actual tasks from the field and then offers step-by-step exercises that teach the skills necessary to complete those tasks. And because the exercises are based upon exam objectives from leading technology certifications, each Street Smarts book can be used as a lab manual for certification prep.

From the Back Cover
Develop the skill you need in the real world.

Hit the ground running with the street-smart training you'll find in this practical book. Using a "Year in the life" approach, it gives you an inside look at SQL Server 2005 database administration, with key information organized around the actual day-to-day tasks, scenarios, and challenges you'll face in the field. This valuable training tool is loaded with hands-on, step-by-step exercises covering all phases of SQL Server 2005 administration, including:

• Installing and configuring SQL Server
• High availability and disaster recovery
• Maintenance and automation
• Monitoring and troubleshooting

An Invaluable study tool

This no-nonsense book also maps to the common tasks and objectives for Microsoft's MCTS SQL Server ^TM 2005 Implementation and Maintenance exam (70-431). So whether you're preparing for certification or seeking practical skills to break into the field, you'll find the instruction you need, including:

• Upgrading from a previous version of SQL Server
• Configuring an operating mode
• Restoring a database
• Creating a Transact-SQL user-defined type
• Using Windows® System Monitor to Monitor performance

THE STREET SMARTS SERIES is designed to help current or sparing IT professionals put their certification to work for them. Full of practical, real world scenarios, each book features actual tasks from the field and then offers step-by-step exercises that teach the skills necessary to complete those tasks. And because the exercises are based upon exam objectives from leading technology certifications, each Street Smarts book can be used as a lab manual for certification prep.

See all Editorial Reviews

Product Details

• Paperback: 333 pages
• Publisher: Sybex; 1 edition (October 30, 2006)
• Language: English
• ISBN-10: 0470083492
• ISBN-13: 978-0470083499
• Product Dimensions: 9.1 x 7.3 x 0.9 inches
• Shipping Weight: 1.1 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars See all reviews (8 customer reviews)
• Amazon.com Sales Rank: #553,915 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #35 in

  Books > Computers & Internet > Certification Central > MS SQL Server

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

2.0 out of 5 stars more reference than street smarts, January 18, 2007

By	J. Reiter "Consultant" (Chicago, IL USA) - See all my reviews (REAL NAME)

I was looking for a street smarts sort of guide. This is not it. Perhaps it is really only designed to assist with a path to certification. It is written more like a reference manual with very short detail on each subject. With a title like street smarts, I'd expect things that are not found in SQL online help. But this does not have that.

To its credit, it covers topics in a thorough manner and is simple to follow and use for finding information. It also covers a vast array of topics.

5 of 6 people found the following review helpful:

5.0 out of 5 stars Easy to follow book with many examples, not a reference manual, January 25, 2007

By	J. Jennings "vbwiz" (USA) - See all my reviews (REAL NAME)

Regarding the title "Street Smarts" -- it's catchy, but some people might expect too much from the book based on the title. This is not an expert level book, but is a great introduction with easy-to-follow examples that are pretty much error free. If you don't know the basics of how to set up database mirroring, how to set up replication, how to create a subscription, or how to create file groups in SQL Server 2005, this book provides a great starting point that won't bash you over the head with pages and pages of theory. Most software related development books these days are lengthy, almost burdensome 500 page technical manuals that provide so much detail and technical information to be almost overwhelming. Despite tons of pages and lengthy explanations, many books fail to provide easy to implement examples illustrating how to actually accomplish anything. This book actually provides numerous easy-to-follow, non-trivial, step-by-step, accurate examples which demonstrate how to accomplish many different "DBA" related tasks in SQL Server 2005. The topics covered by this book are very similar to the topics covered in the official Microsoft course for Implementing Databases for SQL Server 2005. This is not a theory book, but a practical "how to" book. Sometimes you can learn more by doing than by trudging waist deep through pages and pages of technial explanations.

2 of 2 people found the following review helpful:

2.0 out of 5 stars good, but not great, July 20, 2007

By	Brian C. Brown - See all my reviews (REAL NAME)

This book distinguishes itself by concentrating on step-by-step walk-throughs of practical exercises. And while that is helpful, only a few questions in the test are simulations. Many of the exam questions are about esoteric details, which are not covered by this book.

I purchased four books to study for the 70-431, and I would place this in the bottom two.