Microsoft SQL Server 2000 DBA Survival Guide

Front Cover
Sams Publishing, 2002 - Computers - 1001 pages

Microsoft SQL Server 2000 DBA Survival Guide is organized into several parts that comprise the various jobs and tasks the DBA performs. Each chapter is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL Server database. The chapters also offer real-world insight and experience by passing on tips, tricks, and suggestions based on what the authors have learned the hard way. The book also takes time to provide checklists and examples for various SQL Server DBA tasks. The book also provides insight into the tasks that make-up a DBA's job including discussions of topics such as the creation of naming standards and conventions which are essential for efficient administration.

 

What people are saying - Write a review

User Review - Flag as inappropriate

Importante Book about database adminstation

Contents

Introduction
1
Part III
2
22
3
Part Overview
9
SQL Server Overview
23
The Evolution of SQL Server
45
Part Installing and Upgrading SQL Server
51
Installing or Upgrading SQL Server
77
Troubleshooting
427
Architecture and Database Design
457
Database Design Issues
467
Performance and Tuning
481
Query Optimization
507
Multiuser Issues
537
TransactSQL
563
Using Stored Procedures and Cursors
593

SQL Server Management and Configuration
109
Connecting to a Server
116
SQL Server Query Analyzer
135
SQL Server 2000 SelfTuning Features
147
Configuration Parameters
150
Configuration FAQ
163
Managing Databases
165
Managing SQL Server Users and Security
203
Database Backup and Recovery
237
Backup Wizard
257
Restoring the master Database
271
Backup and Restore FAQ
294
SQL Database Maintenance
299
Automating Database Administration Tasks
313
Importing and Exporting Data
353
Using the DTS Designer
370
Using BCP and BULK INSERT
397
Permissions Required to Run BCP
404
Sample BCP Scripts
410
How to Modify a Stored Procedure
600
Parameters Used with Stored Procedures
607
Advanced DBA Topics
637
SQL Server 2000 and Managing Web Assistant Jobs
663
Integration
676
SQL Server and the Web FAQ
682
Monitoring SQL Server
685
SQL Mail
703
Using SQLDMO
711
Replication
749
Transactional Replication
779
Snapshot and Merge Replication
803
Data Warehousing
833
SQL 2000 Analysis Services
855
Appendixes
893
Resolving Errors Reported by DBCC
903
Trace Flag Commands
917
Index
929
Copyright

Other editions - View all

Common terms and phrases

About the author (2002)

Mark Spenik is the vice president of Enterprise Technologies at Venturi Technology Partners located in Richmond, VA. Mark, a graduate of George Mason University in Fairfax, VA., entered the computer industry in 1985. He has designed and coded large-scale applications and has consulted with numerous firms in application development, implementation, and migration. He has a broad programming background, including assembly language, C, C++, HTML, Active Server Pages, and Visual Basic. Mark is a Microsoft Certified Solution Developer (MCSD) and charter member, and is frequently invited to speak at various developer conferences and seminars. Mark has also coauthored or contributed to several books on Microsoft SQL Server or Visual Basic. Mark can be reached via the Internet mspenik@venturipartners.com.

Orryn Sledge is a Practice Director with FullTilt in Pittsburgh, PA. He specializes in managing and developing large-scale eBusiness solutions. His background includes SQL Server, Microsoft's .NET platform, Plumtree, Oracle, and other popular eBusiness products. He has been actively involved with SQL Server consulting since 1992 and is a Microsoft Certified Solution Developer (MCSD). Orryn is also a frequent speaker at various Microsoft conferences and presentations. He can be reached at osledge@fulltilt.com.

Bibliographic information