Pro Encryption in SQL Server 2022 Provide the Highest Level of Protection for Your Data

The book highlights work that Microsoft has been doing since 2016 to make encryption more accessible, by making TDE available in the standard edition, and the introduction of Always Encrypted that requires minimal work on your part to implement powerful and effective encryption, protecting your data...

Full description

Bibliographic Details
Main Author: McGiffen, Matthew
Format: eBook
Language:English
Published: Berkeley, CA Apress 2022, 2022
Edition:1st ed. 2022
Subjects:
Online Access:
Collection: Springer eBooks 2005- - Collection details see MPG.ReNa
Table of Contents:
  • Introduction
  • Part I. Understanding the Landscape
  • 1. Purpose of Encryption and Available Tools
  • Part II. Transparent Data Encryption (TDE)
  • 2. Introducing Transparent Data Encryption
  • 3. Setting Up TDE
  • 4. Managing TDE
  • 5. Backup Encryption
  • Part III. Always Encrypted
  • 6. What Is Always Encrypted?
  • 7. Setting Up Always Encrypted
  • 8. Executing Queries Using Always Encrypted
  • 9. Encrypting Existing Data with Always Encrypted
  • 10. Limitations with Always Encrypted
  • 11. Key Rotation with Always Encrypted
  • 12. Considerations When Implementing Always Encrypted
  • Part IV. Always Encrypted with Enclaves
  • 13. Introducing Always Encrypted With Enclaves
  • 14. Setting Up Always Encrypted With Enclaves
  • 15. In-Place Encryption With Always Encrypted
  • Part V. Completing the Picture
  • 16. Rich Querying With Always Encrypted Enclaves
  • 17. Setting Up TPM Attestation
  • 18. Encryption In Transit Using Transport Level Security
  • 19. Hashing and Salting of Passwords
  • 20. Extensible Key Management (EKM)
  • Appendixes
  • A. Glossary of Terms
  • B. Encryption in the Cloud
  • C. Encryption Algorithms