Microsoft SQL Server 2008 R2 manuals

Microsoft SQL Server 2008 R2 Specifications (236 pages)

Brand: Microsoft | Category: Application server software | Size: 7.75 MB |

English

Table of contents

Database Administration 1

1

—Ross MistRy

3

—stacia MisneR

3

Contents at a Glance

5

Contents

7

viii Contents

8

Contents ix

9

x Contents

10

Contents xi

11

xii Contents

12

Contents xiii

13

Acknowledgments

15

xvi

16

Introduction

17

Pre-Release Software

18

Support for This Book

19

We Want to Hear from You

19

Database

21

Administration

21

SQL Server 2008 R2 Editions

23

Upload collection

27

Premium Editions

32

Core Editions

32

Specialized Editions

33

Hardware Requirements

34

Software Requirements

35

The In-Place Upgrade

36

Side-by-Side Migration

38

Multi-Server Administration

41

REAL WORLD

43

UCP Prerequisites

45

Creating a UCP by Using SSMS

46

UCP Post-Installation Steps

49

Windows PowerShell

52

Connecting to a UCP

53

The Policy Tab

54

The Security Tab

57

The Data Warehouse Tab

59

1 year, or 2 years

60

Data-Tier Applications

61

Supported SQL Server Objects

64

Visual Studio 2010

65

Management Studio

69

Data-Tier Application Wizard

72

High Availability and

83

Virtualization Enhancements

83

Windows Server 2008 R2

86

Server 2008 R2

86

Guest Failover Clustering

87

Real World

88

/cc732035(WS.10).aspx

89

Enabling CSV

96

Click Next

101

Consolidation and Monitoring

105

SQLInstance01

106

Monitoring

109

Development

127

Business Intelligence

127

Scalable Data Warehousing

129

Processing Architecture

130

The Multi-Rack System

130

The Data Rack

131

The Control Rack

132

The Control Node

132

The Landing Zone Node

134

The Backup Node

134

The Management Node

134

The Compute Node

134

Hub-and-Spoke Architecture

135

Shared Nothing Architecture

135

Replicated Strategy

136

Distributed Strategy

136

DDL Extensions

137

CREATE DATABASE

138

CREATE TABLE

138

Data Types

140

Query Processing

141

Data Load Processing

141

Monitoring and Management

142

Integration Services

143

Reporting Services

143

Master Data Services

145

Master Data Manager

148

Model Objects

149

Product hierarchies

150

Master Data Maintenance

151

Business Rules

152

Business rule validation

153

Transaction Logging

154

Importing Master Data

155

Exporting Master Data

156

Versions

157

Security

158

A user’s model permissions

159

Programmability

162

Matching Functions

163

Complex Event Processing

165

StreamInsight Highlights

166

Data Structures

167

The CEP Server

167

Input Adapters

168

Output Adapters

169

Query Instances

169

Deployment Models

169

Hosted Assembly

169

Standalone Server

169

Event Types

170

Adapters

171

Query Templates

174

The Event Stream Object

174

The QueryTemplate Object

174

Projection

175

Filtering

175

Event Windows

176

FIGURE 8-3 Hopping windows

177

Aggregations

179

Grouping

180

User-dened Functions

181

Query Template Binding

182

The Query Binder Object

182

The Query Object

183

Diagnostic Views

183

Enhancements

185

Aggregation

188

Aggregation of an aggregation

189

Page Numbering

190

Read/Write Report Variable

190

Layout Control

191

Pagination Properties

192

Data Synchronization

193

Text Box Orientation

194

Data Bars

195

Sparklines

196

Indicators

196

Indicator types

197

Reusability

198

Shared Datasets

199

Cache Refresh

199

Report Parts

200

Reusability CHAPTER 9 181

201

Atom Data Feed

202

Edit Sessions

203

The Report Part Gallery

203

Report Manager Improvements

204

Report Viewer

205

The report menu

205

Report Viewer Improvements

206

Improved Browser Support

206

RDL Sandboxing

206

RS Utility Scripting

207

Self-Service Analysis with

209

PowerPivot

209

Modications to Excel

210

Data Sources

211

Linked Tables

213

Copying and Pasting

213

Data Preparation

213

Relationships

214

PowerPivot Reports

216

PivotTables

216

PowerPivot data

216

Cube Functions

217

The CUBEVALUE function

218

Data Analysis Expressions

219

Calculated Columns

219

Measures

219

DAX Functions

220

Architecture

221

The PowerPivot System Service

222

The PowerPivot Database

223

The PowerPivot Web Service

223

Content Management

224

The PowerPivot Gallery

224

The Data Feed Library

225

Data Refresh

225

Linked Documents

225

About the Authors

235

What do

236

Microsoft devices