Microsoft SQL Server 2008 R2 Specifications download pdf (Page 8)

viii Contents

Creating a UCP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

Creating a UCP by Using SSMS 26

Creating a UCP by Using Windows PowerShell 28

UCP Post-Installation Steps 29

Enrolling SQL Server Instances . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .29

Managed Instance Enrollment Prerequisites 30

Enrolling SQL Server Instances by Using SSMS 30

Enrolling SQL Server Instances by Using Windows PowerShell 32

The Managed Instances Dashboard 32

Managing Utility Administration Settings . . . . . . . . . . . . . . . . . . . . . . . . . . .33

Connecting to a UCP 33

The Policy Tab 34

The Security Tab 37

The Data Warehouse Tab 39

CHAPTER 3 Data-Tier Applications 41

Introduction to Data-Tier Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41

The Data-Tier Application Life Cycle 42

Common Uses for Data-Tier Applications 43

Supported SQL Server Objects 44

Visual Studio 2010 and Data-Tier Application Projects . . . . . . . . . . . . . . . . 45

Launching a Data-Tier Application

Project Template in Visual Studio 2010 45

Importing an Existing Data-Tier

Application Project into Visual Studio 2010 47

Extracting a Data-Tier Application with

SQL Server Management Studio . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49

Installing a New DAC Instance with the

Deploy Data-Tier Application Wizard . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52

Registering a Data-Tier Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55

Deleting a Data-Tier Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56

Upgrading a Data-Tier Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59

1 2 3 4 5 6 7 8 9 10 11 12 13 ... 235 236

No comments

Microsoft SQL Server 2008 R2 Specifications Page 8