Does Always Encrypted cause blocking queries or locking object?
-1
votes
1
answer
179
views
I have perform some test with relatively small tables and the encryption took a very long time (maybe because there are many SQL objects that are referring the target table).
I am wondering(worrying) when a table is being encrypted, is it possible to read the encrypted data or query the table? I only found this :
> While the data is being re-encrypted, your applications cannot write
> to the impacted tables. Therefore, your organization needs to plan a
> column encryption key rotation very carefully.
and it is about the rotation.
Asked by gotqn
(4348 rep)
Feb 19, 2018, 10:18 AM
Last activity: Oct 26, 2019, 07:02 PM
Last activity: Oct 26, 2019, 07:02 PM