SQL Server Security Encryption Concept

          Encryption:

•  Encryption is a one of the important process in SQLServer security concepts.
•  Using encryption we can protect the confidential data while transferring data through       networks.
• It restricts hackers to access data. 

1. Encryption using certificate.
2. Encryption using asymmetric keys.
3. Encryption using symmetric keys.

1.Encryption using certificate:

• Certificate Encryption is used to identify users,devices and organizations.
• Certification authorities generate these certificates to provide high security.
• SQL service will use these certificates and encrypts data.

2.Encryption using asymmetric keys:

• asymmetric keys uses a public key that encrypts data before sending and private decrypts that message after receiving.Here we have 2 keys in encryption.

3.Encryption using symmetric keys:

• symmetric key uses same key to encrypt and decrypt the data.

NOTE:Transparent Data Encryption(TDE):TDE is a SQLServer2012 enhanced feature that allows encryption of data in better way.