Designing SQL Server 2000 Databases [Illustrated] (Paperback)

~ Travis Laird (Author), Robert Patton (Author), Jennifer Ogle (Author) "Microsoft Structured Query Language (SQL) Server 2000 is the latest generation of the popular SQL Server product line and the second release since its core..." (more)
Key Phrases: fulltext table, file storage type, fixed server roles, Enterprise Manager, Cancel Help, Enterprise Edition (more...)

Editorial Reviews

Product Description

The Microsoft .NET initiative is the future of e-commerce - making it possible for organisations to build a secure, reliable e-commerce infrastructure. This is the first book to outline the capabilities of SQL Server 2000, one of the key components of .NET. SQL Server 2000 introduces powerful new data mining functionality designed specifically to capture and process customer profiles and to predict future buying patterns on e-commerce sites.

Designing SQL Server 2000 Databases for NET Enterprise Servers addresses the needs of IT professionals migrating from the popular SQL 7 databases to the new SQL 2000, as well as those who are starting from scratch.



* Covers all key features of SQL Server 2000 including; XML support, enhanced data-mining capabilities and integration with Windows 2000
* While there are many books available on SQL 7 - this is the first to be announced for SQL 2000
* Free ongoing customer support and information upgrades

About the Author

Travis Laird, (MCSE, MCDBA, A+, Network+, i-Net+, CIW) has extensive experience in a broad range of technology subjects ranging from Network Design and Support through Software Design and Development. Travis has worked on numerous e-commerce and line-of-business solutions based on Microsoft technologies including Windows 2000, Visual Basic, IIS and SQL Server. Travis currently works as an independent consultant in the New York City area. He attended Syracuse University and graduated with a Bachelor of Science degree in Finance and Management Information Systems.

Robert A. Patton (MCDBA, MCSD, MCSE+Internet, MCP+Internet) is a software engineer specializing in Microsoft Windows DNA applications utilizing Interdev and Visual Basic with Windows 2000 and SQL Server. He is currently a Senior Applications Developer at PurchasingFirst.com in Dublin, Ohio and has done work for First Union National Bank, Corporate Strategic Services, the Midland Life Insurance Company and Sykes Enterprises. He attended the University of Chicago, but earned his Bachelor of Science degree in Software Engineering from The Ohio State University.

Jennifer Ogle (MCSE, Master CNE, Oracle DBA) is Owner and President of Radioactive Frog Web Designs, Inc. (radfrog.com). She has a BS degree in Zoology and over 20 years of experience in the IT Industry specializing in government, scientific, and manufacturing applications.

Product Details

• Paperback: 608 pages
• Publisher: Syngress; 1 edition (January 15, 2001)
• Language: English
• ISBN-10: 1928994199
• ISBN-13: 978-1928994190
• Product Dimensions: 8.9 x 7.4 x 1.7 inches
• Shipping Weight: 2.7 pounds (View shipping rates and policies)
• Average Customer Review: 3.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon.com Sales Rank: #2,359,055 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

4 of 6 people found the following review helpful:

2.0 out of 5 stars This book is mis-titled, April 5, 2001

By	Stephen Caffo (Westfield, NJ USA) - See all my reviews (REAL NAME)

This book has nothing to do with DESIGNING sql 2000 databases. It is simply an administrative guide to sql 2000 - Ch1: SQL Server Overview Ch2:Installing and configuring ch3: Scalability and Availability ch4:Designing and Creating dbs Ch5: Security ch6: Admininistration and Active Directory ch7: backup and recovery ch8: english query ch9: import/export data Ch10. Analysis server (olap) ch11:XML ch12: Replication ch13: programming tools Ch14: Performance Tuning The only chapter that has designing of dbs, is ch4 which mainly deals with filegroups, autogrow features, etc. Nothing about design. If you want a good admin book for 2000 buy this, otherwise look elsewhere for a desgin book.

4.0 out of 5 stars Subject matter..., June 17, 2001

By	Travis Laird (New York, NY USA) - See all my reviews

The books focus is on SQL Server 2000 and its specific features that make it such a valuable database platform for any size organization. The books intent is to get administrators and developers up and running with the many features of SQL Server 2000 from creating database to working with Analysis Services. The art and science of "designing" databases is not specific to SQL Server and I would recommend "Designing Relational Database Systems" by Rebecca Riordan if your looking for beginner-intermediate level material on general database design. I hope the book helps in your endeavors with SQL Server 2000. Good luck.

4 of 8 people found the following review helpful:

5.0 out of 5 stars Excellent Professional Reference, February 14, 2001

By	Vincent (NJ) - See all my reviews

This book is detailed and well written. I have a lot of SQL books, and I found this one to be an excellent source of information. I highly recommend it to anyone interested in building databases with SQL Server 2000.