Securing SQL Server: DBAs Defending the Database

Index

A

Always Encrypted

application’s code

architecture

column encryption key

column master key

implementation

Application.CreditCards table

column master key

column selection page

deterministic encryption

key store values

Master Key Configuration page

New Column Encryption Key dialog box

New Column Master Key dialog box

randomized encryption

Run Settings page

Windows Certificate Store

key store

limitations

privileged users

Amazon Key Management Services

Application programming interface (API)

Asymmetric keys

Audit Action Groups

audit level

database level

server level

Audit metadata

advantages, SQL Server Audit

storage

sys.fn_get_audit_file()

columns

parameters

AvailabilityRole

B

Backups

media ( see Media, backup)

recovery modes ( see Recovery modes, backups)

types

differential ...