This is THE best video on Always Encrypted. Very helpful, thank you. I have a question - can we setup SQL Transactional replication on encrypted columns?
I agree with the other comments. this is the best video on this topic. My question to all is this. If we have no access to the application code, how do we modify the driver on the client to work with always encrypted.
it's very inspiring. Could u show an example that showcase in app level, how the data could be protected? coz whoever accessing via app level, they can see the decrypted data now
Great explanation really helpful. few questions 1. Windows can be corrupted and we can loss our master key. Any way to backup/restore master key into local computer then into external hard drives. 2. People with small businesses normally uses shared hosting and they do not have access to the Windows Key Store or azure. So where and how we save our master key?
Most sites state that this does not affect the application, but thus far in my experience this is not true. You are limited in the commands you can send through SSMS. For example, if dev's want to insert data, update, etc. traditional sql scripts will not work.
i don't see securing sensitive data is enforced. So any client who sets the connection to "Column Encryption Setting = Enabled" is able to view columns decrypted. What am I missing?
![เปิดใจ "อาจารย์เบียร์ คนตื่นธรรม" อดีตเคยสุดทุกทาง ถ้าใช้หนี้หมดไปบวชแน่ l [Nickynachat]](http://i.ytimg.com/vi/IxeE0xVhy08/mqdefault.jpg)
Excellent explanation. Thanks!
This is THE best video on Always Encrypted. Very helpful, thank you. I have a question - can we setup SQL Transactional replication on encrypted columns?
I agree with the other comments. this is the best video on this topic. My question to all is this. If we have no access to the application code, how do we modify the driver on the client to work with always encrypted.
it's very inspiring. Could u show an example that showcase in app level, how the data could be protected? coz whoever accessing via app level, they can see the decrypted data now
Great explanation really helpful. few questions
1. Windows can be corrupted and we can loss our master key. Any way to backup/restore master key into local computer then into external hard drives.
2. People with small businesses normally uses shared hosting and they do not have access to the Windows Key Store or azure. So where and how we save our master key?
Very nicely simplified explanation Thanks
Does this encryption type support "like" operator and wild cards for searching?
It seems like only column level encryption... Is there anything which can encrypt whole database...?
Thank you so much
Most sites state that this does not affect the application, but thus far in my experience this is not true. You are limited in the commands you can send through SSMS. For example, if dev's want to insert data, update, etc. traditional sql scripts will not work.
Very helpful, thank you.
Thank you so much. This is very helpful.
Thanks Nuwan.
i don't see securing sensitive data is enforced. So any client who sets the connection to "Column Encryption Setting = Enabled" is able to view columns decrypted. What am I missing?
I think in this case both database and the application are on the same machine, which contains the certificate.
Great!!
i don't understand the part about storing certificate.
A better view of your GetMessage (T-SQL) would have been nice
thanks a lot