作者简介：Walter Glenn, Microsoft Certified System Engineer (MCSE), Microsoft Certified Desktop Support Technician (MCDST), and Microsoft Certified Trainer (MCT), has been a part of the com-puter industry for more than 17 years and currently works in Huntsville, Alabama, as a consultant, trainer, and writer. Walter is a regular columnist in Microsoft's TechNet Zone and is the author or coauthor of nearly 20 computer titles, including Microsoft Exchange Server 2003 Administrator's Companion (Microsoft Press, 2003), Mike Meyers' MCSA Managing a Microsoft Windows Server 2003 Network Environment Certifica- tion Passport (Exam 70-291) (Osborne, 2003), and MCSE Self-Paced Training Kit (Exam 70-297): Designing a Microsoft Windows Server 2003 Active Directory and Net- work Infrastructure (Microsoft Press, 2003). He has also written a number of Web- based courses that are geared toward Microsoft certification training.

The book readers can easily self-SQL Server 2005 based technology, from database design, build, to test configuration, each one of the steps the reader with practical guidance and help. Through the book, readers can fully experience learning-by-doing the fun the successful creation of a truly personal first SQL Server 2005 database.

Afutomate everyday administrative tasks-and take greater control of your Windows networks-with this hands-on guide to *ing .Your instructor ,a Microsoft Certified Trainer with more than a decade of enterprise consulting experience, deftly builds your *ing expertise with labs and lessons you complete at yourwn pace. Fromwriting your first *s from scratch with Microsoft Visual Basic Scripting Edition (VBScript)and Windows Script Host (WSH)-to exploring the programmatic advantages of using Windows Management lnstrumentation (WMI)and Active Directory Service Interface(ADSI)-you ll learn timesays to set up, deploy, and manage your Windows-based systems.

Ace your preparation for the skills measured by MCTS Exam 70-431--and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective Then, reinforce what you've learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to: Install and configure SQL Server 2005 Create tables and indexes, define columns, and implement constraints Implement functions, stored procedures, and triggers by using Transact-SQL Work with relational and XML data Monitor, troubleshoot, and tune queries Maintain database availability with log shipping, database mirroring, and replication Prepare a backup strategy and restore a database PRACTICE TESTS Assess your skills with practice tests with website. You can work through hundreds of questions using multiple testing modes to meet