MCITP Self-Paced Training Kit (Exam 70-442)-Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

Sara Morgan and

Tobias Thernström of GrandMasters

PUBLISHED BY Microsoft Press

A Division of Microsoft Corporation

One Microsoft Way Redmond, Washington 98052-6399

Copyright © 2007 by GrandMasters

9780735623835

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

Library of Congress Control Number: 2007922585

Printed and bound in the United States of America.

1 2 3 4 5 6 7 8 9 QWT 2 1 0 9 8 7

Distributed in Canada by H.B. Fenn and Company Ltd.

A CIP catalogue record for this book is available from the British Library.

Microsoft Press books are available through booksellers and distributors worldwide. For further information about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax [phone]. Visit our Web site at www.microsoft.com/mspress. Send comments to [e-mail].

Microsoft, Microsoft Press, Active Directory, ActiveSync, ActiveX, Excel, Internet Explorer, MSDN, MSN, Outlook, PowerPoint, SQL Server, Visual Basic, Visual C#, Visual FoxPro, Visual J#, Visual Studio, Win32, Windows, Windows Live, Windows Mobile, Windows NT, Windows Server, and Windows Vista are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company names mentioned herein may be the trademarks of their respective owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred.

This book expresses the author's view and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

Acquisitions Editor: Ken Jones

Developmental Editor: Karen Szall

Project Editor: Maria Gargiulo

Editorial Production: nSight, Inc.

Body Part No. X13-62481

Dedication

To my Mom and Dad, who have always been a tremendous inspiration for me. I am nothing without you both. I love you.
-Sara Morgan

To my fiancée, Frida, my mother, Viveca, and the memory of my father, Bertil.
-Tobias Thernström

To my wife, Mary, who patiently endured the late nights and long weekends that were spent on this effort, and to Nikki the Rottweiler, who tried her best to help but just couldn't get the syntax down.
-Ted Malone

About the Authors

Sara Morgan

Sara Morgan, an independent author and consultant based in Baton Rouge, Louisiana, is an MCSD and MCDBA and is certified in SQL Server 2000 and Visual Basic .NET. She specializes in developing leading-edge Web-based applications using Microsoft technologies. Since graduating from Louisiana State University with a degree in quantitative business analysis, she has been developing software for a variety of industries, including a not-for-profit hospital, a financial company offering mortgages, a major retailer, a software company that writes legislative software, and an application service provider.

Sara has written articles for MSDN Magazine, Enterprise Development, .NET Development, Visual Studio Magazine, and DevX.com. She has also co-written MCTS Self-Paced Training Kit (Exam 70-529): Microsoft .NET Framework 2.0 Distributed Application Development (Microsoft Press, 2006) and MCPD Self-Paced Training Kit (Exam 70-547): Designing and Developing Web-Based Applications Using the Microsoft .NET Framework. Sara's articles about enhanced computing and her latest research efforts can be found at http://www.custsolutions.net.

Tobias Thernström

Tobias Thernström has enjoyed the company of SQL Server for over 10 years. He is a senior database architect and trainer at Rbam AB (www.rbam.se), a professional software services company located in Sweden. Tobias has been involved in the development of several SQL Server certifications provided by Microsoft. He is an MCT and co-founder of the Swedish SQL Server User Group (www.sqlug.se).

Ted Malone

Ted Malone has been working with SQL Server since the days of OS/2 and has developed database systems ranging from small to extremely large. Ted is currently product strategy architect for Configuresoft, Inc. (http://www.configuresoft.com), a Colorado Springs, Colorado-based software development firm and Microsoft Gold ISV Partner that specializes in delivering enterprise management tools for Fortune 1000 corporations. Ted is the vice president of the Rocky Mountain SQL Server Users Group and a frequent contributor to the Professional Association for SQL Server. Ted was also a contributing author to SQL Server Security (McGraw-Hill Osborne Media, 2003) as well as a contributor to several SQL Server 2005 study guides.

In his free time, Ted enjoys the Colorado wilderness with his family and dogs. Ted is also an avid pilot with more than 4,000 hours of flight time and enjoys riding his motorcycle whenever possible.