ACID (Atomicity, Consistency, Isolation, and Durability) properties, 443
Action class, AMO OLAP, 155
Active Server Pages (ASP), 10
Administer permission, AMO, 156
Administrative classes, AMO, 156
ADO (ActiveX Data Objects)
data access object model, 32
data access with, 10–11
ADOMD, 157–158
AdomdDataReader object, 158
ADO.NET
as connected object model, 35–36
as disconnected object model, 32–34
asynchronous processing, 184
connecting with, 6–7
data providers, 438
exercise connecting with, 14–15
exercise retrieving data with DataReaders, 40
exercise retrieving data with DataSets, 36
recommended uses as data provider, 5
selecting as data provider, 4
SqlParameter objects, 211
AdventureWorks database
installing, xxii
software requirements for Exam 70–442, xx
AFTER triggers
cascading actions and, 199
data validation and, 210
aggregate functions
built-in functions, 61
T-SQL, 435
aggregating data
built-in functions, 61
exercise de-normalizing aggregated data, 335–338
PIVOT operator, 55
UNPIVOT operator, 55
user-defined functions, 61
algorithms, for data mining, 156
alias data types, 335
ALLOW_SNAPSHOT_ISOLATION, 244
ALTER TABLE statement, 347
AMO (Analysis Management Objects), 154–157
administrative classes, 156
assemblies and namespaces, 154
compared with XMLA, 154
data mining classes, 155
fundamental objects, 154
OLAP classes, 155
overview of, 154
security classes, 156
APIs (application programming interface) ADO.NET as, 4
application domains, 430
application performance, SQLOS and, 416–425
application-side distributed transactions, in .NET Framework, 268
APPLY statements
combining subqueries with, 293
exercise using, 67
SELECT statements and, 55–57
ASP (Active Server Pages), 10
ASP.NET
asynchronous processing, 184
caching methods, 97, 99
assemblies
AMO (Analysis Management Objects), 154
CLR Host assembly permissions, 428
.NET Framework, 425
RMO (Replication Management Objects), 150
SMO (Server Management Objects), 145
asymmetric keys, 472
asynchronous processing, 184–189
Command object for accessing methods, 185
enabling with ADO.NET, 184
exercise applying callback feature, 186–189
overview of, 184
Atomicity, Consistency, Isolation, and Durability (ACID) properties, 444
Attributes, OutputCache directive, 100
authentication
CLR Host and, 427
creating endpoints and, 20
user IDs and passwords and, 9
authorization, CLR Host and, 427
Auto Stats trace event, 461