SQL Server 2005 Administrator's Pocket Consultant
Portable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of SQL Server 2005. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the precise information you need to solve problems and get the job done whether you’re at your desk or in the field!
Get fast facts to:
- Install, configure, and tune SQL Server
- Administer servers and server groups
- Manage and optimize schemas, tables, indexes, and views
- Create logins, configure permissions, assign roles, and perform other essential security tasks
- Import, export, and transform data from various sources
- Implement replication and data merging, and manage data publication and subscription
- Plan and implement a comprehensive backup and recovery strategy
- Monitor server activity and resolve performance issues
- Take charge of automation and maintenance
CONTENTS:
Acknowledgments Introduction Part I: Microsoft SQL Server 2005 Administration Fundamentals
- Chapter 1: Microsoft SQL Server 2005 Administration Overview
- Chapter 2: Deploying Microsoft SQL Server 2005
- Chapter 3: Managing the Surface Security, Access, and Network Configuration
- Chapter 4: Configuring and Tuning Microsoft SQL ServerPart II: Microsoft SQL Server 2005 Administration
- Chapter 5: Managing the Enterprise
- Chapter 6: Configuring SQL Server with SQL Server Management Studio
- Chapter 7: Core Database Administration
- Chapter 8: Managing SQL Server 2005 SecurityPart III: Microsoft SQL Server 2005 Data Administration
- Chapter 9: Manipulating Schemas, Tables, Indexes, and Views
- Chapter 10: Importing, Exporting, and Transforming Data
- Chapter 11: Linked Servers and Distributed Transactions
- Chapter 12: Implementing Snapshot, Merge, and Transactional ReplicationPart IV: Microsoft SQL Server 2005 Optimization and Maintenance
- Chapter 13: Profiling and Monitoring Microsoft SQL Server 2005
- Chapter 14: Backing Up and Recovering SQL Server 2005
- Chapter 15: Database Automation and MaintenanceAppendix : William R. Stanek