Microsoft SQL Server 2000 DBA Survival Guide

Front Cover
Sams Publishing, 2003 - Computers - 1001 pages
1 Review

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
Overview
7
SQL Server Overview
23
The Evolution of SQL Server
45
Installing and Upgrading SQL Server
51
Architecture and Database Design
58
Installing or Upgrading SQL Server
77
SQL Server Management and Configuration
109
Using BCP and BULK INSERT
397
Troubleshooting
427
Architecture and Database Design
459
Database Design Issues
467
Performance and Tuning
481
Query Optimization
507
Multiuser Issues
537
TransactSQL
563

SQL Server Management and Configuration
138
Configuring and Tuning SQL Server
139
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 Stored Procedures and Cursors
593
Advanced DBA Topics
637
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
SQL Server Resources
925
Index
929
Copyright

Other editions - View all

Common terms and phrases

References to this book

About the author (2003)

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