Securing SQL Server: DBAs Defending the Database

Index

A, B

1. Always Encrypted

   1. architecture

   2. column encryption key

   3. column master key

   4. limitations

2. API

SeeApplication programming interface (API)

1. Application programming interface (API)

2. Asymmetric keys

3. Audit metadata

   1. sys.fn_get_audit_file()

4. AvailabilityRole

C

1. CarterSecureSafe

2. Certificate authority (CA)

   1. DPAPI

   2. self-signed certificate

3. CHECKSUM() function

4. Clients communication

5. Column encryption key

6. Column master key

7. Constant password changes

   1. dynamic value

   2. job creation, general page

8. CREATE CERTIFICATE

9. CREATE SYMMETRIC KEY

10. Cryptographic functions

D

1. Database administrators (DBAs)

2. Database encryption key

3. Database-level security

   1. Create SalesRole

   2. fixed database roles

   3. user with a Login

   4. without a Login

      1. contained database

      2. SID

      3. sys.database_principals

      4. Windows Security Principal

4. Data-level security

   1. dynamic ...