问题描述
我已经在我的项目中实现了Always 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已通过和，并获得了明确的想法，即加密/解密是在客户端级别（驱动程序）中完成的。
I've gone through here and here and got a Clear Idea that Encryption/Decryption is done in Client Level(Driver).
此外，我已经发布了也获得了相同的答案。
Also, I've already posted a Question on this site too and got the Same Answers.
尽管如此，我仍然需要向我的官员证明在数据库调用和客户端代码之间数据将被加密。他们只是忽略了文档。
Although, I've needed to prove it to my Officials that between the Database Call and Client Code the data's will be encrypted.They simply ignore the Documentation.
我应该如何证明他们在客户端和SQL Server之间的网络期间，数据是加密的还是未解密的？
How should I've able to prove them that during the network between the client and SQL server the Data in Encrypted and not Decrypted?
我尝试使用Process Monitor。但这似乎不起作用，它列出了Visual Studio执行（主要是DLL调用）背后的所有过程
I tried with Process monitor. But it does not seem to work, it listing all the process behind the Visual Studio Execution(mostly DLL Calls)
我可以使用Fiddler进行监视吗？
Can i use Fiddler to Monitor ?
推荐答案
您可以使用可以通过SSMS访问的SQL事件探查器。
您可以在以下位置找到它SSMS菜单为工具-> Sql Server Profiler。
通过一些Google搜索，您可以找到有关如何使用它的资源。
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.
我将创建两个具有相同架构的表。使用Always Encrypted对其中一个表的两列进行加密。
对每个表运行选择，插入和指向查找查询。您将看到对于具有Always Encrypted列的表，您将看到已加密列的加密值发送到SQL Server，而对于纯文本表，所有发送到服务器的值将以纯文本格式。
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.
这篇关于在Azure SQL中始终加密（客户端加密）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！