1347
Index
Symbols
, (comma)
CTEs, 239, 240
locking hints, 1085
; (semi-colon)
IF, 399
statements, 137
termination, 392
*/, comments, 393
/*, comments, 393
$_, PowerShell, 772
& (ampersand)
and, 179–180
string concatenation operator,
178
&& (ampersand/double), SSIS
Expression Language
operator, 1186
(angled brackets), nulls, 186
@ (at sign)
parameters and variables, 1186
stored procedures, 437
\ (backslash), PowerShell
directories, 784
^ (caret), XOR, 180–181
{} (curly brackets), PowerShell
script blocks, 776
$ (dollar sign), parameters, 1184
= (equals sign), nulls, 186
== (equals sign/double), SSIS
Expression Language
operator, 1186
! (exclamation mark), SSIS
Expression Language
operator, 1186
% (percent sign), modulo operator,
178
| (pipe symbol), OR, 180
|| (pipe symbol/double), SSIS
Expression Language
operator, 1186
+ (plus sign), mathematical
operator, 178
# (pound sign)
PowerShell comments, 773
temporary keys, 857? (question mark), SSIS Expression
Language operator, 1186
"" (quotation marks-double), SSIS
Expression Language
operator, 1187
/ (slash), division operator, 178
[] (square brackets), PowerShell
variables, 772
* (star), 128
` (tick mark), string values, 441
~ (tilde), NOT, 181A
abstraction layer
data integrity, 19
database
extensibility, 18
usability, 17
Access, 376–377
ACID. See atomic, consistent,
isolated, and durable
Action, 1244
/ACTION, 59
actions
cubes, 1214–1215
Extended Events, 939
SQL Audit, 971
/ACTION=REBUILDDATABASE, 580
Active Directory (AD), 753
installation, 55, 68
Kerberos, 1271
Report Manager, 1272
wait states, 936
Windows authentication, 836
active transactions, 563
ActiveX, SSIS, 1174
Activity Monitor
deadlocks, 1061
transaction blocks, 1057–1058
AD. See Active Directory
ad hoc queries, 377
ad hoc reports
BISM, 1234
Power View, 1327
add -nosplash, 85
Add Related Tables, 96addnew, 874
Address Windowing Extensions
(AWE), 487
Admin Channel, Extended Events,
941
ADO.NET
database mirroring, 687
PowerShell
module cmdlets, 784
scripts, 790–792
SNAC, 74
SSIS
Connection Managers, 1168
container, 1170
Control Flow, 1172
Data Flow, 1177, 1178
Advanced Encryption Standard
(AES), 857
advanced options
confi guration, 478–480
WHERE, 478
advanced server confi guration,
504–509
SSMS, 505
AES. See Advanced Encryption
Standard
affinity I/O mask, 488–490
affinity mask, 488–490
AFTER
columns, 881
DML, 882
INSERT, 883
INSTEAD OF, 895
RI, 881
ROLLBACK, 896
triggers, 880–883
multiple, 895–896
recursive, 893
Agent Security, 736–737
Aggregate, SSIS Data Flow, 1180
aggregate concatenation. See
multiple assignment
variables
aggregate functions
data, 249–256
expressions, 251
GROUP BY, 283bindex July 23, 2012 2:44 PM V1bindex.indd 1347bindex.indd 1347 7/31/2012 10:39:55 AM7/31/2012 10:39:55 AM
http://www.it-ebooks.info