Securing databases with encryption

When storing data in a database, a key question many organizations will need to know, especially when that data is being held with a public cloud provider such as Azure, is: How safe is my data?

Using encryption is a great way to protect data. Encryption protects your data in the event of other protection measures—such as networks, firewalls, or authentication controls— being circumvented. If a hacker were able to bypass other controls, they would not be able to read any encrypted data without the key used to encrypt it.

There are multiple areas where encryption can be used, including the following:

• Encryption in transit
• Encryption at rest
• Encryption in use

First, we will consider in-transit protection.

Encryption in transit

Encrypting data in transit means ensuring that when moving data from point A to point B, any interception of that traffic would not yield anything useful.

Azure SQL Database and Azure SQL...