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.

  • Regarding safety of TDE and BitLocker, see technet.microsoft.com/en-us/library/cc278098.aspx.
    – Dan Guzman
    Commented May 26, 2015 at 16:45
  • @jamesakadamingo Did you go ahead with using BitLocker? If so has it worked OK?
    – Matt F
    Commented Jun 25, 2015 at 10:44
  • We have trialled it in our dev environment and it seems to go well but that's with limited load. But we are still debating other options for live. Commented Jun 25, 2015 at 11:16


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.