Microsoft SQL Server 2005 Administrator's Consultant - Brossura

Stanek, William R.

Brossura

ISBN 10: 0735621071 ISBN 13: 9780735621077

Casa editrice: Microsoft Pr, 2005

Riassunto

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

Su questo libro

L'autore

William R. Stanek is a Microsoft MVP with 20+ years of experience in systems management and advanced programming. He is an award-winning author who’s written more than 100 books, including Windows 7 Administrator’s Pocket Consultant and Windows Server 2008 Inside Out. He is the series editor for the Pocket Consultant line of books.

Contenuti

AcknowledgmentsIntroductionPart 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 Server

Part 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 Security

Part 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 Replication

Part 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 Maintenance

Appendix : William R. Stanek

Dettagli dell?edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2005
• ISBN 10: 0735621071
• ISBN 13: 9780735621077
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 549