Flylib.com
List of Sidebars
Previous page
Table of content
Chapter 1: Optimizing the Performance of Databases and Database Servers
Real World Scenario-The Benefits of a Performance Troubleshooting Methodology
Chapter 2: Optimizing the Performance of Queries
Database Tuning Advisor
Statement-Level Compilation
Real World Scenario-Covering Indexes
An Iterative Process
PSS Head Blocker Script
Real World Scenario-Caveat Emptor: Overriding the Optimizer
Chapter 3: Optimizing and Implementing a Data Recovery Plan for a Database
Don’t Forget the SQL Server Agent!
Tail-Log Backups
Chapter 4: Designing a Strategy to Monitor a Database Solution
The Performance Overhead of Monitoring Tools
Real World Scenario-A Holistic Approach to Monitoring Performance
The SQL Server Agent
Defining Operators Using the SQL Server Agent
Windows Management Instrumentation (WMI)
Service Broker
Chapter 5: Designing a Strategy to Maintain a Database Solution
Real World Scenario-Running DBCC Checks in a VLDB Environment
Capacity Planning the reportserver and reportservertempdb System Databases
Chapter 6: Designing and Managing SSIS Packages
Versioning Has Changed
Additional Reading
Real You Need Scenario-Do You Need Checkpoints?
Why Would You Move Packages?
More on Performance Tuning
Chapter 7: Designing a Database Data Management Strategy
Real World Scenario-Clinical Trial Data
Real World Scenario-Reconciling Conflicting Data
Real World Scenario-Creating Clinical Trial Deliverables
Chapter 8: Designing a Strategy to Manage Replication
Linked Server Information
Ad Hoc Distributed Query Solutions: Past and Present
Chapter 9: Protecting Your SQL Server from Attack
Real World Scenario-Build versus Buy
Real World Scenario-Real-Life Virus Response: Slammer
Chapter 10: Designing a Strategy to Manage and Maintain Database Security
Real World Scenario-Tightly Coupled Problems
Real World Scenario-A Structured Release
Previous page
Table of content
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
Developing Project Management Skills
Assessing Risk
Budgeting 101
Appendix A Answers to Review Questions
Certified Ethical Hacker Exam Prep
Automated Assessment Tools
Session Hijacking
Key Terms
Apply Your Knowledge
Limited Warranty and Disclaimer
Adobe After Effects 7.0 Studio Techniques
Settings: Project, Footage, Composition
Keyframes and The Graph Editor
The Many Ways to Create Selections
The Role of Grain
Light Source and Direction
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Using Regular Expressions to Split a String
Defining Constrained Value Types
Randomly Shuffling Data
Science and Mathematics
Notifying One Thread from Another
Mastering Delphi 7
The Delphi Programming Language
Client/Server with dbExpress
Reporting with Rave
Web Services and SOAP
Appendix A Extra Delphi Tools by the Author
802.11 Wireless Networks: The Definitive Guide, Second Edition
11 MAC Fundamentals
1X: Network Port Authentication
Robust Security Network (RSN) Operations
11a and 802.11j: 5-GHz OFDM PHY
11 on the Macintosh
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