始终在SQL Server中加密 [英] Always on Encryption in SQL Server

问题描述

当我们在Always Encryption模式中保留一些列时，我们将仅从Code（客户端）检索数据，但这会导致性能以及我们必须解密SQL Server中的每一列。

1.有没有替代方案？

2.我们可以在SQL Server中存储加密密钥，以便我们使用始终加密模式快速检索数据，我们不需要在每个列解密客户端...？

When we kept some column in Always Encryption mode we will retrieve data from Code (Client Side) only but this causes performances as well as we have to decrypt each and every column in SQL Server .
1. Is there any alternative to this ?
2. Can we store Encryption Key in SQL Server so that we will retrieve data quickly using always encryption mode on and we need not decrypt every column at client side...?

 

推荐答案

多数民众赞成方式始终建立加密。如果你想要它不同，你可能需要开发自己的加密技术。 

Thats the way Always Encryption has been built up. If you want it in different, you may have to develop your own encryption techniques. 

这篇关于始终在SQL Server中加密的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！