Author(s) : Dan Wood, Chris Leiter, Paul Turley

Publisher : Wrox

Year : Nov 2006

ISBN 10 : 0470047046

ISBN 13 : 9780470047040

Language : English

Pages : 574

File type : PDF

Size : 4.6 MB (book + source code)



This book, as the title suggests, is all about database administration. But what is database administration? Database administrato are more and more often being called upon to perform duties that are not strictly “administrative” in nature. Along with typical administrative duties such as backups, database maintenance, and user management, database administrato are increasingly being asked to perform tasks such as building complex data transformations for data import, building distributed data solutions, and, with the release of SQL Server 2005, maintaining the security and integrity of the database while enabling the integration of managed code into the database engine.



This book lays the foundation by covering in detail the most common database administrative tasks. It also introduces you to many of the more advanced areas that enterprise database administrato need to be familiar with. Read these pages carefully, and apply what you learn. From here, move on to more complex jobs and tasks. The opportunities for talented and hard-working database administrato are virtually unlimited.



Our primary audience is IT professionals (both develope and administrato) who have found themselves responsible for the management and maintenance of a SQL Server 2005 database. You may have been responsible for a SQL Server 2000 database and were just getting used to that when your company decided to move to SQL Server 2005. The new features and new tool set can be intimidating.



TABLE OF CONTENT:

Chapter 01 - Introducing SQL Server 2005

Chapter 02 - Installing SQL Server 2005

Chapter 03 - SQL Server 2005 Tools

Chapter 04 - SQL Server 2005 Storage Architecture

Chapter 05 - SQL Server 2005 Databases

Chapter 06 - SQL Server 2005 Security

Chapter 07 - Configuring SQL Server Network Communication

Chapter 08 - Automating Administrative Tasks

Chapter 09 - Disaster Prevention and Recovery

Chapter 10 - Monitoring SQL Server for Performance

Chapter 11 - SQL Server High Availability

Chapter 12 - Administering SQL CLR Programming Objects

Chapter 13 - Introduction to SQL Server 2005 Integration Services

Chapter 14 - Introduction to SQL Server 2005 Notification Services

Chapter 15 - Introduction to the Service Broker

Chapter 16 - Introduction to Replication