Exam Ref 70-764 Administering a SQL Database Infrastructure

Index

A

actions 206

Activity Monitor 182–183, 188

administrative accounts

Azure SQL Database 49

Advanced Encryption Standard New Instructions (AES-NI) 21

alerts

custom 245

SQL Agent 243–245

ALLOW_SNAPSHOT_ISOLATION isolation level 186

ALTER DATABASE statement 93, 104

ALTER INDEX DISABLE statement 225

ALTER INDEX REBUILD statement 220, 226

ALTER INDEX REORGANIZE statement 220, 225–226

ALTER INDEX statement 220

ALTER TABLE REBUILD statement 220, 226

Always Encrypted (AE) 9–20

application roles 36

asymmetric keys 3, 4, 27

encrypting backups with 25

asynchronous commit mode 289, 291–292

auditing

Azure SQL Database 57–61

blob 59–60

configuration 50–61

database audit specification 51

implementing 54–55

management of 56–57

policies 57–58

querying SQL ...