Microsoft SQL Server 2000 Administrators Companion

ISBN: B001HC0RPI
EAN: N/A

Year: 2005
Pages: 264

BUY ON AMAZON

Cover
LOC Page
Acknowledgments
Introduction
What This Book Is About
About the Companion CD
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
Chapter 4 -- Designing a Microsoft SQL Server System
System Requirements
System Components and Options
Database Layout
Application
Summary
Chapter 5 -- IO Subsystem Configuration and Planning
Disk Drive Performance Characteristics
RAID Overview
IO Subsystem Concepts
Overview of Common RAID Levels
RAID Level Performance Comparison
IO Latencies and SQL Server
Planning the SQL Server Disk Layout
IO 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
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
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
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
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