Wrox Press Ltd.

© 2001 Wrox Press

All rights reserved. No part of this book may be reproduced, stored in a retrieval system or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embodied in critical articles or reviews.

The author and publisher have made every effort in the preparation of this book to ensure the accuracy of the information. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors, Wr 19419u2024t ox Press nor its dealers or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

Published by Wrox Press Ltd,

Arden House, 1102 Warwick Road, Acocks Green,

Birmingham, B27 6BH, UK

Printed in the United States

Trademark Acknowledgements

Wrox has endeavored to provide trademark information about all the companies and products mentioned in this book by the appropriate use of capitals. However, Wrox cannot guarantee the accuracy of this information.

Credits

About the Author

Louis is an avowed database nut. Currently he is toiling as the database architect for Education Networks of America in Nashville, Tennessee, not to mention writing this book and hopefully one more.

He has been designing and implementing Microsoft SQL Server databases for around nine years, since his brilliant failure as a LAN Administrator for the Church of God International Headquarters in Cleveland, Tennessee (yes, there is a Cleveland in Tennessee). As SQL Server came packaged with Visual Basic 1.0 back then, he has also been developing with that product for around nine years, although his VB skills have been progressively getting worse since version 4.0, as he has been focusing primarily on SQL Server.

Louis has spoken at several conferences, such as CA-World in 1999 and 2000, concerning implementing solutions with ERwin; and at PASS 2000 Europe, he gave two presentations, one on normalization and the other on query optimization.

At home there is a wife Valerie and a daughter Chrissy, whom he dreams of one day spending a free moment with, since he hasn't had any since the day that SQL Server and Visual Basic landed on his desk nine years ago.

Acknowledgements

I would also like to acknowledge the following, who directly or indirectly affected the process of making this book a reality:

q        The Lord Jesus Christ who created me with the ability to design and program computer software.

q        My wife Valerie and daughter Chrissy, who did not see me for six months without a laptop, even on vacation; thanks for the love and patience.

q        My mom, without whom...

q        Chuck Hawkins for helping the book go past my limitations in Chapter

q        Chip Broecker, Donald Plaster, Michael Farmer, all for being great mentors over the past years

q        All the great people I currently work with, who have put up with me for months on limited sleep.

q        All of the professors, academics, authors, etc, who, through classes, books, and web pages I have read over the years, have either directly or indirectly planted seeds of knowledge in my brain

q        The staff at WROX, who (other than the long nights!) treated me extremely well and made this all happen.

q       The editors of this book, who have helped to shape and mold the ideas from a bunch of disorganized ramblings to the book you have in your hands.