Microsoft SQL Server(TM) 2000 Administrator's Companion (IT-Administrator's Companion)

Marci Frohock Garcia, Microsoft Press

ISBN:0735610517, Edition: , 2000-10-27

Price: $59.99

Contents

• Cover
  • LOC Page
• Acknowledgments
• Introduction
  • What This Book Is About
  • About the Companion CD
• Part I: Introduction to Microsoft SQL Server
  • Chapter 1 -- Overview of Microsoft SQL Server
    • SQL Server Systems
    • New Features and Enhancements of SQL Server 2000
    • Summary
  • Chapter 2 -- The Microsoft Windows 2000 Platform
    • The Windows 2000 Family
    • Windows 2000 Components and Features
    • Summary
  • Chapter 3 -- Roles and Responsibilities of the Microsoft SQL Server DBA
    • Basic and Optional Duties of the SQL Server DBA
    • DBA Tips and Techniques
    • Summary
• Part II: Installation and Setup
  • Chapter 4 -- Designing a Microsoft SQL Server System
    • System Requirements
    • System Components and Options
    • Database Layout
    • Application
    • Summary
  • Chapter 5 -- I/O Subsystem Configuration and Planning
    • Disk Drive Performance Characteristics
    • RAID Overview
    • I/O Subsystem Concepts
    • Overview of Common RAID Levels
    • RAID Level Performance Comparison
    • I/O Latencies and SQL Server
    • Planning the SQL Server Disk Layout
    • I/O Subsystem Tips and Recommendations
    • Summary
  • Chapter 6 -- Capacity Planning
    • Types of Capacity Planning
    • History of Capacity Planning
    • Transaction Processing
    • Principles of Capacity Planning
    • Capacity Planning for Memory
    • Capacity Planning for the Processor
    • Capacity Planning for the Disk Subsystem
    • Capacity Planning for the Network
    • Choosing the Data to Collect
    • Summary
  • Chapter 7 -- Installing Microsoft SQL Server
    • Server Installation
    • Upgrading from Earlier Versions
    • Client Installation
    • Summary
  • Chapter 8 -- Managing Microsoft SQL Server Services
    • SQL Server Services
    • Using SQL Server Service Manager
    • Using Windows 2000 Service Control Manager
    • Using SQL Server Enterprise Manager
    • Summary
  • Chapter 9 -- Creating Databases
    • Database Structure
    • System Databases
    • Database Creation
    • Database Viewing
    • Database Deletion
    • Summary
  • Chapter 10 -- Creating Database Tables
    • Laying the Groundwork
    • Reviewing Table Basics
    • Creating Tables in a Filegroup
    • Using Null Values
    • Adding the IDENTITY Property
    • Creating a Table Using Enterprise Manager
    • Summary
  • Chapter 11 -- Configuring Microsoft SQL Server on the Network
    • Overview of Network Services
    • SQL Server APIs
    • Network Libraries
    • Network Components and SQL Server Performance
    • Network Monitoring
    • Summary
  • Chapter 12 -- Microsoft SQL Server and Microsoft Cluster Services
    • Types of Failure
    • Overview of MSCS
    • Examples of Clustered Systems
    • SQL Server Cluster Configuration
    • Beyond MSCS
    • Summary
• Part III: Using Microsoft SQL Server
  • Chapter 13 -- Introduction to Transact-SQL and SQL Query Analyzer
    • What Is SQL?
    • What Is T-SQL?
    • A Review of New T-SQL Features
    • How to Use T-SQL
    • Summary
  • Chapter 14 -- Retrieving Data Using Transact-SQL
    • The SELECT Statement
    • T-SQL Functions
    • Other Uses for SELECT
    • Summary
  • Chapter 15 -- Managing Tables Using Transact-SQL and Enterprise Manager
    • Modifying a Table Using T-SQL
    • Modifying a Table Using Enterprise Manager
    • The Effects of Altering a Table
    • Dropping a Table
    • Summary
  • Chapter 16 -- Creating and Using Defaults, Constraints, and Rules
    • Defaults
    • Constraints
    • Rule Objects
    • Summary
  • Chapter 17 -- Creating and Using Indexes
    • What Is an Index?
    • Indexing Concepts
    • Creating Indexes
    • Rebuilding Indexes
    • Using Indexes
    • Designing Effective Indexes
    • Summary
  • Chapter 18 -- Creating and Using Views
    • What Is a View?
    • View Concepts
    • Creating Views
    • Altering and Dropping Views
    • View Enhancements in SQL Server 2000
    • Summary
  • Chapter 19 -- Understanding Transactions and Transaction Locking
    • What Is a Transaction?
    • ACID Properties
    • Transaction Modes
    • Transaction Rollbacks
    • Transaction Locking
    • Blocking and Deadlocks
    • Locking Hints
    • Summary
  • Chapter 20 -- Understanding Advanced T-SQL
    • The INSERT Statement
    • The UPDATE Statement
    • The DELETE Statement
    • Programming Keywords
    • Summary
  • Chapter 21 -- Creating and Managing Stored Procedures
    • What Is a Stored Procedure?
    • Creating Stored Procedures
    • Managing Stored Procedures by Using T-SQL
    • Summary
  • Chapter 22 -- Creating and Using Triggers
    • What Is a Trigger?
    • Trigger Enhancements in SQL Server 2000
    • When to Use Triggers
    • Creating Triggers
    • Managing Triggers
    • Summary
  • Chapter 23 -- Accessing Microsoft SQL Server from the Internet
    • Internet Programming Concepts
    • Using ISAPI to Access SQL Server
    • Using ASP to Access SQL Server
    • Using XML to Access SQL Server
    • Summary
  • Chapter 24 -- Loading the Database
    • Load Operation Performance
    • Bulk Copy Program
    • The BULK INSERT Statement
    • Data Transformation Services
    • Staging Tables
    • The SELECT...INTO Statement
    • Summary
