List of Exercises

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