Book description
The ideal on-the-job reference guide for SQL Server 2008 database administrators
If you manage and administer SQL Server 2008 in the real world, you need this detailed guide at your desk. From planning to disaster recovery, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them. Topics include installation and configuration, creating databases and tables, optimizing the database server, planning for high availability, and more.
And, if you're preparing for MCTS or MCITP certification in SQL Server 2008 administration, this book is the perfect supplement to your preparation, featuring a CD with practice exams, flashcards, and video walkthroughs of the more difficult administrative tasks
Delves into Microsoft's SQL Server 2008, a rich set of enterprise-level database services for business-critical applications
Explores the skills you'll need on the job as a SQL Server 2008 administrator
Shows you how to implement, maintain, and repair the SQL Server database, including bonus videos on the CD where the authors walks you through the more difficult tasks
Covers database design, installation and configuration, creating databases and tables, security, backup and high availability, and more
Supplements your preparation for MCTS and MCITP SQL Server 2008 certification with in-depth coverage of the skill sets required for certification, as defined by Microsoft
Uses hands-on exercises and real-world scenarios to keep what you're learning grounded in the reality of the workplace
Make sure you're not only prepared for certification, but also for your job as a SQL Server 2008 administrator, with this practical reference!
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Table of contents
- Cover Page
- Title Page
- Copyright
- Dear Reader,
- Dedication
- Acknowledgments
- About the Author
- Contents at a Glance
- Contents
- Table of Exercises
- Introduction
- Part I: Introducing SQL Server 2008
- Part II: Designing Database Solutions
- Part III: Implementing Database Solutions
- Part IV: Administration and Maintenance
- Part V: SQL Server Security
- Part VI: High Availability and Data Distribution
- Index
Product information
- Title: SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond
- Author(s):
- Release date: May 2010
- Publisher(s): Sybex
- ISBN: 9780470554203
You might also like
book
Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)
Implement, maintain, and repair SQL Server 2012 databases As the most significant update since 2008, Microsoft …
book
Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases
EXAM PREP GUIDE Ace your preparation for the skills measured by Exam 70-462—and on the job—with …
video
Microsoft SQL Server 2012 Certification Training - Exam 70-462
In this SQL Server 70-462 exam training course, expert author Denny Cherry teaches you everything you …
book
MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005
The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431 exam preparation. The …