I will start this question with a few statements to negate any "Why" questions that are going to be asked.
- The Head of IT wants the data encrypted.
- Our profession is such that encrypted data is sensible.
- Enterprise Edition is an option, albeit a costly one.
We are looking at moving one of our user groups into Azure hosting (RDP, Files, Database, etal). Some members of the department are concerned that as Azure is a public cloud it is possible (although very improbable) that our data could be accessed by another party.
So at rest data encryption has been mooted; I would be happy to use SQLs native TDE, but that is an extra cost (and not a small one) so other options have been looked at.
The Systems Admin has put the idea of bitlocker forward; I know that SQL can be installed and run in a bitlocker encrypted drive. However is it a good idea; has anyone got any experience of using a enterprise level database on a bitlocker encrypted drive?
The sort of answers I am after will look at the performance, safety of both the data and the system; and perhaps suggest other options.