What are the encyption options available in SQL server?

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  March 1, 2018 at 11:06 am

  #329526

  Hi All,

  What are the available options to encrypt data across the wire and store data in database in an encrypted way.

  Using SQL 2016 is being used. Would like to know the viable options prior to SQL 2016 as well(if any).

  Thanks,

  Sam

• Evgeny Garaev

  SSCertifiable

  Points: 7428

  More actions

  March 1, 2018 at 4:09 pm

  #1981720

  TDE
  Data Encryption (using T-SQL functions)
  Always Encrypted
  Transport Encryption

  Check this article - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/sql-server-encryption