Amazon no longer offers textbook rentals. We do!

Msce Guide to SQL Server Administration

by: RAFTREE

Msce Guide to SQL Server Administration

by: RAFTREE

ISBN 13:
9780619035532
ISBN 10:
0619035536
Format: Paperback
Copyright: 08/08/2001
Publisher: Course Technology
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

Comprehensive material prepares individuals for the MCSE/MCDBA exam #70-228, Implementing and Administering SQL Server 2000 Enterprise Edition.

Preface

xvii

An Introduction to Microsoft SQL Server 2000

(22)

Where it All Began: A Brief History of the Structured Query Language

(1)

Database Architecture

(1)

Relational Database Concepts

(1)

Introducing Microsoft SQL Server 2000

(1)

Features of SQL Server 2000

(8)

Scalability and Availability

(2)

Database Features

(1)

Administrative Features

(2)

Internet Enabled Features

(1)

Components of SQL Server 2000

(2)

Chapter Summary

(1)

Key Terms

(1)

Review Questions

(3)

Hands-on Projects

(3)

Case Project

(1)

Optional Case Projects for Teams

(1)

Installing and Upgrading SQL Server 2000

(38)

Hardware and Software Requirements of SQL Server 2000

(1)

Additional Software Requirements

(1)

Installing SQL Server 2000

(21)

Running the Setup Program

(2)

Installing SQL Server on a Local Computer

(11)

Collation Considerations

(5)

Failover Clustering Considerations

(1)

Advanced Installation Options

(1)

SQL Server 2000 Upgrades

(3)

Upgrading from SQL Server 7.0

(1)

Upgrading from SQL Server 6.5

(1)

Upgrading Editions of SQL Server 2000

(1)

Troubleshooting Installations and Upgrades

(1)

Useful Files for Diagnosing Problems

(1)

Chapter Summary

(1)

Key Terms

(2)

Review Questions

(3)

Hands-on Projects

(3)

Case Projects

(3)

Administering and Configuring SQL Server 2000

(48)

Client Applications Installed with SQL Server 2000

(2)

Books Online

(1)

Client Network Utility

(1)

Configure SQL XML Support in IIS

(1)

Enterprise Manager

(1)

Import and Export Data

(1)

Profiler

(1)

Query Analyzer

(1)

Server Network Utility

(1)

Services Manager

(1)

Exploring Enterprise Manager

(3)

Server Groups

(2)

Registering Servers

(1)

Query Analyzer

(11)

Configuring a Registered SQL Server

(10)

Configuring E-mail for SQL Server 2000

(4)

Linked Servers

(5)

Command Line Utilities

(3)

Osql Utility

(2)

SQLDIAG Utility

(1)

Chapter Summary

(1)

Key Terms

(1)

Review Questions

(4)

Hands-on Projects

(10)

Case Projects

106

(3)

SQL Server 2000 Database Architecture

109

(34)

Storing Data

110

(2)

Physical Data Storage

110

(2)

Database Objects

112

(9)

Tables

112

(2)

Defaults

114

(1)

Constraints

114

(6)

Triggers

120

(1)

User-Defined Functions

120

(1)

Transaction Architecture

121

(5)

Transaction Management

122

(1)

Transaction Logs

122

(1)

Transactional Locking

123

(3)

Chapter Summary

126

(1)

Key Terms

127

(1)

Review Questions

128

(3)

Hands-on Projects

131

(9)

Case Projects

140

(3)

Creating SQL Server 2000 Databases

143

(50)

Types of Databases

144

(1)

Files and Filegroups

145

(1)

Files

145

(1)

Filegroups

146

(1)

Creating a Database

146

(6)

Managing Files and Filegroups

148

(2)

Creating Databases with T-SQL Statements

150

(2)

Modifying Databases

152

(12)

Expanding Databases

152

(3)

Shrinking a Database

155

(2)

Changing the Default Filegroup

157

(1)

Configuration Settings

158

(3)

Attaching and Detaching Databases

161

(2)

Renaming Databases

163

(1)

Deleting Databases

163

(1)

Database Objects

164

(19)

General Considerations

165

(4)

Creating Tables

169

(2)

Managing Table Properties

171

(5)

Views

176

(5)

Stored Procedures

181

(1)

Triggers

182

(1)

Chapter Summary

183

(1)

Key Terms

183

(1)

Review Questions

184

(3)

Hands-on Projects

187

(6)

Case Projects

193

(1)

Optimizing and Troubleshooting Databases

193

(44)

Optimizing Databases

194

(2)

Placing Indexes and Tables

194

(2)

Performance Enhancements through RAID

196

(3)

RAID 0

196

(1)

RAID 1

197

(1)

RAID 5

198

(1)

Parity at Work

199

(2)

RAID 10

199

(1)

Using RAID Arrays and Clustering

200

(1)

Indexing Recommendations

201

(2)

Understanding when Indexes Are Recommended

201

(1)

Recommendations for Designing Indexes

202

(1)

Page Splits and Fragmentation

203

(1)

Avoiding Fragmentation

203

(1)

Execution Plans and Statistics

204

(6)

Statistics

204

(1)

Viewing Execution Plans

205

(5)

Diagnosing Database Problems

210

(6)

SQL Profiler

210

(3)

Monitoring Process Activity with Enterprise Manager

213

(1)

Monitoring Process Activity with System-Stored Procedures

214

(1)

Terminating Blocking Processes

215

(1)

Chapter Summary

216

(1)

Key Terms

216

(1)

Review Questions

217

(5)

Hands-on Projects

222

(14)

Case Projects

236