• Part IV: Built-In Server Features
  • Chapter 25 -- Component Services and Microsoft Distributed Transaction Coordinator
    • Overview of Component Services
    • Microsoft Distributed Transaction Coordinator
    • Summary
  • Chapter 26 -- Microsoft SQL Server Replication: Overview and Snapshot Replication
    • What Is Database Replication?
    • Replication Concepts
    • Configuring Publishing and Distribution
    • Snapshot Replication
    • Managing Replication
    • Tuning for Snapshot Replication
    • Summary
  • Chapter 27 -- Transactional Replication
    • Introduction to Transactional Replication
    • Uses of Transactional Replication
    • Configuring the Transactional Replication System
    • Configuring, Monitoring, and Tuning the Distributor for Transactional Replication
    • Tuning for Transactional Replication
    • Implementing Transactional Replication
    • Summary
  • Chapter 28 -- Merge Replication
    • Introduction to Merge Replication
    • Uses of Merge Replication
    • Configuring the Merge Replication System
    • Managing Replication
    • Monitoring and Tuning the Merge Replication System
    • Summary
  • Chapter 29 -- Using Microsoft SQL Server Analysis Services
    • Overview of Analysis Services
    • Installing Analysis Services
    • Using Analysis Services
    • Summary
• Part V: Management, Tuning, Maintenance, and Troubleshooting
  • Chapter 30 -- Microsoft SQL Server Administration
    • Automatic Configuration Features of SQL Server
    • Database Maintenance Plans
    • Summary
  • Chapter 31 -- Automating Administrative Tasks
    • The SQLServerAgent Service
    • Jobs
    • Alerts
    • Operators
    • The SQLServerAgent Error Log
    • Summary
  • Chapter 32 -- Backing Up Microsoft SQL Server
    • Backup Terminology
    • System Failure
    • SQL Server Logging
    • Backup Methods
    • Performing a Backup
    • Scheduling Backups
    • Improving Backups
    • Summary
  • Chapter 33 -- Restoring and Recovering the Database
    • Restore Methods
    • Performing a Database Restore
    • Planning for Disaster Recovery
    • Summary
  • Chapter 34 -- User and Security Management
    • Creating and Administering User Logins
    • Administering Database Permissions
    • Administering Database Roles
    • Security Account Delegation
    • Summary
  • Chapter 35 -- Using SQL Query Analyzer and SQL Profiler
    • Using SQL Query Analyzer
    • Using SQL Profiler
    • Optimizing T-SQL Statements
    • Summary
  • Chapter 36 -- Solving Common Performance Problems
    • What Is a Bottleneck?
    • Discovering the Problem
    • Common Performance Bottlenecks
    • SQL Server Configuration Settings
    • Summary
• Part VI: Appendixes
  • Appendix A -- Microsoft SQL Server Configuration Parameters
    • Parameters
    • Parameter Specifications
    • Changing Parameters by Using Enterprise Manager
  • Appendix B -- Microsoft SQL Server Monitoring
    • SQL Server: Access Methods
    • SQL Server: Backup Device
    • SQL Server: Buffer Manager
    • SQL Server: Cache Manager
    • SQL Server: Databases
    • SQL Server: General Statistics
    • SQL Server: Latches
    • SQL Server: Locks
    • SQL Server: Memory Manager
    • SQL Server: Replication Agents
    • SQL Server: Replication Dist.
    • SQL Server: Replication Logreader
    • SQL Server: Replication Merge
    • SQL Server: Replication Snapshot
    • SQL Server: SQL Statistics
    • SQL Server: User Settable
  • Appendix C -- DBCC Commands
• Glossary
  • A
  • B
  • C
  • D
  • E
  • F
  • G
  • H
  • I
  • J
  • K
  • L
  • M
  • N
  • O
  • P
  • Q
  • R
  • S
  • T
  • U
  • V
  • W
• About The Authors
• About This Electronic Book
• About Microsoft Press