Choosing between symmetric and asymmetric keys for data encryption

  • I know that symmetric keys are better for performance, while asymmetric keys provide better security.

    How can I decide which type of key to use in my particular application?

    What are the criteria and tests I can use?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • symmetric keys to encrypt data

    asymmetric keys to encrypt the symmetric key.

    http://technet.microsoft.com/en-us/library/ms345262.aspx

  • Steve Jones - Editor (3/23/2009)


    symmetric keys to encrypt data

    asymmetric keys to encrypt the symmetric key.

    http://technet.microsoft.com/en-us/library/ms345262.aspx%5B/quote%5D

    Thank you for the info!

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • The Asymmetric Key Encryption uses dual key managment - Public key for encryption and private key for decryption while symmetric key encryption will use a single key for both. If your business requires you to use dual key managment then you can go for Asymmetric key or else you can settle down with symmetric key.

    ---------------------------------------------------
    Thanks,
    Satheesh.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply