Concept : SQL Server Security Encryption - SQLDOG

Encryption:

• BY Using encryption we can secure confidential data when transferring data Between The networks.
• The most important processes is SQL Server security concepts is Encryption.

Encryption restricts hackers to access data by using following steps :

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

Perform symmetric keys Encryption:

This method uses the same key to decrypt and encrypt the data.

 Perform asymmetric keys Encryption:

Here are 2 keys in asymmetric encryption. The Public key encrypts the data when you sending to other network. and  The private key Decrypts the received data after it delivered.

 Perform certificates Encryption :

1. certificates generate by Certification authorities to provide high security.
2. To encrypt the data, The SQL service will use these certificates.
3. Certificate encryption is used to identify devices, users and organizations.