Pro encryption in SQL Server 2022 : provide the highest level of protection for your data

Pro encryption in SQL Server 2022 : provide the highest level of protection for your data / Matthew McGiffen.

This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the highest levels of protection for sensitive data using Alwa...

Full description

Saved in:
Bibliographic Details
Main Author: McGiffen, Matthew (Author)
Format: eBook
Language:English
Published: New York, NY : Apress, [2022]
Edition:[First edition].
Subjects:
SQL server.
SQL server
Database management.
Data encryption (Computer science)
Database management
Online Access:Click for online access
Table of Contents:
  • Part I: Understanding the Landscape
  • Purpose of Encryption and Available Tools
  • Part II: At-Rest Encryption
  • Introducing Transparent Data Encryption
  • Setting Up TDE
  • Managing TDE
  • Backup encryption
  • Part III: Column Encryption using Always Encrypted
  • Introducing Always Encrypted
  • Setting up Always Encrypted
  • Executing queries using Always Encrypted
  • Encrypting existing data with Always Encrypted
  • Limitations with Always Encrypted
  • Key rotation with Always Encrypted
  • Considerations when implementing Always Encrypted
  • Part IV: Column Encryption using Always Encrypted with Enclaves
  • Introducing Always Encrypted with enclaves
  • Setting up Always Encrypted with enclaves
  • In-place encryption with Always Encrypted enclaves
  • Rich querying with Always Encrypted enclaves
  • Setting up TPM attestation
  • Part V: Completing the picture
  • Encryption in transit using transport layer security
  • Hashing and salting of passwords
  • Extensible key management (EKM)
  • Other methods of column encryption.

Similar Items