In this chapter we’ll look at how you interact with data that is encrypted using Always Encrypted. First, we’ll use SQL Server Management Studio (SSMS), and we’ll have a look at what happens in the background when you execute a query. We’ll also look at stored procedures. Then we’ll cover how you can do the same from your application code – using PowerShell for the examples.
One thing to remember is that the encryption activities all occur in the client, be that SSMS or your application. As such ...
