When using Always Encrypted in SQL Server 2016, how do I as the DBA view the data?

The short answer is, you don’t. The entire point of Always Encrypted is that the DBA can’t view or modify the data using SQL Server Management Studio. The only way to view and change the data is by using the front end application that created the data. This means that if someone submits a ticket…

The post When using Always Encrypted in SQL Server 2016, how do I as the DBA view the data? appeared first on SQL Server with Mr. Denny.