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
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
Mapping ORM Models to Logical Database Models
Reverse Engineering and Importing to ORM
Editing Logical Models”Intermediate Aspects
Logical Database Model Reports
Change Propagation and Round Trip Engineering
Snort Cookbook
Installing Snort on Windows
Uninstalling Snort from Windows
Logging to a Pager or Cell Phone
Detecting Binary Content
Analyzing Sniffed (Pcap) Traffic
Developing Tablet PC Applications (Charles River Media Programming)
Working with VB .NET
Basics of the .NET Framework
Virtual Joystick
Pong Game
Using Third-Party Engines
Cisco CallManager Fundamentals (2nd Edition)
Circuit-Switched Systems
Dialing Transformations
Architecture and Functionality of the Media Control Layer
Understanding Field Data in CMRs
Identifying CDR Data Generated for Each Call Type
Sap Bw: a Step By Step Guide for Bw 2.0
BW An SAP Data Warehousing Solution
Creating an Application Component
Preparing to Load Data into the ODS Object, Then into an InfoCube
Replicating R/3 DataSources
Appendix A. BW Implementation Methodology
The Oracle Hackers Handbook: Hacking and Defending Oracle
The Oracle Network Architecture
Attacking the Authentication Process
Oracle and PL/SQL
Defeating Virtual Private Databases
Attacking Oracle PL/SQL Web Applications
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