15 Projects You Can Do with Microsoft SQL Server 7

KAREN WATTERSON is an independent San Diego-based writer and consultant specializing in data warehouse and knowledge management issues. She is the editor of Pinnacle Publishing's monthly SQL Server Professional and Visual Basic Developer newsletters, coauthor for Windows 2000 magazine, and author of four books. She has been using SQL Server since 1988. BILL SHADISH is a principal of Fundamental Objects, Inc.(www.fo.com) where he works with ActiveX controls, COM server, project management tools, and handheld technology. Bill writes for a number of Visual Basic trade journals including Visual Basic Developer and Inside Visual Basic. He has coauthored three books. GARTH WELLS is an independent consultant who has worked in database design and development for more than six years and with SQL Server since version 4.2. He has successfully implemented and/or managed database solutions in the following industries: Computer Design and manufacturing, Automobile Finance, Software Development, and Commercial Real Estate Management and Financial Services. Visit his company's Web site at www. DataDrivenWebSites.com.

GETTING STARTED. Introduction to SQL Server. Installing SQL Server. Backup and Recovery. PROJECTS. Project No.1: Upsizing Your Desktop Database. Project No.2: Publishing SQL Server Data to HTML. Project No.3: Building a Corporate Intranet with Internet Information Server. Project No.4: Create a Single-Source Data Mart. Project No.5: Creating a Multi-Source Data Mart with Data Transformation Services. Project No.6: Working with OLAP Services. Project No.7: Implementing Replication. Project No.8: Getting Started with E-Commerce. Project No.9: Encapsulating Business Logic with Stored Procedures and Triggers. Project No.10: Using Visual Basic to Write SQL Applications. More Project Ideas. APPENDICES. Appendices. Index.