Microsoft SQL Server 7.0 Administrator's Guide

by Talmage, Ron

• ISBN13: 9780761513896
• ISBN10: 0761513892
• Edition: CD
• Format: Hardcover
• Copyright: 1999-04-01
• Publisher: Cengage Learning Ptr

Summary

This narrative reference covers all the major activities in which SQL Server administrators must engage. It also includes tutorials for complex issues and helps administrators avoid costly mistakes and dead ends by providing clear explanations, justifications for preferred practices, and comprehensive checklists for administering SQL Server 7.0.

Author Biography

Ronald R. Talmage is a DBA with GTE Enterprise Solutions in Kirkland, WA, and a SQL Server instructor for ST Labs in Bellevue, WA. He has several years' experience administering SQL Server as well as designing and developing SQL Server databases. He is a Microsoft Certified Professional (MCP) and SQL Server MVP; he has an MCP in SQL Server administration and design, and also an MCSD.

Table of Contents

Introduction	xxv
Part I SQL Server 7.0 Overview	1	(52)
Background	3	(36)
Architecture	39	(14)
Part II Setting Up SQL Server 7.0	53	(128)
Installing	55	(40)
Upgrading	95	(24)
Configuring	119	(30)
Connectivity	149	(32)
Part III Administration	181	(130)
Managing Databases	183	(26)
Backup and Restore	209	(24)
Security	233	(22)
Importing and Exporting	255	(24)
SQL Server Agent	279	(32)
Part IV Managing Data	311	(226)
Data Definition	313	(38)
Data Manipulation	351	(66)
English Query	417	(20)
Basics of Transact-SQL Programming	437	(28)
Transactions	465	(26)
Stored Procedures	491	(18)
Triggers	509	(28)
Part V Performance	537	(106)
Tuning Queries	539	(26)
Concurrency Tools	565	(22)
Profiler and Perfmon	587	(28)
Database Load Testing	615	(28)
Part VI Integration	643	(100)
Distributed Data	645	(24)
Replication	669	(30)
OLAP Services	699	(44)
Appendixes
A References	727	(6)
B Bibliography	733	(4)
C What's On the CD?	737	(6)
Index	743