Suggested Practices

Objective 1.4: Design Caching Strategies

• Practice 1 Using the AdventureWorks database, you will design a solution using query notifications. To do this, you will need to perform the following steps:

  • Create a Service Queue using Transact-SQL code in Query Analyzer.

  • Create a Visual Studio application (Windows Forms or Web-based) that will create the notification and wait for changes. The application will need to create a notification using the SqlNotificationRequest object. It will also need to create a thread that waits for changes. When changes are registered, an e-mail should be sent directly to you.

  • Manually alter the data in the target table using Query Analyzer.

  • Ensure that the notification is triggered and the email is sent to your mailbox.

Objective 1.3: Design a Cursor Strategy for a Data Access Component

Objective 2.3: Design a Cursor Strategy

• Practice 1 Locate a production SQL Server in your organization (it can be one with an earlier version of SQL Server). Using Query Analyzer or SQL Server Management Studio, examine the stored procedures and user-defined functions and look for the use of cursors. If you locate any, see whether there is a way to rewrite the cursor using one of the alternatives suggested in this chapter.