Flylib.com
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146
Authors:
Victor Isakov
,
Marilyn Miller-White
,
J. Steven Jones
,
Andy Warren
BUY ON AMAZON
Table of Contents
Back Cover
MCITP Administrator-Microsoft SQL Server 2005 Optimization and Maintenance (70-444) Study Guide
MCSE: Microsoft SQL Server 2005 Optimization and Maintenance Study Guide
Introduction
Introducing the Microsoft Certified IT Professional
How to Become Certified as a MCITP: Database Administrator
Registering for the Exam
Taking the Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 Exam
Types of Exam Questions
Tips for Taking the Exam
Whats in the Book?
Whats on the Books CD?
How Do You Use This Book?
Hardware and Software Requirements
Assessment Test
Chapter 1: Optimizing the Performance of Databases and Database Servers
Troubleshooting the Performance of a SQL Server Solution
Troubleshooting Physical Server Performance
Troubleshooting Instance Performance
Troubleshooting Database Performance
Summary
Exam Essentials
Review Questions
Chapter 2: Optimizing the Performance of Queries
Troubleshooting and Maintaining Query Performance
Troubleshooting Concurrency Issues
Summary
Exam Essentials
Review Questions
Chapter 3: Optimizing and Implementing a Data Recovery Plan for a Database
Diagnosing Causes of Failure
Planning for Fault Tolerance
Recovering from a Failure of SQL Server 2005
Recovering from a Database Failure
Salvaging Good Data from a Damaged Database by Using Restoration Techniques
Summary
Exam Essentials
Review Questions
Chapter 4: Designing a Strategy to Monitor a Database Solution
Choosing a Performance Monitoring Tool
Choosing the Appropriate Information to Monitor
Defining and Implementing Monitoring Standards for a Physical Server
Summary
Exam Essentials
Review Questions
Chapter 5: Designing a Strategy to Maintain a Database Solution
Creating and Implementing a Maintenance Strategy for Database Servers
Designing a Database Maintenance Plan
Designing a Strategy to Manage Reporting Services
Summary
Exam Essentials
Review Questions
Chapter 6: Designing and Managing SSIS Packages
Understanding How SSIS Is Different from DTS
Installing SSIS
Identifying the SSIS Tools
Using SSMS with SSIS
Understanding Control Flow Items and Maintenance Plan Tasks
Understanding Data Flow Sources, Transformations, and Destinations
Scheduling Package Execution
Securing Packages
Using Checkpoints and Restarting Failed Packages
Moving Packages
Debugging Packages
Using SSIS for Performance Monitoring
Configuring Packages
Summary
Exam Essentials
Review Questions
Chapter 7: Designing a Database Data Management Strategy
Managing Data for Quality
Designing Data Integrity
Summary
Exam Essentials
Review Questions
Chapter 8: Designing a Strategy to Manage Replication
Designing a Strategy to Manage Data Across Linked Servers
Designing a Replication Strategy
Summary
Exam Essentials
Review Questions
Chapter 9: Protecting Your SQL Server from Attack
Analyzing Your Physical Server Security
Preparing for and Responding to Threats and Attacks
Optimizing a Database Control Strategy to Meet Business Requirements
Summary
Exam Essentials
Review Questions
Chapter 10: Designing a Strategy to Manage and Maintain Database Security
Maintaining a Server-Level Security Strategy
Maintaining a User-Level Security Strategy
Summary
Exam Essentials
Review Questions
Glossary
B
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
Index
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
List of Figures
List of Tables
List of Exercises
List of Sidebars
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146
Authors:
Victor Isakov
,
Marilyn Miller-White
,
J. Steven Jones
,
Andy Warren
BUY ON AMAZON
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Introducing Cisco IPC Express
Summary
Configuring the AVT
Managing Cisco IPC Express with Cisco Partner Applications
Cisco IPC Express Features and Releases
C & Data Structures (Charles River Media Computer Engineering)
The scanf Function
Memory Allocation
Structures
Trees
Problems in Graphs
Microsoft WSH and VBScript Programming for the Absolute Beginner
Getting Started with the WSH and VBScript
Overview of the Windows Script Host
VBScript Basics
Processing Collections of Data
Using the Windows Registry to Configure Script Settings
FileMaker 8 Functions and Scripts Desk Reference
Calculation Signatures
Design Functions
Get(RequestCount)
GetAsText()
Lg()
Python Programming for the Absolute Beginner, 3rd Edition
The Compulsory Features List
Whats Python Not Good For?
File Tools
Permuting Sequences
Section B.2. Book Examples Distribution
Digital Character Animation 3 (No. 3)
Creating Characters
Facial Rigging
Understanding Motion
Secondary Action
Animating Dialogue
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies