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
Lotus Notes and Domino 6 Development (2nd Edition)
Creating Reusable Design Objects
Knowing Where to Use @Functions and @Commands
Fundamental Elements of LotusScript
Accessing the Application
Teamstudio Analyzer
The Complete Cisco VPN Configuration Guide
Overview of VPNs
Concentrator Remote Access Connections with IPsec
ISAKMP/IKE Phase 1 Preparation
Cisco VPN Software Client
IPsec Remote Access and L2L Sessions on the Same Router
Java How to Program (6th Edition) (How to Program (Deitel))
Wrap-Up
Self-Review Exercises
Multitier Applications: Using JDBC from a Servlet
Summary
Wrap-Up
Programming Microsoft ASP.NET 3.5
The Web Forms Model
ASP.NET Core Server Controls
ASP.NET Mobile Controls
ASP.NET Security
Working with Images in ASP.NET
An Introduction to Design Patterns in C++ with Qt 4
Introduction to Qt
Safer Typecasting Using ANSI C++ Typecasts
Member Selection Operators
Namespaces
MP3 Jukebox Assignments
PMP Practice Questions Exam Cram 2
Exam Prep Questions
Answers and Explanations
Project Execution
Exam Prep Questions
Appendix A. CD Contents and Installation Instructions
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