Microsoft SQL Server 2008 R2 User Manuals

Microsoft

Product codes

810-08234Show more

, 810-08230, 810-08229

User Manual (English)User Manual (English)

User Manual (810-08234)

Table of Contents

Cover
1
- Copyright Page
  2
Dedication
3
Contents at a Glance
5
Contents
7
Acknowledgments
15
Introduction
17
Part I: Database Administration
21
Part II: Business Intelligence Development
127
- Chapter 6: Scalable Data Warehousing
  129
  - Parallel Data Warehouse Architecture
    129
    - Data Warehouse Appliances
      129
    - Processing Architecture
      130
    - The Multi-Rack System
      130
    - Hub-and-Spoke Architecture
      135
  - Data Management
    135
    - Shared Nothing Architecture
      135
    - Data Types
      140
    - Query Processing
      141
    - Data Load Processing
      141
  - Monitoring and Management
    142
  - Business Intelligence Integration
    143
    - Integration Services
      143
    - Reporting Services
      143
    - Analysis Services and PowerPivot
      143
- Chapter 7: Master Data Services
  145
  - Master Data Management
    145
    - Master Data Challenges
      145
    - Key Features of Master Data Services
      146
  - Master Data Services Components
    147
  - Data Stewardship
    149
    - Model Objects
      149
    - Master Data Maintenance
      151
    - Business Rules
      152
    - Transaction Logging
      154
  - Integration
    155
    - Importing Master Data
      155
    - Exporting Master Data
      156
  - Administration
    157
    - Versions
      157
    - Security
      158
    - Model Deployment
      162
  - Programmability
    162
    - The Class Library
      162
    - Master Data Services Web Service
      163
    - Matching Functions
      163
- Chapter 8: Complex Event Processing with StreamInsight
  165
  - Complex Event Processing
    165
    - Complex Event Processing Applications
      165
    - StreamInsight Highlights
      166
  - StreamInsight Architecture
    166
    - Data Structures
      167
    - The CEP Server
      167
    - Deployment Models
      169
  - Application Development
    170
    - Event Types
      170
    - Adapters
      171
    - Query Templates
      174
    - Queries
      175
    - Query Template Binding
      182
    - The Query Object
      183
  - The Management Interface
    183
    - Diagnostic Views
      183
    - Windows PowerShell Diagnostics
      184
- Chapter 9: Reporting Services Enhancements
  185
  - New Data Sources
    185
  - Expression Language Improvements
    185
    - Combining Data from More Than One Dataset
      186
    - Aggregation
      188
    - Conditional Rendering Expressions
      189
    - Page Numbering
      190
    - Read/Write Report Variable
      190
  - Layout Control
    191
    - Pagination Properties
      192
    - Data Synchronization
      193
    - Text Box Orientation
      194
  - Data Visualization
    195
    - Data Bars
      195
    - Sparklines
      196
    - Indicators
      196
    - Maps
      197
  - Reusability
    198
    - Shared Datasets
      199
    - Cache Refresh
      199
    - Report Parts
      200
    - Atom Data Feed
      202
  - Report Builder 3.0
    203
    - Edit Sessions
      203
    - The Report Part Gallery
      203
  - Report Access and Management
    204
    - Report Manager Improvements
      204
    - Report Viewer Improvements
      206
    - Improved Browser Support
      206
    - RDL Sandboxing
      206
  - SharePoint Integration
    207
- Chapter 10: Self-Service Analysis with PowerPivot
  209
  - PowerPivot for Excel
    210
    - The PowerPivot Add-in for Excel
      210
    - Data Sources
      211
    - Data Preparation
      213
    - PowerPivot Reports
      216
    - Data Analysis Expressions
      219
  - PowerPivot for SharePoint
    221
    - Architecture
      221
    - Content Management
      224
    - Data Refresh
      225
    - Linked Documents
      225
    - The PowerPivot Web Service
      225
  - The PowerPivot Management Dashboard
    226
Index
227
About the Authors
235
What Do You Think of This Book?
236

User Manual (810-08234)

Size:

7.75 MB
Pages:

236
Language:

English

User Manual (810-08230)

Table of Contents

User Manual (810-08230)

Size:

7.75 MB
Pages:

236
Language:

English