SQL Server: Getting Started With Always Encrypted

Abstract:
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.
You will learn:

• What SQL Server's Always Encrypt is
• How to create encrypted columns
• Limitations of queries using encrypted columns
• How to implement Always Encrypt in a VFP application

Prerequisites: Knowledge of SQL Server 2016 and up and SQL Server Management Studio (SSMS)

Agenda:
6:00-6:30 - Networking and speaker setup time
6:30-6:35 - Opening remarks & Introductions
6:35 - Speaker time!