Microsoft SQL Server 7 DBA Survival Guide is organized into several parts that compromise the various jobs and tasks the DBA performs. Learn client/server computing and the role of the database administrator, how to plan and install/upgrading SQL Server, database operation, performance and tuning, and maintaining the shop. This book provides the knowledge and know-how to administer a SQL Server database. Through real-world insight and experience, you'll learn the tips, tricks, and suggestions you need to succeed as a DBA. Checklists and examples for SQL Server DBA tasks are provided, as well as conventions and naming standards. Also included is a section that looks into the tasks that make up a DBA's job description.
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 231 mm
Breite: 187 mm
Dicke: 55 mm
Gewicht
ISBN-13
978-0-672-31226-7 (9780672312267)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
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.