(1)

Performing Disaster Recovery Operations

237

(46)

Planning for Disaster

238

(1)

Backup Operations

238

(4)

Full Database Backup Operation

239

(1)

Differential Database Backup Operation

240

(1)

Transaction Log Backup Operation

240

(1)

File Backup Operation

241

(1)

SQL Server 2000 Recovery Models

242

(6)

Simple Recovery

243

(1)

Full Recovery and Bulk-Logged Recovery

244

(3)

Configuring the Recovery Model of Databases

247

(1)

Backup Devices

248

(2)

Disk Devices

248

(1)

Tape Devices

249

(1)

Microsoft Tape Format

249

(1)

Managing Database Backups

250

(4)

Performing Backups with Enterprise Manager

250

(2)

Performing Backups with Transact-SQL

252

(2)

Restoring Databases

254

(3)

Restoring Databases with Enterprise Manager

254

(2)

Restoring Databases with Transact-SQL

256

(1)

Database Consistency and the DBCC statement

257

(2)

Database Maintenance Plans

259

(6)

Standby Servers and Log Shipping

265

(1)

Log Shipping

265

(1)

Chapter Summary

266

(1)

Key Terms

267

(1)

Review Questions

268

(5)

Hands-on Projects

273

(9)

Case Projects

282

(1)

Security in SQL Server 2000

283

(44)

Security Architecture in SQL Server 2000

284

(2)

Logins

286

(5)

Authentication Modes

286

(2)

Managing Logins in SQL Server 2000

288

(3)

Database Users

291

(6)

Roles

291

(4)

Creating Database Users

295

(2)

Permissions

297

(6)

Object Permissions

297

(1)

Statement Permissions

297

(1)

Implied Permissions

298

(1)

Applying Permission

298

(5)

Implementing Security through Database Objects

303

(2)

Securing Data with Views

303

(1)

Securing Data with Stored Procedures and User-Defined Functions

303

(1)

Controlling Access with Triggers

303

(1)

Understanding Ownership Chains

304

(1)

Auditing Security in SQL Server 2000

305

(2)

C2 Auditing

306

(1)

Chapter Summary

307

(1)

Key Terms

307

(1)

Review Questions

308

(3)

Hands-on Projects

311

(13)

Case Projects

324

(3)

Extracting and Transforming Data with SQL Server 2000

327

(52)

The Bulk Insert Statement

328

(3)

Architecture

328

(1)

Bulk Insert Statement Syntax

328

(2)

The Bulk Insert Statement in Action

330

(1)

Bulk Insert Statement Usage Scenarios

330

(1)

Bulk Insert Statement Performance

330

(1)

Bulk Copy Program

331

(2)

BCP Syntax

331

(1)

BCP in Action

332

(1)

BCP Usage Scenarios

333

(1)

BCP Performance

333

(1)

Data Transformation Services

333

(12)

Interface

334

(1)

Executing a Transformation Using DTS

335

(6)

Saving DTS Packages

341

(2)

Editing DTS Packages

343

(1)

DTS in Action

344

(1)

Replication

345

(9)

Uses of Replication

346

(1)

Replication Overview

346

(1)

Snapshot Replication

347

(1)

Usage Scenarios for Snapshot Replication

348

(1)

Transactional Replication

348

(1)

Usage Scenarios for Transactional Replication

349

(1)

Merge Replication

350

(1)

Usage Scenarios for Merge Replication

351

(1)

Replication Tools

351

(2)

Filtering Published Data

353

(1)

Replication Performance Optimization

353

(1)

Heterogeneous Queries

354

(4)

Configuring a Linked Server

354

(1)

Managing a Linked Server Definition

355

(3)

XML Support in SQL Server 2000

358

(5)

Configuring Internet Information Services for XML Support

359

(1)

Virtual Directories

360

(1)

Virtual Names

361

(2)

Chapter Summary

363

(1)

Key Terms

363

(1)

Review Questions

364

(4)

Hands-on Projects

368

(10)

Case Projects

378

(1)

Automating and Monitoring SQL Server 2000

379

(54)

SQL Server 2000 Automation

380

(1)

SQL Server Agent

380

(5)

Jobs

380

(1)

Alerts

381

(1)

Operators

382

(2)

Multiserver Automation

384

(1)

Configuring SQL Server Agent

385

(2)

Advanced Tab

385

(1)

Connection Tab

386

(1)

Creating and Configuring Jobs, Alerts, and Operators

387

(20)

Creating Operators

387

(5)

Creating Jobs

392

(9)

Creating Alerts

401

(6)

Windows Performance Monitor and SQL Server 2000

407

(5)

Monitoring for Bottlenecks With Windows System Monitor

409

(3)

Chapter Summary

412

(1)

Key Terms

413

(1)

Review Questions

413

(5)

Hands-on Projects

418

(9)

Case Projects

427

(6)

APPENDIX Exam Objectives for MCSE Certification

433

(6)

Installing and Configuring SQL Server 2000

433

(1)

Creating SQL Server 2000 Databases

434

(1)

Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases

435

(1)

Extracting and Transforming Data with SQL Server 2000

436

(1)

Managing and Monitoring SQL Server 2000 Security

437

(1)

Managing, Monitoring, and Troubleshooting SQL Server 2000

438

(1)

Glossary

439

(8)

Index

447

Amazon no longer offers textbook rentals. We do!

Msce Guide to SQL Server Administration

Msce Guide to SQL Server Administration

9780619035532

0619035536

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Msce Guide to SQL Server Administration

Msce Guide to SQL Server Administration

9780619035532

0619035536

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products