SQL Server 2005 DBA Street Smarts and over one million other books are available for Amazon Kindle. Learn more
Buy New
$23.57
Qty:1
  • List Price: $29.99
  • Save: $6.42 (21%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills Paperback – October 30, 2006

ISBN-13: 978-0470083499 ISBN-10: 0470083492 Edition: 1st

Buy New
Price: $23.57
26 New from $18.63 17 Used from $2.00
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$23.57
$18.63 $2.00
Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Frequently Bought Together

SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills + Mastering SQL Server 2008
Price for both: $65.82

Buy the selected items together
  • Mastering SQL Server 2008 $42.25

NO_CONTENT_IN_FEATURE

Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now

Product Details

  • Paperback: 333 pages
  • Publisher: Sybex; 1 edition (October 30, 2006)
  • Language: English
  • ISBN-10: 0470083492
  • ISBN-13: 978-0470083499
  • Product Dimensions: 9.2 x 7.4 x 0.8 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 Best Sellers Rank: #1,694,687 in Books (See Top 100 in Books)

Editorial Reviews

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.

About the Author

Joseph L. Jorden (MCP, MCSE, MCTS) is the Lead Developer for Jelly Belly Candy Company where he spends a great deal of his time developing database applications and assisting the DBA with SQL Server administration tasks. Joseph was one of the first 100 people to achieve the MCSE+I certification from Microsoft, one of the first 2,000 people to earn the MCSE certification on Windows 2000 and he is a charter member of the MCTS certification program. Joseph also spent a few years as an MCT during which time he taught Microsoft Official Curriculum courses about SQL Server 6.5, 7.0, and 2000. He has spoken at PASS conferences and Comdex about SQL Server and other computing subjects. Joseph has also written a number of articles for various publications, and he has written and tech edited several books for Sybex, most of them on the subject of SQL Server.

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

3.9 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

5 of 5 people found the following review helpful By JR on January 18, 2007
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 6 people found the following review helpful By J. Jennings on January 25, 2007
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills (Paperback)
by Joseph L. Jorden

Short Review:
Microsoft's new generation of certifications is design not only to emphasize your proficiency with a specific technology but also to prove you have the skills needed to perform a specific role. This book is developed based on the exam objective of the 70-431, although its purpose is to server more as a reference than just an exam preparation book.

Detail Review:
This book is designed to give DBAs some insight into the world of typical database administrator by walking through some of the daily tasks user can expect on the job. However, serious reader can derive much value from simply reading thorough the tasks without performing the steps on live equipment.

This book is organized into four phases of database administration. Each phase is separated into individual tasks. The phases represent broad categories under which related responsibilities are grouped. Phases are listed here:

Phase 1 : Installing and Configuring Microsoft SQL Server 2005
Phase 2 : Implementing High Availability and Disaster Recovery
Phase 3: Maintaining and Automating SQL Server
Phase 4: Monitoring and Troubleshooting SQL Server

Each task in this book is organized into sections aimed at giving user what to do when need it. Descriptions of sections are divided in four parts i.e. The Scenario, The Scope of Task, The procedure and The Criteria of Completion.

I am including one example of above procedure to get clear idea how the book is organized.

Task : Selecting and Setting a Recovery Model
This task starts with the basic requirement of the recovery model.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Baja on October 19, 2006
Format: Paperback
If you want a great quick start for 2005 this is the book to have. Its a nuts and bolts approach. No long explanations on how to do and where to find it. Quick short, step by step tasks that you can follow along and do. This book is refreshing compared to the typically large text.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images


What Other Items Do Customers Buy After Viewing This Item?