Always Encryption In Azure Sql ( Client Side Encryption)

I've Implemented Always Encryption method in my Project, after knowing that it encrypts's the data in Client Side Code and Never reveals the Data to DataBase Engine. I've gone thro

Solution 1:

You can use SQL profiler that can be accessed through SSMS. You can find it in SSMS menu as Tools -> Sql Server Profiler. With some google search, you can find resources on how to use it.

I would create two tables having the same schema. Encrypt a couple of columns of one of the tables using Always Encrypted. Run select, insert and point lookup queries for each table. You will see that for table with Always Encrypted columns, you will see encrypted values being sent to SQL Server for the encrypted columns whereas for plaintext table all the values sent to the server will be in plain text.

Solution 2:

SQL-Profiler is a good way to Prove the Data is Encrypted through-out the Network.I've tried with Fiddler as well as SQL Profile. Both Proved my data were encrypted through out the Channel between Client and SQL Server. I would like to Show Images on this. (May be helpful for others)

Fiddler(Client Network Traffic)

SQL-Profiler (Data's from Client to SQL Server as Encrypted)