SQL Server allows column level encryption using feature called Always Encrypted. The application controls encryption of fields such as credit card numbers. Separating responsibilities as the encryption key is not revealed to the database.
In this blog I will work through my Encrypted-DB project on GitHub. The project includes example code and Unit Tests to show how to use this feature.
Using Always Encrypted is an easy and effective way to encrypt sensitive data. Data remains encrypted over the network. The application handles decryption via the driver and the KeyStore.
SQL Server 2016 introduced this feature but the JDBC documentation is lite. Microsoft released its JDBC documentation in May 2020 but does work.