Microsoft SQL Server 7 DBA Survival Guide

Mark Spenik is the manager of Client/Server Technologies at Keiter, Stephens Computer Services, Inc in VA. He is a Microsoft Certified Solution Developer and charter member, and is frequently invited to speak at Microsoft Developer Days. He is also an MCSE, certified in Microsoft SQL Server administration, SQL Server database implementation, and Windows NT. Orryn Sledge is a Client/Server Project Manager in metropolitan Pittsburgh PA. In early 1995, he was one of the first developers in the nation to complete the MCSD program. He is also a MCSE, certified by Microsoft in SQL Server Administration, Implementation, and Windows NT Server/Workstation, WOSA I and II, and Access.

1. Introduction to Client/Server Database Computing. 2. The Role of the Database Administrator. II. THE WORLD OF MICROSOFTS SQL SERVER. 3. The Evolution Of SQL Server /Repository/06723/0672312263/conversion/html/0672312263/element_004.html/Repository/06723/0672312263/conversion/html/0672312263/element_004.html. 4. SQL Server Overview. III. INSTALLING AND UPGRADING SQL SERVER. 5. Planning an Installation or Upgrade. 6. Installing or Upgrading SQL Server. IV. DATABASE OPERATION. 7. Enterprise Management Processes. 8. Database Management. 9. Managing SQL Server Users and Security. 10. Backup and Restore. 11. Using BCP. 12. Distributed Transaction Coordinator. 13. Troubleshooting SQL Server. 14. Miscellaneous Topics and New SQL Server Utilities. V. REPLICATION. 15. Replication. 16. Transactional Replication. 17. Snapshot and Merge Replication. VI. PERFORMANCE AND TUNING. 18. SQL Server Internals - Changes and Enhancements. 19. Monitoring SQL Server. 20. Configuring and Tuning SQL Server. 21. Database Design Issues. 22. Understanding Indexes. 23. Query Optimization. 24. Multi-User Considerations. VII. ADVANCED DBA TOPICS. 25. SQL Essentials. 26. Using Stored Procedures and Cursors. 27. Using SQL-DMO (Distributed Management Objects). 28. SQL Server 7.0 and the Internet. VIII. Automating Maintenance And Administration Tasks. 29. Developing a SQL Server Maintenance Plan. 30. Automating Database Administration Tasks. IX. DATA WAREHOUSING. 31. Introduction to Data Warehousing. 32. Using Data Transformation Services (DTS). 33. Introduction to Microsoft SQL Server OLAP Services. X. APPENDIXES. Appendix A: Naming Conventions. Appendix B: DBCC Commands. Appendix C: SQL Server Resources.