Внимание!!! AdBlock блокирует показ некоторых скриншотов. Пожалуйста, все вопросы к разработчкикам
Автор
Сообщение
Galfimbul
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
Опубликовано группой
Внимание! AdBlock блокирует показ скриншотов, все вопросы к разработчикам )))