Beginning SQL Server 2005 Administration (with source code)

This book, as the title suggests, is all about database administration. But what is database administration? Database administrators 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 administrators 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 administrators 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 administrators are virtually unlimited.

Our primary audience is IT professionals (both developers and administrators) 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

Download here

Password:ganelon