Flylib.com
List of Exercises
Previous page
Table of content
Next page
Chapter 1: Optimizing the Performance of Databases and Database Servers
Exercise 1.1: Correlating a Trace with Windows Performance Log Data
Chapter 2: Optimizing the Performance of Queries
Exercise 2.1: Using the Database Tuning Advisor
Exercise 2.2: Generating Query Plans
Exercise 2.3: Maintaining Indexes
Exercise 2.4: Troubleshooting Deadlocks
Chapter 3: Optimizing and Implementing a Data Recovery Plan for a Database
Exercise 3.1: Reverting to Database Snapshots
Chapter 4: Designing a Strategy to Monitor a Database Solution
Exercise 4.1: Implementing SQL Server Event Alerts
Exercise 4.2: Implementing SQL Server Performance Condition Alerts
Exercise 4.3: Implementing WMI Event Alerts
Exercise 4.4: Implementing INSTEAD OF Triggers
Exercise 4.5: Implementing DDL Triggers
Chapter 5: Designing a Strategy to Maintain a Database Solution
Exercise 5.1: Running Database Consistency Checks
Exercise 5.2: Using the Database Maintenance Plan Wizard
Chapter 6: Designing and Managing SSIS Packages
Exercise 6.1: Creating an SSIS Package
Exercise 6.2: Configuring Checkpoints
Exercise 6.3: Debugging Using a Data Viewer
Exercise 6.4: Creating a Package Configuration
Chapter 7: Designing a Database Data Management Strategy
Exercise 7.1: Using an INNER JOIN to Inspect Common Data in the AdventureWorks Sales.SalesTerritory and Sales.SalesPerson Tables
Exercise 7.2: Using a LEFT OUTER JOIN to Inspect Data in the AdventureWorks Sales.SalesTerritory and Sales.SalesPerson Tables
Exercise 7.3: Using a RIGHT OUTER JOIN to Inspect Data in the AdventureWorks Sales.SalesTerritory and Sales.SalesPerson Tables
Exercise 7.4: Using a FULL OUTER JOIN to Inspect Data in the AdventureWorks Sales.SalesTerritory and Sales.SalesPerson Tables
Exercise 7.5: Using a CROSS JOIN to Inspect Data in the AdventureWorks Sales .SalesTerritory and Sales.SalesPerson Tables
Exercise 7.6: Using UNION and UNION ALL in the AdventureWorks Production .ProductModel Table
Exercise 7.7: Using EXCEPT in the AdventureWorks Production.ProductModelunder70 and Production.ProductModelover50 Tables
Exercise 7.8: Using INTERSECT in the AdventureWorks Production.ProductModelunder70 and Production.ProductModelover50 Tables
Exercise 7.9: Using the DEFAULT Definition in the AdventureWorks Database
Chapter 8: Designing a Strategy to Manage Replication
Exercise 8.1: Creating a Linked Server on a Named Instance
Exercise 8.2: Querying with Linked Servers
Exercise 8.3: Configuring Transactional Replication
Exercise 8.4: Configuring a Push Subscription
Exercise 8.5: Configuring a Predefined Replication Alert
Exercise 8.6: Viewing Latency Using a Tracer Token
Exercise 8.7: Validating Subscriptions in Replication Monitor
Exercise 8.8: Configuring a Transactional Publication with an Updatable Subscription
Chapter 9: Protecting Your SQL Server from Attack
Exercise 9.1: Checking for Tampering
Exercise 9.2: Adding a User to a Database Role
Exercise 9.3: Creating a DDL Trigger
Chapter 10: Designing a Strategy to Manage and Maintain Database Security
Exercise 10.1: Determining Account Lock Status
Exercise 10.2: Running the SQL Server Surface Area Configuration Tool
Exercise 10.3: Auditing Server Administrators
Previous page
Table of content
Next page
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
Beginning Cryptography with Java
The JCA and the JCE
Symmetric Key Cryptography
Certificate Revocation and Path Validation
Key and Certificate Management Using Keystores
Appendix A Solutions to Exercises
OpenSSH: A Survival Guide for Secure Shell Handling (Version 1.0)
Step 5.1 General Troubleshooting
Step 6.1 Port Forwarding
Step 6.3 X11 Forwarding
Conclusion
Appendix - Sample sshd_config File
C++ GUI Programming with Qt 3
Multiple Documents
Implementing Application Functionality
Enabling Drag and Drop
Databases
Installing Qt/Mac
Extending and Embedding PHP
Summary
The Other refcounter
Building and Compiling a Host Application
Constants
Summary
Quantitative Methods in Project Management
Introduction to Probability and Statistics for Projects
Risk-Adjusted Financial Management
Expense Accounting and Earned Value
Special Topics in Quantitative Management
Quantitative Methods in Project Contracts
User Interfaces in C#: Windows Forms and Custom Controls
Design-Time Support for Custom Controls
Dynamic User Interface
GDI+ Basics
GDI+ Controls
Help and Application-Embedded Support
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