Specifications

211
Parallel Data Warehouse
Admin Console, 122
architecture of, 109-115
automatic growth feature, toggling, 118
conguring, 110
control node, 112-113
creating tables, 118-120
data load processing, 121-122
data types supported in, 120
DDL extensions, 117
distributed strategy, 116-117
networking technologies, 112
overview of, 9, 109
query processing, 121
replicated strategy, 116
shared nothing (SN) architecture, 115-120
Parallel Data Warehouse edition, 12
pasting data into PowerPivot, 193
PivotCharts, creating, 196
PivotTables. See also tables
converting to formulas, 197
creating, 196
measures, 199-200
point model, 147
policies
changing, 36
defaults, restoring, 36
managing, 34
violation reporting settings, 35
PowerPivot database, 203
PowerPivot for Excel
Analysis Services engine, 190
Atom data feed, importing, 191
columns, formatting, 195
copying and pasting data into, 193
creating databases, 118
cube functions, 197
data sources, creating, 191-193
data types, changing, 195
ltering data, 194
hiding columns, 196
installing, 190
modications made by, 190
overview of, 189
relationships in, 194
slicers, 198
Time Intelligence functions, 193
VertiPaq storage mode, 202
workbook, creating, 190
migrating SQL Server installations, 18-19
migrating virtual machines. See Live Migration
models (MDS)
dened, 129
deploying, 142
security settings, 139-140
monitoring, with SQL Server Utility, 89
monitoring DACs, 100-105
monitoring settings, 34
MPP architecture, 110
msdb database
creation of, 52
disk space consumption, 25
MultiLookup function, 167
multi-rack system
Backup node, 114
compute node, 114-115
control node, 112-113
control rack, 112
data racks, 111
Landing Zone node, 114
management node, 114
overview of, 110
N
naming UCPs, 27
nesting aggregate functions, 168
.NET Framework requirement, 15
New Virtual Machine Wizard, 76-77
Nexus query tool, 122
non-transactional reference data, 125-126
O
objects, SQL Server, 45
operating system requirements, 15
output adapters, 151
overutilized instances, 91
overutilized threshold default, 34
P
page headers and footers, 170
page numbering in reports, 170
PageName property (reports), 173
pagination, report, 172-173
PowerPivot for Excel