Specifications

209
guest model, 67-68
history of, 64-65
traditional model, 65
troubleshooting, 70
validating prerequisites for, 68-70
feedback on book, xix
le space utilization monitoring, 96
ltering operation, 155
ltering PowerPivot data, 192, 194
formatting reports dynamically, 169-170, 172-173
free edition. See Express edition
functions
aggregate, 168
cube, 197
Lookup, 166
LookupSet, 168
MultiLookup, 167
Split, 167
Time Intelligence, 193
Transact-SQL, 143-144
G
Generate And Publish Scripts Wizard, 9
global monitoring settings, 34
guest failover clustering, 67-68
H
hardware, upgrading online, 63
hardware requirements, 14-15
headers and footers, 170
hierarchies (MDS), 130
high availability enhancements, 63-64
hopping windows stream, 157
hot adding hardware, 63
hub-and-spoke architecture, 115
Hyper-V. See also Live Migration; virtualization
benets of, 74
on guest failover clustering, 67-68
improvements in, 11
overview of, 64
system requirements for, 73-74
uses for, 74
virtual machines, creating with, 76-79
Hyper-V Integration Services tool, 79
disk space requirements, 15
DMS (Data Movement Service), 112
document libraries, 204-205
DomainScope property (reports), 173
DWLoader, 122
Dwsql, 122
dynamic report formatting, 169-170, 172-173
dynamic virtual machine storage, 64
E
edge event model, 147
edit sessions, 183
enrolling instances, 29-32
enterprise data warehousing. See Parallel Data
Warehouse
Enterprise edition, 12, 29
entities (MDS), 129-130
event classication, 154
event stream objects, 154
aggregation operations, 159-160
consumer objects, 162
event types, 150-151
event windows, 156-159
Excel add-ins. See PowerPivot for Excel
Excel tables, linking to PowerPivot tables, 193
Excel workbooks, 173, 193
exporting master data, 136-137
exporting tables, 120
Express edition, 13
expression language, 165-171. See also Data Analysis
Expressions (DAX)
expressions, 183
Extended Protection for Authentication, 10
Extract Data-Tier Application Wizard, 45, 49-51
extracting DACs (data-tier applications), 49-51
F
Failover Cluster Manager, 80
failover clustering. See also CSV (Cluster Shared Volumes)
benets of, 65
best practices compliance, testing, 11, 71
connecting by multiple networks, 65
enhancements in Windows Server 2008, 63
Hyper-V Integration Services tool