Microsoft® SQL ServerTM 2005 Administrator's Companion
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 p...
| Autor principal: | |
|---|---|
| Otros Autores: | , , , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626971906719 |
Tabla de Contenidos:
- Microsoft® SQL ServerTM 2005 Administrator's Companion; Introduction; What's in This Book; About the CD; Computer System Requirements; Support; Talk to Us; I. Introduction to Microsoft SQL Server 2005; NUMA Support; Data Availability; Online Index Operations; Database Snapshot; Fast Recovery; Mirrored Backups; Database Mirroring; Read Committed Snapshot and Snapshot Isolation; Performance; Plan Guides; Forced Parameterization; Dynamic Management Views; Enhancements to Existing Features; Failover Clustering; Replication; Indexes; Full-Text Search; Tools and Utilities; Query Editor
- SQL Configuration ManagerSurface Area Configuration; SQL Server Profiler; Database Engine Tuning Advisor; SQL Server Upgrade Advisor; sqlcmd Utility; tablediff Utility; Business Intelligence Features; Integration Services; Analysis Services; Reporting Services; Notification and Broker Services; Summary; 2. Microsoft SQL Server 2005 Editions, Capacity Limits, and Licensing; Express Edition; Workgroup Edition; Standard Edition; Enterprise Edition; Developer Edition; Understanding Windows Platform Support; Understanding Processors and Memory Limits; Factoring in Head-Room
- Comparing SQL Server 2005 EditionsAnalysis Services; Reporting Services; Notification Services; Integration Services; Replication; SQL Server 2005 Capacity Limits; Understanding SQL Server 2005 Licensing; Device Client Access Licensing; Processor Licensing; Licensing Considerations for High-Availability Environments; SQL Server 2005 Pricing; Summary; 3. Roles and Responsibilities of the Microsoft SQL Server DBA; Development DBA; Architect DBA; ETL DBA; OLAP DBA; Basic Duties of a DBA; Hardware and Software Configuration; Service Packs and Security Updates; Security; Server Security
- Security AuditingOperations; Change Management; Service Levels; System Monitoring; Performance Tuning; Routine Maintenance; Reliability; Disaster Recovery; Log Shipping; Database Mirroring; Replication; Planning and Scheduling Downtime; Capacity Planning; Documentation; Design Documents; Operational Information; Development and Design; Data Modeling; Procedure and SSIS Development; Scalability; Replication; Named Instances; DBA Tips, Guidelines, and Advice; Help Desk; Purchasing Input; Know Your Versions; Don't Panic; Summary; II. System Design and Architecture
- Disk Drive Performance CharacteristicsDisk Seeks; Track-to-Track Seeks; Average Seek Time; Transfer Time; Disk Drive Specifications; Disk Drive Performance; Random I/O; Solutions to the Disk Performance Limitation Problem; Redundant Array of Independent Disks (RAID); Redundancy; RAID Levels; RAID-1 and RAID-10; RAID-1 and RAID-10 Recommendations; RAID-5; RAID-5 Recommendations; RAID Performance; Write Performance; Disk Calculations; RAID-1; RAID-10; RAID-5; RAID Comparison; Which RAID Level Is Right for You?; SQL Server I/O Overview; SQL Server Writes; Transaction Log; Backup and Recovery
- Planning the SQL Server Disk Layout
