Microsoft® SQL ServerTM 2005 Administrator's Companion.

Format:

Book

Author/Creator:

Whalen, Edward.

Contributor:

Patel, Burzin.

Garcia, Marcilina.

Misner, Stacia.

Isakov, Victor.

Language:

English

Subjects (All):

Microsoft SQL server 2005.

Client/server computing.

Computer programming.

Local Subjects:

Client/server computing.

Computer programming.

Microsoft SQL server 2005.

Physical Description:

1 online resource (0 p.)

Edition:

1st edition

Other Title:

SQL Server 2005 administrator's companion

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

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 networkPlan and configure the I/O subsystem and model system capacity Create and maint

Contents:

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

Notes:

Description based upon print version of record.

ISBN:

9780735636644

0735636648

OCLC:

609857217