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
benets 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 classication, 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)
benets of, 65
best practices compliance, testing, 11, 71
connecting by multiple networks, 65
enhancements in Windows Server 2008, 63
Hyper-V Integration Services tool