• Abhijit (8/22/2008)


    yes we can implement column level encryption using the ASYMMETRIC KEY and SYMMETRIC KEY to encrypt & decrypt the column data.

    check msdn for brief help on ASYMMETRIC KEY and SYMMETRIC KEY.

    Thank you, I also found a couple of articles here on this site.

    Any stories to share on the performance impact of column encryption? Any caveats to watch out for?

    __________________________________________________________________________________
    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]