Download Microsoft SQL Server 2008 R2

I
importing master data, 135
indicators in reports, 176-177
InfiniBand network, 110, 112
in-place upgrades, 16-17
input adapters, base classes, 151
installing MDS (Master Data Services), 127
instances. See also managed instances; SQL Server
instances
enrolling, 29-32
utilization, monitoring, 91
validating, 31
viewing, 91
Integration Services, 123
InteractiveSize property (reports), 172
Internet Explorer requirement, 15
interval event model, 147
J
join operations, 161
L
Landing Zone node, 114
linked documents, 205
linked tables, 193
LINQ expressions, 155
Live Migration. See also Hyper-V
benefits of, 87-88
configuring virtual machines for, 79-82
implementing, 75
initiating, 83
overview of, 64, 72
load activity, monitoring, 122
look-and-feel properties, 169-170
Lookup function, 166
LookupSet function, 168
M
managed instances. See also instances; SQL Server
instances
global policies for, 34
health status of, 91
maximum number of, 29
210
importing master data
overutilized resources, 92
processor utilization, 96
underutilized resources, 92
viewing, 91
Managed Instances viewpoint (Utility Explorer), 95-100
management node, 114
management utilities. See Best Practices Analyzer (BPA);
SQL Server Utility
ManagementService API, 163
maps, 177-178
massively parallel processing (MPP), 9
master data, 125-126
Master Data Manager
areas in, 128-129
batch creation, 135-136
data maintenance with, 131
data stewards, 127
model deployment, 142
subscription view, creating, 136
Master Data Services Configuration Manager, 128
MDS (Master Data Services)
API, 127, 142-143
authentication, 127
authorization, 138
business rules, 132-133
class library, 142-143
configuring, 128
data stewards, 127
database, 128
as development platform, 142
exporting master data, 136-137
flexibility of, 126
importing master data, 135
installing, 127
locking data in, 139-140
master data hub, 126
overview of, 125
permissions, 138
tables in, 135
transaction logs, 131-134
Transact-SQL functions, 143-144
versioning, 127-128, 137-138
Web services API, 143
measures (PivotTables), 199-200
members (MDS), 129-130
memory, upgrading online, 63
memory requirements, 14
Microsoft Assessment and Planning Toolkit, 75
Microsoft Press support Web site, xix
Microsoft SQL Azure, 9