SQL Server 2017 Administration Inside Out, First Edition

Index

A

ABORT_AFTER_WAITparameter 566

access control

role-based 223

single sign-on (SSO) 222

actions 585

Active Directory Organizational Unit (OU) 507

Activity Monitor

Active Expensive Queries section 36

Data File I/O section 36

overview of 33

Processes section 34

Recent Expensive Queries section 36

Resource Waits section 35

actual execution plans 408

ad hoc queries 105

Advanced Encryption Standard (AES) 306, 478

affinity masks 105

alerts

performance conditions 620

recommendations for 618

SQL Server events 619

WMI event alert conditions 621

alphanumeric data types 334

ALTER ANY EVENT SESSION permission 262

ALTER ANY USER permission 257

ALTER AUTHORIZATION 266

ALTER TABLE statements 352

ALTER TRACE permission 262

Always Encrypted 310

Always On ...