Microsoft SQL Server 2005
Administrator's Companion
Edward Whalen, Marcilina Garcia, Burzin Patel, Stacia Misner, Victor Isakov - Collection Administrator's Compagnion
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
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 ]
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 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
