Microsoft SQL Server 2000 Database Administrators Guidebook

Carl H. Speshock

  • 出版商: Prentice Hall
  • 出版日期: 2001-10-26
  • 售價: $1,680
  • 貴賓價: 9.5$1,596
  • 語言: 英文
  • 頁數: 480
  • 裝訂: Paperback
  • ISBN: 0130614300
  • ISBN-13: 9780130614308
  • 相關分類: MSSQLSQL資料庫
  • 已過版

買這商品的人也買了...

商品描述

Microsoft SQL Server 2000 Database Administrators Guidebook is a start-to-finish guide to every technical and business skill DBAs need to maximize SQL Server performance, security, and scalability. Coverage includes planning, design, installation, optimization, automation, clustering, technical writing, data modeling, and more. Also included: practical help for DBAs migrating from Oracle or Sybase - plus expert guidance for managers who hire DBAs. The CD-ROM includes an extensive library of support documents and scripts.

Table of Contents

Preface.

I. DATABASE ADMINISTRATOR SKILL SETS AND AREAS OF RESPONSIBILITY.

1. Windows NT/2000 Administration for the SQL Server Database Administrator.
2. Designing SQL Server Systems.
3. Installing and Upgrading SQL Server/Applying Service Packs.
4. Configuring SQL Server.
5. Database Implementation.
6. Tuning and Monitoring SQL Server. Tools for Tuning and Monitoring SQL Server 2000. Query Optimization.
7. Backing Up and Restoring SQL Server.
8. SQL Server Replication.
9. OLAP Administration via Microsoft SQL Server Analysis Services.
10. Server and Database Security Administration.
11. Failover Clustering.
12. Data Modeling.
13. Data Transformation and Loading.
14. Technical Writing and Verbal Communication Skills.

II. SQL SERVER DATABASE ADMINISTRATOR SELECTION AND STARTING YOUR NEW JOB.


15. Interviewing, Type of Employee, and Starting Your New Job.

III. MIGRATING FROM ORACLE OR SYBASE TO MICROSOFT SQL SERVER.


16. Migrating from Oracle to Microsoft SQL Server.
17. Migrating from Sybase to Microsoft SQL Server.
Appendix A: Resources to Acquire or Enhance SQL Server DBA Skills.
Appendix B: Contents of the CD-ROM.
Appendix C: Reserved Keywords.
Appendix D: Database Consistency Check (DBCC) Commands.
Glossary.
Index.