SQL Server: Getting Started With Always Encrypted

Описание: This session was presented by Jody Meyer at Southwest Fox 2023 (https://swfox.net)

Content is king... especially to the people that want to steal personal information like social security numbers, credit card numbers, birth dates, and other sensitive information. SQL Server 2016 introduced a way to encrypt column content by using Always Encrypted. This enables the sensitive content to be available to people that need access to it. Always Encrypted also prevents access to sensitive content for unauthorized persons and even DBAs.

In today's database environment, encrypting content is required. It protects companies and their customers from theft of their personal information. Implementing SQL Server Always Encrypted is a great start in ensuring unauthorized access to that data.

In this session, Jody will walk through the steps of implementing Always Encrypted in SQL Server 2022 using SQL Server Management Studio (SSMS). She will demonstrate the limitations of queries using Always Encrypted columns. Jody will demonstrate the steps of incorporating SQL Server Always Encrypted in a simple VFP application using SQL Server database backend. She will discuss the use of the SQL Server Connection string in a simple VFP application and how to flip between encrypted and unencrypted content. She will discuss some of the limitations of using Always Encrypted.