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
Certified Ethical Hacker Exam Prep
Apply Your Knowledge
Automated Assessment Tools
Apply Your Knowledge
Social Engineering
Certified Ethical Hacker
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Introduction to Kanban
Developing a Kanban Design
Initial Startup and Common Pitfalls
Appendix C Two-Bin Kanban Systems
Appendix J Abbreviations and Acronyms
The CISSP and CAP Prep Guide: Platinum Edition
Access Control
Cryptography
Initiation of the System Authorization Process
The Accreditation Phase
Appendix G Control Baselines
WebLogic: The Definitive Guide
EJB Transactions
Deployment Tools
Node Manager
Creating a Custom Authentication Provider
Reliable SOAP Messaging
C & Data Structures (Charles River Media Computer Engineering)
Data Types
Function
Structures
Union
Arrays, Searching, and Sorting
Introduction to 80x86 Assembly Language and Computer Architecture
Bit Manipulation
Floating-Point Arithmetic
Input/Output
Appendix A Hexadecimal/ASCII conversion
Appendix D 80x86 Instructions (by Mnemonic)
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