Microsoft SQL Server 2000 DBA Survival Guide

Mark Spenik, Orryn Sledge

1028 pages, parution le 04/11/2002 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

Microsoft SQL Server 2000 DBA Survival Guide is organized into several parts that comprise the various jobs and tasks the DBA performs. Each chapter is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL Server database. The chapters also offer real-world insight and experience by passing on tips, tricks, and suggestions based on what the authors have learned the hard way. The book also takes time to provide checklists and examples for various SQL Server DBA tasks. The book also provides insight into the tasks that make-up a DBA's job including discussions of topics such as the creation of naming standards and conventions which are essential for efficient administration.

Contents

I. OVERVIEW.
1. Role of the Database Administrator.
2. SQL Server Overview.
3. The Evolution of SQL Server.
II. INSTALLING AND UPGRADING SQL SERVER.
4. Planning an Installation or Upgrade.
5. Installing or Upgrading SQL Server.
III. SQL SERVER MANAGEMENT AND CONFIGURATION.
6. Enterprise Management Processes.
7. Configuring and Tuning SQL Server.
8. Managing Databases.
9. Managing SQL Server Users and Security.
IV. DATABASE BACKUP AND RECOVERY.
10. Backup and Recovery.
V. SQL DATABASE MAINTENANCE.
11. Developing a SQL Server Maintenance Plan.
12. Automating Database Administration Tasks.
VI. IMPORTING AND EXPORTING DATA.
13. Data Transformation Services.
14. Using BCP and BULK INSERT.
VII. TROUBLESHOOTING.
15. Troubleshooting SQL Server.
VIII. ARCHITECTURE AND DATABASE DESIGN.
16. Architecture Features.
17. Database Design Issues.
IX. PERFORMANCE AND TUNING.
18. Understanding Indexes.
19. Query Optimization.
20. Multiuser Issues.
X. TRANSACT-SQL.
21. SQL Essentials.
22. Using Stored Procedures and Cursors.
XI. ADVANCED DBA TOPICS.
23. SQL Server 2000 and the Internet.
24. Monitoring SQL Server.
25. SQL Mail.
26. Using SQL-DMO.
XII. REPLICATION.
27. Replication.
28. Transactional Replication.
29. Snapshot and Merge Replication.
XIII. DATA WAREHOUSING.
30. Introduction to Data Warehousing.
31. SQL 2000 Analysis Services.
XIV. APPENDIXES.
Appendix A. Naming Conventions.
Appendix B. DBCC Commands.
Appendix C. SQL Server Resources.

L'auteur - Mark Spenik

Mark Spenik is the manager of Client/Server technologies at Keiter, Stephens Computer Services, Inc. in VA. He is an MCSD 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.

L'auteur - Orryn Sledge

Orryn Sledge is a Client/Server Project Manager in metropolitan Pittsburgh, PA. In early 1995, he was one of the first 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.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Sams
Auteur(s)	Mark Spenik, Orryn Sledge
Parution	04/11/2002
Édition	2^eme édition
Nb. de pages	1028
Format	18,5 x 23
Couverture	Broché
Poids	1620g
Intérieur	Noir et Blanc
EAN13	9780672324680
ISBN13	978-0-672-32468-0