Hi Dinesh, I have implemented the same and getting error with the token that we get from azure ad. It expires after 24 hrs. and the application breaks. Your help is really appreciated. Thanks
Hi, please help , i am using always encryption with ef 6 , sql2017 all working fine on single table query but , whenever i m trying to query with join multiple table. Exception occurs unable to convert data types.
Hi Eric, your encryption is based on deterministic or randomized? You may see some issues when joining, searching or grouping if it is randomized. If that is not the case, can you give more details, like schema, joining columns and columns encrypted.
if you query does not use encrypted columns for joining, in this case roleid, check the data type of roleid in both tables, I do not think that you get this error because of encrypted columns. Will you be able to share you error with the code written? And table structure too? Screenshots are fine, if possible, email me to dineshpriyankara@gmail.com
Hi Vijay, I do not think so because I am not sure whether libraries used for passing keys are available with other than .net languages, however, let me check and see whether it is possible or a workaround is exist.
Dinesh Priyankara no worries. Appreciate it. We are on the wire since we invested so much in Pyspark and now this new sensitive data is needing this always encrypt compliance. Not sure what the alternatives are either.
Here is the URL for the blog post that contains codes related to this video: dinesql.blogspot.com/2017/10/sql-server-always-encrypted-serving-multiple-applications-using-Azure-Key-Vault-and-Certificate-Store.html
Great info and very well presented. Thank you.
Excellent explanation. Thank you!!
This is very good explanation. Thank you.
Superb video. Good help. Thank you so much.
Thank you. This is very helpful.
Thanks Nuwan.
Great video. Just the info I was looking for. It seems much of the command line parts are now available using the UI have you considered updating?
Hi Dinesh, can you please explain how to use always encryption using SSDT in Visual Studio. We are planning to use Azure Key Vault.
Hi Dinesh,
I have implemented the same and getting error with the token that we get from azure ad. It expires after 24 hrs. and the application breaks. Your help is really appreciated. Thanks
Everytime when query execute, api call to key vault ? Can we cache key vault certificate to reduce call as key vault has low SLA
hi, could you please make a video on ''always encrypted with secure enclave - Serving applications using Azure Key Vault'
What you refer to as "SMK" is really "CMK" is that correct?
Hi, please help , i am using always encryption with ef 6 , sql2017 all working fine on single table query but , whenever i m trying to query with join multiple table. Exception occurs unable to convert data types.
Hi Eric, your encryption is based on deterministic or randomized? You may see some issues when joining, searching or grouping if it is randomized. If that is not the case, can you give more details, like schema, joining columns and columns encrypted.
Dinesh Priyankara
Encription type is deterministic. On email. And i am join role table based on user roleiid.
if you query does not use encrypted columns for joining, in this case roleid, check the data type of roleid in both tables, I do not think that you get this error because of encrypted columns. Will you be able to share you error with the code written? And table structure too? Screenshots are fine, if possible, email me to dineshpriyankara@gmail.com
Can I use always encrypt on azure sql database if I use a python program or a Pyspark program as my programming env instead of C# ?
Hi Vijay, I do not think so because I am not sure whether libraries used for passing keys are available with other than .net languages, however, let me check and see whether it is possible or a workaround is exist.
Dinesh Priyankara thank you! Really appreciate it. I have tried to look up with no luck.
Dinesh Priyankara did you find any divers for azure Sql that supports always encrypt with python ?
Not yet Vijay, sorry for that, will check that soon and update you.
Dinesh Priyankara no worries. Appreciate it. We are on the wire since we invested so much in Pyspark and now this new sensitive data is needing this always encrypt compliance. Not sure what the alternatives are either.
Here is the URL for the blog post that contains codes related to this video: dinesql.blogspot.com/2017/10/sql-server-always-encrypted-serving-multiple-applications-using-Azure-Key-Vault-and-Certificate-Store.html