Professional SQL Server 2000 Database Design

Professional SQL Server 2000 Database Design provides an outline of the techniques that the designer can employ to make effective use of the full range of facilities that SQL Server 2000 offers. It attempts to move away from traditional texts on relational database design by considering design issues from a "real world" point of view. To that end, it provides a full case study illustrating the scope of the designer's role - right from initial discussions regarding a client's needs, through development of a logical model, to full implementation of the system.

This book is aimed at developers who have an interest in learning more about general relational database design issues. While it will aid the reader to have a familiarity with SQL Server and the Transact-SQL language, this book has a wider appeal for any experienced database programmers wishing to learn more about relational database theory and design.

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.