So many thanks Monica, great session and useful to start with this feature. Can you please confirm that I need, in a .Net application, put "Column Encryption Setting=enables" in the connection string in order my app to work seamlessly with sql and retreive the birth date without any additional steps, thanks
one thing miss, in the SSMS always encryption option and connection string thing.... DBA still able to see the encrypted data! not like what you have said at the beginning of this video that even DBA can't see it.
In our SW development environment we have many databases and servers (over 10) that could use encrypted columns. The problem I have is once I import all the certificates for all these databases to my dev PC I have over 10 identical looking Always Encrypted certificates (all showing Issued To and Issued By as "Always Encrypted Auto Certificate1" when viewed with certmgr.msc or certlm.msc). So how am I supposed to tell them apart and know which one came from which server and DB ? Is there any way to select a different Issued By or Issued To label? I looked at the Powershell script the SSMS GUI generates and I dont see where in that script there is any control of the "Issued To" and "Issued By" fields for the certs.
Thanks for the question. Sometimes our speakers are able to answer questions here on YT but sometimes you may need to go directly to them to get an answer - you can find Monica on LinkedIn at www.linkedin.com/in/sqlespresso/
So many thanks Monica, great session and useful to start with this feature. Can you please confirm that I need, in a .Net application, put "Column Encryption Setting=enables" in the connection string in order my app to work seamlessly with sql and retreive the birth date without any additional steps, thanks
very good tutorial
Glad you think so!
one thing miss, in the SSMS always encryption option and connection string thing.... DBA still able to see the encrypted data! not like what you have said at the beginning of this video that even DBA can't see it.
Awesome work
Thanks a lot 😊
In our SW development environment we have many databases and servers (over 10) that could use encrypted columns. The problem I have is once I import all the certificates for all these databases to my dev PC I have over 10 identical looking Always Encrypted certificates (all showing Issued To and Issued By as "Always Encrypted Auto Certificate1" when viewed with certmgr.msc or certlm.msc). So how am I supposed to tell them apart and know which one came from which server and DB ? Is there any way to select a different Issued By or Issued To label? I looked at the Powershell script the SSMS GUI generates and I dont see where in that script there is any control of the "Issued To" and "Issued By" fields for the certs.
Thanks for the question. Sometimes our speakers are able to answer questions here on YT but sometimes you may need to go directly to them to get an answer - you can find Monica on LinkedIn at www.linkedin.com/in/sqlespresso/
How to protect that encryption, I see that with certain user permissions it can be easily accessed.
how to insert a record into this table with encrypted column?
101 Loves it.
I stopped watching this when I heard the term non-binary. I'll learn this somewhere else.