1376
Index
SQL Profi ler (cont inued)
selecting, 921–923
Events Selection, 921
execution plans, 996, 999–1000
Extended Events, 942
fi lters, 919
GROUP BY, 924
New Trace, 920
package logging, 1188
PerfMon, 919, 925–926
Query Editor, 920
query recompiles, 1045
Reporting Services, 924
Service Broker, 657
SQL Agent, 924
SQL Trace, 919–929
SSAS, 1230–1232
SSMS, 920
System Monitor, 913, 921
traces, 10
defi ning new, 920–921
transaction blocks, 1058–1059
WHERE...LIKE, 921
wildcards, 923
SQL Server: Wait Statistics,
912
SQL Server Agent, Object Explorer,
92
SQL Server Analysis Services
(SSAS), 7, 8, 1195–1222
aggregations, 1197
architecture, 1196–1198
client, 1225–1226
confi guration, 1223–1232
cubes, 1204, 1210–1218
actions, 1214–1215
aggregations, 1216–1217
calculations, 1213
data source view, 1211
data storage, 1219
dimensions, 1212–1213
ErrorConfiguration,
1222
KPI, 1214
measures, 1212
NullProcessing, 1221
partitions, 1215–1216
perspectives, 1217–1218
processing, 1219–1220
SSRS, 1271
UnknownMember, 1221
data, 1226–1228
data mining, 1281–1297
algorithms, 1289–1296
association rules, 1294–1295Business Intelligence
Development Studio,
1283
cache, 1286
Classifi cation Matrix, 1287
clustering, 1291–1292
cross validation, 1288
cubes, 1296–1297
decision trees, 1290–1291
lift charts, 1286–1287
linear regression algorithm,
1291
model evaluation, 1286–1289
Naïve Bayes algorithm, 1294
neural networks, 1293
process of, 1282–1283
scatter plots, 1286–1287
sequence clustering, 1292–
1293
SOAP, 1288
time series, 1296
troubleshooting, 1288
XMLA, 1288
data source view, 1211, 1228–
1231
data warehouses, 1196
database, 1226–1232
dimensions, 1204–1210, 1212–
1213
Extended Events, 1232
impersonation, 1228
installation, 32, 1223–1227
Installation Center, 42
instances, BISM, 1324–1325
MDX, 8
memory, 1228
MOLAP, 1197
Multidimensional and Data
Mining mode, 1223–1227
OLAP, 1228
OLE DB, 1226
passwords, 1227
PowerPivot for SharePoint mode,
1223
PowerShell, 783
Registered Servers, 86
relational database design, 1227
server, 1225
Solution Explorer, 1195
SQL Profi ler, 1230–1232
SSIS
Connection Managers, 1168
Control Flow, 1171
SSMS, 1227
Tabular mode, 1223UDM, 1197
warnings, 1208
SQL Server Data Tools (SSDT), 1226
BISM, 1301–1302
creating models, 1319–1322
extending models,
1322–1324
Import and Export Wizard, 628
Installation Center, 42
Report Designer, 1234, 1262
scripts, 620
SSIS, 1158, 1166–1167
SSRS reports, 1265–1266
SQL Server Database Services
default instances, 58
Installation Center, 42
SQL Server Integration Services
(SSIS), 7, 17. See also SSIS
Designer
ActiveX, 1174
Connection Managers, 1161–1169
ADO.NET, 1168
Data Quality Services (DQS),
1168
fi les, 1168–1169
Flat File, 1162–1163
FTP, 1169
HTTP, 1169
MSMQ, 1169
OLE DB, 1164, 1168
security, 1168
SMOs, 1169
SMTP, 1169
SQL Server Mobile, 1168
SSAS, 1168
WMI, 1169
constraints, 1174
containers, 1170
Copy Database Wizard, 616
Data Flow
destinations, 1178–1179
sources, 1177–1178
transformations, 1179–1182
Data Flow Task, 1156
data replication, 728
data source view, 1158
deprecation, 1158
DTS, 1156, 1174
ETL, 816, 1147–1149, 1155–1194
Execute Package, 1160
expressions, 1161, 1174
Expression Builder, 1161
Expression Language, 1161,
1186–1187
Installation Center, 42bindex July 23, 2012 2:44 PM V1
bindex.indd 1376bindex.indd 1376 7/31/2012 10:39:59 AM7/31/2012 10:39:59 AM
http://www.it-ebooks.info