Suggested Practices

Objective 1.5: Design Client Libraries to Write Applications that Administer a SQL Server Service

• Practice 1: Expand on Exercise 2, "Create a Data-Mining Structure" from Lesson 1, "Administering a SQL Server Service", and add a mining model to the mining structure. This involves assigning an algorithm to the mining structure and then processing the mining structure.

  To begin with, run the Data Mining Wizard. When specifying the tables, Person.Contact should be the case table and Person.Contact a nested table. Use the Suggest button on the Specify Column Usage page of the wizard to indicate which columns are likely to provide information. Use the Detect button on the to automatically assign the correct content types. When assigning algorithms, use the following:

  • Microsoft Clustering

  • Microsoft Decision Trees

  • Microsoft Neural Network

Objective 1.6: Design Queries that Use Multiple Active Results Sets (MARS)

• Practice 1: Refer to Lesson 2, "Querying with Multiple Active Result Sets," Exercise 1, "Compare Execution of Queries With and Without MARS." Expand on the exercise by enabling transactions for the code that uses a MARS connection. Intentionally throw an error and ensure that the transaction is rolled back and no updates are made to the database.