O'Reilly logo

Securing SQL Server: DBAs Defending the Database by Peter A. Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required