Beginning SQL Server 2000 Dba: From Novice to Professional

by Bain, Tony; Benkovich, Michael; Freeman, Brian; Pavliashvili, Baya; Sack, Joseph; Bain, Tony

• ISBN13: 9781590592939
• ISBN10: 159059293X
• Format: Paperback
• Copyright: 2004-01-01
• Publisher: Springer-Verlag New York Inc
• More Book Details
• Purchase Benefits

Summary

The book teaches a database novice the core job and roles involved in administering a SQL Server database. It follows the lifecycle of the database, from installation, design and modeling, through development, tuning and securing to growth and migration. It provides practical advice ("How to..."), answers typical questions that they'll encounter from managers and developers ("How do I..."), and offers practical steps to overcome issues with which beginners traditionally struggle. At every stage, it establishes a range of tried-and-tested practices and techniques that will establish and maintain the health of a DB system ("How to be a good DBA").

Table of Contents

Introduction
Being a DBA	p. 1
SQL Server Installation	p. 21
Creating a Database	p. 93
DML and Querying	p. 147
Basic Management Tasks	p. 191
Security	p. 231
Connectivity	p. 291
Backup and Recovery	p. 331
Replication	p. 401
Development with Transact-SQL	p. 469
Data Warehousing and Analysis	p. 533
Data Transformation Services	p. 569
Monitor, Profile, and Tune	p. 601
Keeping the Plates Spinning	p. 625
Index	p. 653
Table of Contents provided by Blackwell. All Rights Reserved.