Microsoft SQL Server 2005

Administrator's Companion

Edward Whalen, Marcilina Garcia, Burzin Patel, Stacia Misner, Victor Isakov - Collection Administrator's Compagnion

1200 pages, parution le 25/11/2006

Ajouter à une liste

Indisponible

Résumé

Your one-volume guide to planning, deployment, administration, and support.

Get your mission-critical databases up and running quickly with this essential, single-volume guide. This comprehensive administrator's reference details features and capabilities of SQL Server 2005-including how to implement business intelligence applications. It delivers the easy-to-follow procedures, practical workarounds, and key troubleshooting tactics you need for on-the-job-results.

Discover how to:

Perform an installation or upgrade, and configure it on the network
Plan and configure the I/O subsystem and model system capacity
Create and maintain databases, tables, views, and indexes
Administer transactions, deadlocks, and isolation levels
Manage users with logins, user IDs, schemas, permissions, and roles
Implement failover clustering, log shipping, and database mirroring for high availability
Manage and tune snapshot, transactional, and merge replication
Administer SQL Server Analysis Services and Reporting Services
Monitor, troubleshoot, and fine-tune performance

Includes a CD with a fully searchable eBook.

L'auteur - Marcilina Garcia

Marcilina Garcia

is a senior consultant at Performance Tuning Corporation. While at PTC she has participated in many SQL Server TPC-C benchmarks and is an expert on Microsoft SQL Server 7.

L'auteur - Victor Isakov

Victor Isakov is a database architect and Microsoft certified trainer based in Sydney, Australia. He provides consulting and training services to organizations in the public, private, and NGO sectors globally. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server 2005 Certification and Microsoft Official Curriculum for both ILT and e-Learning.

Sommaire

Introduction to Microsoft SQL Server 2005
- What's New in Microsoft SQL Server
- Microsoft SQL Server 2005 Editions, Capacity Limits, and Licensing
- Roles and Responsibilities of the Microsoft SQL Server DBA
System Design and Architecture
- I/O Subsystem Planning and RAID Configuration
- 32-Bit Versus 64-Bit Platforms and Microsoft SQL Server 2005
- Capacity Planning
- Choosing a Storage System for Microsoft SQL Server 2005
- Installing and Upgrading Microsoft SQL Server 2005
- Configuring Microsoft SQL Server 2005 on the Network
Microsoft SQL Server 2005 Administration
- Creating Databases and Database Snapshots
- Creating Tables and Views
- Creating Indexes for Performance
- Enforcing Data Integrity
- Backup Fundamentals
- Restoring Data
- User and Security Management
Microsoft SQL Server 2005 Architecture and Features
- Transactions and Locking
- Microsoft SQL Server 2005 Memory Configuration
- Data Partitioning
Microsoft SQL Server 2005 Business Intelligence
- Replication
- Integration Services
- Analysis Services
- Reporting Services
- Notification Services and Service Broker
High Availability
- Disaster Recovery Solutions
- Failover Clustering Installation and Configuration
- Log Shipping and Database Mirroring
Performance Tuning and Troubleshooting
- Troubleshooting, Problem Solving, and Tuning Methodologies
- Database System Tuning
- Using Profiler, Management Studio, and Database Engine Tuning Advisor
- Dynamic Management Views]
- Microsoft SQL Server 2005 Scalability Options]
- Tuning Queries Using Hints and Plan Guides ]

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Edward Whalen, Marcilina Garcia, Burzin Patel, Stacia Misner, Victor Isakov
Collection	Administrator's Compagnion
Parution	25/11/2006
Nb. de pages	1200
Format	19,5 x 24
Couverture	Relié
Poids	1950g
Intérieur	Noir et Blanc
EAN13	9780735621985
ISBN13	978-0-7356-2198-5