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

( 1 )


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...

See more details below
Other sellers (Paperback)
  • All (17) from $1.99   
  • New (9) from $18.60   
  • Used (8) from $1.99   
SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
BN.com price
(Save 45%)$29.99 List Price


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 alab manual for certification prep.

Read More Show Less

Product Details

  • ISBN-13: 9780470083499
  • Publisher: Wiley
  • Publication date: 10/30/2006
  • Edition number: 1
  • Pages: 333
  • Product dimensions: 7.50 (w) x 9.25 (h) x 0.75 (d)

Meet 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.

Read More Show Less

Table of Contents


Phase 1 Installing and Configuring Microsoft SQL Server 2005.

Task 1.1: Verifying Prerequisites and Installing the Default Instance.

Task 1.2: Installing a Second Instance.

Task 1.3: Designing and Creating a Database.

Task 1.4: Designing and Creating a Table.

Task 1.5: Designing and Creating a Constraint.

Task 1.6: Designing and Creating a View.

Task 1.7: Designing and Creating a Stored Procedure.

Task 1.8: Designing and Creating an INSERT Trigger.

Task 1.9: Designing and Creating a DELETE Trigger.

Task 1.10: Designing and Creating an UPDATE Trigger.

Task 1.11: Designing and Creating an INSTEAD OF Trigger.

Task 1.12: Designing and Creating a User-Defined Function.

Task 1.13: Designing and Creating a Clustered Index.

Task 1.14: Designing and Creating a Nonclustered Index.

Task 1.15: Designing and Creating a Full-Text Index.

Task 1.16: Creating a Windows Login.

Task 1.17: Creating a Standard Login.

Task 1.18: Assigning Logins to Fixed Server Roles.

Task 1.19: Creating a Database User Mapping.

Task 1.20: Assigning User Mappings to Fixed Database Roles.

Task 1.21: Creating a Custom Database Role.

Task 1.22: Creating an Application Role.

Task 1.23: Assigning Permissions.

Task 1.24: Configuring Encrypted Connections.

Phase 2 Implementing High Availability and Disaster Recovery.

Task 2.1: Selecting and Setting a Recovery Model.

Task 2.2: Creating a Backup Device.

Task 2.3: Performing a Full Backup.

Task2.4: Performing a Differential Backup.

Task 2.5: Performing a Transaction Log Backup.

Task 2.6: Performing a Filegroup Backup.

Task 2.7: Restoring a Database.

Task 2.8: Performing a Point-in-Time Restore.

Task 2.9: Implementing Database Mirroring.

Task 2.10: Implementing Log Shipping.

Task 2.11: Creating a Database Snapshot.

Task 2.12: Reverting from a Database Snapshot.

Task 2.13: Choosing a Replication Type.

Task 2.14: Designing a Replication Topology.

Task 2.15: Configuring Replication.

Task 2.16: Creating a Transactional Publication.

Task 2.17: Subscribing to a Transactional Publication.

Task 2.18: Creating a Snapshot Publication.

Task 2.19: Subscribing to a Snapshot Publication.

Task 2.20: Creating a Merge Publication.

Task 2.21: Subscribing to a Merge Publication.

Task 2.22: Resolving Merge Conflicts.

Task 2.23: Monitoring Replication.

Phase 3 Maintaining and Automating SQL Server.

Task 3.1: Configuring Database Mail.

Task 3.2: Creating an Operator.

Task 3.3: Creating a Job.

Task 3.4: Creating an Alert.

Task 3.5: Creating a Database Maintenance Plan.

Task 3.6: Using the Copy Database Wizard.

Phase 4 Monitoring and Troubleshooting SQL Server.

Task 4.1: Using Windows System Monitor.

Task 4.2: Creating an Alert in Windows System Monitor.

Task 4.3: Creating a SQL Server Performance Alert.

Task 4.4: Creating a WMI Alert.

Task 4.5: Running a Trace in Profiler.

Task 4.6: Creating a Workload in Profiler.

Task 4.7: Using the Database Engine Tuning Advisor.

Task 4.8: Identifying and Rectifying the Cause of a Block.

Task 4.9: Using the Dedicated Administrator Connection.


Read More Show Less

Customer Reviews

Average Rating 3
( 1 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted January 17, 2011

    No text was provided for this review.

Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)