Beginning SQL Server 2005 Administration

Dan Wood, Chris Leiter, Paul Turley

574 pages, parution le 05/12/2006

Ajouter à une liste

Indisponible

Résumé

For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.

Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.

What you will learn from this book

How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations
Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker
How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance, and monitoring
A sampling of some of the more advanced areas and complex jobs of the broadening role of a database administrator in the enterprise

Who this book is for

This book is for both developers and administrators who are responsible for the management and maintenance of an SQL Server 2005 database. Familiarity with relational database concepts and SQL is assumed.

Sommaire

Introducing SQL Server 2005
Installing SQL Server 2005
SQL Server 2005 Tools
SQL Server 2005 Storage Architecture
SQL Server 2005 Databases
SQL Server 2005 Security
Configuring SQL Server Network Communication
Automating Administrative Tasks
Disaster Prevention and Recovery
Monitoring SQL Server for Performance
SQL Server High Availability
Administering SQL CLR Programming Objects
Introduction to SQL Server 2005 Integration Services
Introduction to SQL Server 2005 Notification Services
Introduction to the Service Broker
Introduction to Replication
Appendix A: Exercise Answers
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Dan Wood, Chris Leiter, Paul Turley
Parution	05/12/2006
Nb. de pages	574
Format	18,5 x 23,5
Couverture	Broché
Poids	862g
Intérieur	Noir et Blanc
EAN13	9780470047040
ISBN13	978-0-470-04704-0