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.


Column encryption key rotation will probably block since it is doing mass updates from a client across a network. We learned to absolutely lock users out of the system while a column is being encrypted with a new CEK.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.