Professional SQL Server 2005 Administration

Brian Knight, Ketan Patel, Wayne Snyder, Jean-Claude Armand, Ross LoForte, Brad McGehee, Steve Elsworth, Joe Salvatore, Haidong Ji

734 pages, parution le 14/12/2006

Ajouter à une liste

Indisponible

Résumé

SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration.

Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005.

What you will learn from this book

How to use some of the more advanced concepts of installation
Techniques for properly administering development features such as SQL CLR
Ways to secure your SQL Server from common threats
How to choose the right hardware configuration
Best practices for backing up and recovering your database
Step-by-step guidelines for clustering your SQL Server

Who this book is for

This book is for experienced developers and database administrators who plan to administer or are already administering an SQL Server 2005 system and its business intelligence features.

L'auteur - Brian Knight

Brian Knight, SQL Server MVP, MCSE, MCDBA, is the cofounder of SQLServerCentral.com and was recently on the Board of Directors for the Professional Association for SQL Server (PASS). He runs the local SQL Server users group in Jacksonville, Florida (JSSUG). Brian is a contributing columnist for SQL Server Standard and also maintains a weekly column for the database Web site SQLServerCentral.com. He is the author of Admin911: SQL Server (Osborne/McGraw-Hill Publishing) and coauthor of Professional SQL Server DTS and Professional SQL Server 2005 SSIS (Wiley Publishing). Brian has spoken at such conferences as PASS, SQL Connections, and TechEd.

Sommaire

SQL Server 2005 Architecture
SQL Server 2005 Installation Best Practices
Upgrading SQL Server 2005 Best Practices
Managing and Troubleshooting the Database Engine
Automating SQL Server
Integration Services Administration and Performance Tuning
Analysis Services Administration and Performance Tuning
Administering the Development Features
Securing the Database Engine
Change Management
Configuring the Server for Optimal Performance
Optimizing SQL Server 2005
Monitoring Your SQL Server
Performance Tuning T-SQL
Indexing Your Database
Replication
Database Mirroring
Backup and Recovery
SQL Server 2005 Log Shipping
Clustering SQL Server 2005
Appendix A: Raymond James Lab Report
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Brian Knight, Ketan Patel, Wayne Snyder, Jean-Claude Armand, Ross LoForte, Brad McGehee, Steve Elsworth, Joe Salvatore, Haidong Ji
Parution	14/12/2006
Nb. de pages	734
Format	18,5 x 23,5
Couverture	Broché
Poids	1084g
Intérieur	Noir et Blanc
EAN13	9780470055205