TDE - Encryption Algorithm (AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY)

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  March 4, 2016 at 9:06 pm

  #325345

  When creating DATABASE ENCRYPTION KEY for TDE, which algorithm is preferred, AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY.

  Any performance impact when using one over the other.

  SQL version: 2014 SP1/Enterprise

  Many thanks!

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  March 7, 2016 at 2:39 pm

  #1863576

  Check this out: Choose an Encryption Algorithm

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  March 7, 2016 at 3:43 pm

  #1863589

  Thanks!

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  March 7, 2016 at 4:46 pm

  #1863593

  On a side note, only AES_256 is unbreakable, if it even still is unbreakable...

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  March 7, 2016 at 5:11 pm

  #1863595

  Thanks a lot! I've used AES_128 for my requirement.