A

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