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:
Online Access:Click for online access

MARC

LEADER 00000cam a22000007i 4500
001 on1351472318
003 OCoLC
005 20240623213015.0
006 m o d
007 cr cnu|||unuuu
008 221122t20222022nyua o 001 0 eng d
040 |a ORMDA  |b eng  |e rda  |e pn  |c ORMDA  |d EBLCP  |d GW5XE  |d STF  |d YDX  |d OCLCF  |d UKAHL  |d OCLCQ  |d VLB  |d OCLCQ  |d OCLCO  |d OCLCQ 
019 |a 1351462750  |a 1353220093  |a 1389611320  |a 1390560673  |a 1390918768  |a 1391440170  |a 1392346188  |a 1393305703  |a 1394117795  |a 1396928486  |a 1397574697  |a 1398118973  |a 1399169394  |a 1401058713  |a 1402028685  |a 1402813106  |a 1405368133  |a 1406411762  |a 1407282849  |a 1409028355  |a 1409662122  |a 1410592383  |a 1411300311  |a 1412615694 
020 |a 9781484286647  |q (electronic bk.) 
020 |a 1484286642  |q (electronic bk.) 
020 |z 1484286634 
020 |z 9781484286630 
024 7 |a 10.1007/978-1-4842-8664-7  |2 doi 
035 |a (OCoLC)1351472318  |z (OCoLC)1351462750  |z (OCoLC)1353220093  |z (OCoLC)1389611320  |z (OCoLC)1390560673  |z (OCoLC)1390918768  |z (OCoLC)1391440170  |z (OCoLC)1392346188  |z (OCoLC)1393305703  |z (OCoLC)1394117795  |z (OCoLC)1396928486  |z (OCoLC)1397574697  |z (OCoLC)1398118973  |z (OCoLC)1399169394  |z (OCoLC)1401058713  |z (OCoLC)1402028685  |z (OCoLC)1402813106  |z (OCoLC)1405368133  |z (OCoLC)1406411762  |z (OCoLC)1407282849  |z (OCoLC)1409028355  |z (OCoLC)1409662122  |z (OCoLC)1410592383  |z (OCoLC)1411300311  |z (OCoLC)1412615694 
037 |a 9781484286647  |b O'Reilly Media 
050 4 |a QA76.9.D3  |b M34 2022eb 
049 |a HCDD 
100 1 |a McGiffen, Matthew,  |e author. 
245 1 0 |a Pro encryption in SQL Server 2022 :  |b provide the highest level of protection for your data /  |c Matthew McGiffen. 
250 |a [First edition]. 
264 1 |a New York, NY :  |b Apress,  |c [2022] 
264 4 |c ©2022 
300 |a 1 online resource (xxiv, 351 pages : illustrations (some color)) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
500 |a Includes index. 
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 Who This Book Is For Database developers, architects, and administrators who want to work with encryption in SQL Server; those who want to maintain encryption whether data is at rest or being transmitted over the network; and those who wish to encrypt their data even when in the server's own memory. Readers should be familiar with SQL Server, but no existing knowledge of encryption is assumed. 
588 0 |a Print version record. 
505 0 0 |g Part I:  |t Understanding the Landscape --  |t Purpose of Encryption and Available Tools --  |g Part II:  |t At-Rest Encryption --  |t Introducing Transparent Data Encryption --  |t Setting Up TDE --  |t Managing TDE --  |t Backup encryption --  |g Part III:  |t Column Encryption using Always Encrypted --  |t Introducing Always Encrypted --  |t Setting up Always Encrypted --  |t Executing queries using Always Encrypted --  |t Encrypting existing data with Always Encrypted --  |t Limitations with Always Encrypted --  |t Key rotation with Always Encrypted --  |t Considerations when implementing Always Encrypted --  |g Part IV:  |t Column Encryption using Always Encrypted with Enclaves --  |t Introducing Always Encrypted with enclaves --  |t Setting up Always Encrypted with enclaves --  |t In-place encryption with Always Encrypted enclaves --  |t Rich querying with Always Encrypted enclaves --  |t Setting up TPM attestation --  |g Part V:  |t Completing the picture --  |t Encryption in transit using transport layer security --  |t Hashing and salting of passwords --  |t Extensible key management (EKM) --  |t Other methods of column encryption. 
630 0 0 |a SQL server. 
630 0 7 |a SQL server  |2 fast 
650 0 |a Database management. 
650 0 |a Data encryption (Computer science) 
650 7 |a Data encryption (Computer science)  |2 fast 
650 7 |a Database management  |2 fast 
776 0 8 |i Print version:  |a McGiffen, Matthew.  |t Pro encryption in SQL Server 2022.  |d New York : Apress, 2022  |z 9781484286630  |w (OCoLC)1346946907 
856 4 0 |u https://holycross.idm.oclc.org/login?auth=cas&url=https://link.springer.com/10.1007/978-1-4842-8664-7  |y Click for online access 
903 |a SPRING-COMPUTING2022 
994 |a 92  |b HCD