Whalen E., Garcia M. - Microsoft SQL Server 2005 Administrator\'s Companion [2006, PDF, ENG]

Автор Сообщение

TorrentFilm ®


Стаж: 3 года 1 месяц

Сообщений: 7763

Награды: Нет


Создавать темы 24-Дек-2015 00:03


Microsoft SQL Server 2005 Administrator's Companion
Год: 2006
Автор: Whalen E.,Garcia M.
Жанр: Учебное пособие
Издательство: Microsoft Press
ISBN: 0735621985, 978-0735621985
Язык: Английский
Формат: PDF
Качество: Изначально компьютерное (eBook)
Количество страниц: 1185
Описание: 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

Примеры страниц


Part I
Introduction to Microsoft SQL Server 2005
1 What’s New in Microsoft SQL Server
2 Microsoft SQL Server 2005 Editions, Capacity Limits, and Licensing
3 Roles and Responsibilities of the Microsoft SQL Server DBA
Part II
System Design and Architecture
4 I/O Subsystem Planning and RAID Configuration
5 32-Bit Versus 64-Bit Platforms and Microsoft SQL Server 2005
6 Capacity Planning
7 Choosing a Storage System for Microsoft SQL Server 2005
8 Installing and Upgrading Microsoft SQL Server 2005
9 Configuring Microsoft SQL Server 2005 on the Network
Part III
Microsoft SQL Server 2005 Administration
10 Creating Databases and Database Snapshots
11 Creating Tables and Views
12 Creating Indexes for Performance
13 Enforcing Data Integrity
14 Backup Fundamentals
15 Restoring Data
16 User and Security Management
Part IV
Microsoft SQL Server 2005 Architecture and Features
17 Transactions and Locking
18 Microsoft SQL Server 2005 Memory Configuration
19 Data Partitioning
Part V
Microsoft SQL Server 2005 Business Intelligence
20 Replication
21 Integration Services
22 Analysis Services
23 Reporting Services
24 Notification Services and Service Broker
Part VI
High Availability
25 Disaster Recovery Solutions
26 Failover Clustering Installation and Configuration
27 Log Shipping and Database Mirroring
Part VII
Performance Tuning and Troubleshooting
28 Troubleshooting, Problem Solving, and Tuning Methodologies
29 Database System Tuning
30 Using Profiler, Management Studio, and Database Engine
Tuning Advisor
31 Dynamic Management Views
32 Microsoft SQL Server 2005 Scalability Options
33 Tuning Queries Using Hints and Plan Guides
Опубликовано группой
[Профиль] [ЛС]
Показать сообщения:    

Текущее время: Сегодня 00:20

Часовой пояс: GMT

Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете голосовать в опросах
Вы не можете прикреплять файлы к сообщениям
Вы не можете скачивать файлы