Cover image for MSDE bible
MSDE bible
Walls, David C. (David Charles), 1967-
Publication Information:
Foster City, CA : IDG Books Worldwide, [2001]

Physical Description:
xxviii, 759 pages : illustrations ; 24 cm + 1 computer optical disc (4 3/4 in.)
Title Subject:
Subject Term:
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D26 W35 2001 Book and Software Set Central Closed Stacks

On Order



Developers, programmers, software architects, technical managers, and technical support staff who work with MSDE (Microsoft Data Engine) applications will all benefit from this book, which guides you through everything from installation and configuration of MSDE to administration and deployment.

Some of the topics covered in this reference include: the MSDE architecture; database structures; data retrieval and modification; database administration; securing MSDE applications; database monitoring and maintenance; and packaging SQL in stored procedures.

The CD-ROM included with the book contains all the example code.

Author Notes

About the Authors David C. Walls is originally from Chester, Pennsylvania, and now makes his home in Springfield (Delaware County), which is also in the Keystone State. He began working with computers professionally in 1983 at Widener University. While there, he worked with the Pick database system in various forms, introduced the university to the Internet, and rolled out Novell NetWare-based networks to the campus computer labs. For four years he was the Manager of Engineering at FasPak, a communications cabling company. Since then, he has been teaching and consulting on a variety of topics, with emphasis on Microsoft's SQL Server. He has previously contributed to a book about SQL Server 7.0, has written several magazine articles, and has spoken at computer-oriented conferences. Denise M. Gosnell is a Senior Programmer Consultant with Ambassador, Inc., a solutions firm headquartered in Indianapolis, Indiana. Her previous positions include Director of IS for CMG Worldwide, Inc., Programmer/Analyst for Key Benefit Administrators, Inc., and Systems Engineer for Electronic Data Systems (EDS). She obtained her Microsoft Certified Solution Developer (MCSD) status in 1997. Denise has been involved in software development professionally for over 6 years, and has worked with computer programming as a hobby since she was 12 years old. She received her bachelor's degree in Computer Science-Business from Anderson University and recently received a Doctor of Jurisprudence from Indiana University. She plans to pursue a career in patent and intellectual property law. Mark D. Scott is a consultant for RDA. He is a Microsoft Certified Database Administrator, System Engineer + Internet, Solution Developer and Trainer. He is a nationally recognized speaker and author. He holds a bachelor's degree in Computer Science.

Table of Contents

Part I The MSDE Environment
Chapter 1 What is MSDE?
Chapter 2 MSDE Architecture
Chapter 3 Methods for Communicating with MSDE
Chapter 4 Preparing to Use MSDE
Chapter 5 Understanding Microsoft Object Models
Part II Database Structures
Chapter 6 Databases
Chapter 7 Using Tables to Store Data
Chapter 8 Ensuring Database Consistency
Chapter 9 Improving Performance with Indexes
Chapter 10 Locking: The Key to a Consistent Multiuser System
Part III Data Retrieval and Modification
Chapter 11 Retrieving Data with the Structured Query Language (SQL)
Chapter 12 Modifying Data with SQL
Chapter 13 Programming with SQL
Part IV Advanced Database Structures
Chapter 14 Enhancing Data Access with Views
Chapter 15 Packaging SQL in Stored Procedures
Chapter 16 Using Triggers to Enforce Data integrity
Chapter 17 Accessing Data with Cursors
Part V Working with External Data
Chapter 18 importing and Exporting Data
Chapter 19 Transforming Data With DTS
Chapter 20 Using Replication to Distribute Data
Chapter 21 Using Transactions to Distribute Data
Part VI Database Administration
Chapter 22 Controlling MSDE
Chapter 23 Backing Up and Restoring Data
Chapter 24 Accessing Data from Programs, Scripts, and Web Pages Using ADO and XML
Chapter 25 Administering Security
Chapter 26 Automating Tasks with SQL Agent
Chapter 27 Creating Web Pages
Part VII Database Monitoring, Maintenance, and Optimization
Chapter 28 Monitoring and Optimizing MSDE
Chapter 29 Maintaining Databases with DBCC
Chapter 30 Improving the Performance of Data Access
Part VIII Database Deployment
Chapter 31 MSDE Deployment Overview
Chapter 32 Deploying MSDE with Access Projects
Chapter 33 Deploying MSDE with Visual Studio Projects
Appendix A What's On the CD-ROM
End-User License Agreement
CD-ROM Installation Instructions