東華大學圖書館 |

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

紀錄類型:	書目-電子資源 : Monograph/item
正題名/作者:	Pro encryption in SQL Server 2022/ by Matthew McGiffen.
其他題名:	provide the highest level of protection for your data /
作者:	McGiffen, Matthew.
出版者:	Berkeley, CA :Apress : : 2022.,
面頁冊數:	xxiv, 351 p. :ill. (some color), digital ;24 cm.
內容註:	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.
Contained By:	Springer Nature eBook
標題:	Database management. -
電子資源:	https://doi.org/10.1007/978-1-4842-8664-7
ISBN:	9781484286647

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

Pro encryption in SQL Server 2022provide the highest level of protection for your data /[electronic resource] :by Matthew McGiffen. - Berkeley, CA :Apress :2022. - xxiv, 351 p. :ill. (some color), digital ;24 cm.

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.

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 Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection. 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 and meeting regulatory requirements. The book teaches you how to work with the encryption technologies in SQL Server with the express goal of helping you understand those technologies on an intuitive level. You'll come away with a deep level of understanding that allows you to answer questions and speak as an expert. The book's aim is to make you as comfortable in deploying encryption in SQL Server as you would be in driving your car to buy groceries. Those with a data security mindset will appreciate the discussion of how each feature protects you and what it protects you from, as well as how to implement things in the most secure manner. Database administrators will appreciate the high level of detail around managing encryption over time and the effect of encryption on database performance. All readers will appreciate the advice on how to avoid common pitfalls, ensuring that your projects to implement encryption run smoothly. What You Will Learn Architect an effective encryption strategy for new applications Retrofit encryption into your existing applications Encrypt data at rest, in memory, and in transit Manage key and certificate life cycles, including backup and restore Recover encrypted databases in case of server failure Work with encryption in cloud-based scenarios.

ISBN: 9781484286647

Standard No.: 10.1007/978-1-4842-8664-7doiSubjects--Uniform Titles:

SQL server.
Subjects--Topical Terms:

527442
Database management.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.7585

Pro encryption in SQL Server 2022 = provide the highest level of protection for your data /
LDR:04461nmm a2200325 a 4500 001 2306006
003 DE-He213
005 20221117084836.0
006 m d
007 cr nn 008maaau
008 230409s2022 cau s 0 eng d
020 $a 9781484286647 $q (electronic bk.)
020 $a 9781484286630 $q (paper)
024 7 $a 10.1007/978-1-4842-8664-7 $2 doi
035 $a 978-1-4842-8664-7
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.9.D3
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 005.7585 $2 23
090 $a QA76.9.D3 $b M145 2022
100 1 $a McGiffen, Matthew. $3 3609588
245 1 0 $a Pro encryption in SQL Server 2022 $h [electronic resource] : $b provide the highest level of protection for your data / $c by Matthew McGiffen.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2022.
300 $a xxiv, 351 p. : $b ill. (some color), digital ; $c 24 cm.
505 0 $a 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.
520 $a 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 Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection. 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 and meeting regulatory requirements. The book teaches you how to work with the encryption technologies in SQL Server with the express goal of helping you understand those technologies on an intuitive level. You'll come away with a deep level of understanding that allows you to answer questions and speak as an expert. The book's aim is to make you as comfortable in deploying encryption in SQL Server as you would be in driving your car to buy groceries. Those with a data security mindset will appreciate the discussion of how each feature protects you and what it protects you from, as well as how to implement things in the most secure manner. Database administrators will appreciate the high level of detail around managing encryption over time and the effect of encryption on database performance. All readers will appreciate the advice on how to avoid common pitfalls, ensuring that your projects to implement encryption run smoothly. What You Will Learn Architect an effective encryption strategy for new applications Retrofit encryption into your existing applications Encrypt data at rest, in memory, and in transit Manage key and certificate life cycles, including backup and restore Recover encrypted databases in case of server failure Work with encryption in cloud-based scenarios.
630 0 0 $a SQL server. $3 542688
650 0 $a Database management. $3 527442
650 0 $a Data encryption (Computer science) $3 579162
710 2 $a SpringerLink (Online service) $3 836513
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-8664-7
950 $a Professional and Applied Computing (SpringerNature-12059)