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
Project Management JumpStart
Building the Foundation
Breaking Down the Project Activities
Planning and Acquiring Resources
Budgeting 101
Controlling the Project Outcome
Introducing Microsoft Office InfoPath 2003 (Bpg-Other)
Adding Basic Controls and Lists
Working with Advanced Form Elements
Publishing Form Templates
Navigating the InfoPath Object Model
Writing Advanced Event Handlers
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Summary
Threats Targeting the IP Telephony System
PKI Topologies in Cisco IP Telephony
Real-Time Monitoring Tool Overview
Using Additional Management and Monitoring Tools
A Practitioners Guide to Software Test Design
Use Case Testing
Data Flow Testing
Exploratory Testing
Test Planning
Appendix B Stateless University Registration System Case Study
Programming Microsoft ASP.NET 3.5
Creating Bindable Grids of Data
ASP.NET State Management
Creating New ASP.NET Controls
Working with Images in ASP.NET
Index
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Cause and Effect
Exaggeration Equals Characterization
Blue-Screen Garbage Mattes
Rotoscoping Techniques with Photoshop
Color, Light, and Focus
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