{"product_id":"pro-encryption-in-sql-server-2022-provide-the-highest-level-of-protection-for-your-data-paperback-1","title":"Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eMatthew McGiffen\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eThis 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.\u003c\/p\u003e \u003cp\u003eThe 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. \u003c\/p\u003e \u003cp\u003eThose 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.\u003c\/p\u003e\u003cbr\u003e\u003cb\u003eWhat You Will Learn\u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eArchitect an effective encryption strategy for new applications\u003c\/li\u003e\n\u003cli\u003eRetrofit encryption into your existing applications\u003c\/li\u003e\n\u003cli\u003eEncrypt data at rest, in memory, and in transit\u003c\/li\u003e\n\u003cli\u003eManage key and certificate life cycles, including backup and restore\u003c\/li\u003e\n\u003cli\u003eRecover encrypted databases in case of server failure\u003c\/li\u003e\n\u003cli\u003eWork with encryption in cloud-based scenarios\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e\u003c\/p\u003e\u003cb\u003eWho This Book Is For\u003c\/b\u003e\u003cbr\u003eDatabase 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.\u003cbr\u003e\u003ch3\u003eBack Jacket\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eThis 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.\u003c\/p\u003e\u003cp\u003eThe 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. \u003c\/p\u003e\u003cp\u003eThose 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.\u003c\/p\u003e\u003cbr\u003eWhat You Will Learn\u003cbr\u003e\u003cul\u003e\n\u003cli\u003eArchitect an effective encryption strategy for new applications\u003c\/li\u003e\n\u003cli\u003eRetrofit encryption into your existing applications\u003c\/li\u003e\n\u003cli\u003eEncrypt data at rest, in memory, and in transit\u003c\/li\u003e\n\u003cli\u003eManage key and certificate life cycles, including backup and restore\u003c\/li\u003e\n\u003cli\u003eRecover encrypted databases in case of server failure\u003c\/li\u003e\n\u003cli\u003eWork with encryption in cloud-based scenarios\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003e\u003c\/p\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003cb\u003e​\u003c\/b\u003e\u003cb\u003eMatthew McGiffen\u003c\/b\u003e is a Data Architect with over 20 years' experience working on SQL Server and associated technologies. Matthew has also had the opportunity to collaborate with Microsoft during the development of some of the latest enhancements in encryption. He is the author of a popular blog on SQL Server and has written articles for SQL Server Central. In his spare time, Matthew is an amateur chess player and pianist.\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 351\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.78 x 10 x 7 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eIllustrated:\u003c\/strong\u003e Yes\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e November 18, 2022\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":52491568808243,"sku":"9781484286630","price":77.18,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0300\/5595\/6612\/files\/MDJ5T3Z2WTZ2ajdkYVFEcFBRV2Q2QT09_51dc79b4-26fd-4a56-9da5-316b6137ddfa.webp?v=1759921049","url":"https:\/\/www.vysn.com\/products\/pro-encryption-in-sql-server-2022-provide-the-highest-level-of-protection-for-your-data-paperback-1","provider":"VYSN","version":"1.0","type":"link"}