• ako58 (7/5/2011)


    ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/c75d0d4b-4008-4e71-9a9d-cee2a566bd3b.htm

    The pages in an encrypted database are encrypted before they are written to disk and decrypted when read into memory

    Yep, thought that was the answer too.

    Question asked:

    "If you enable transparent database encryption in your database, when is THE PAGE encrypted?" (Emphasis added)

    So, lead me to believe the question was referring to a dirty page, as opposed to the intent of the reference cited for the correct answer:

    "The server starts a background thread (called the encryption scan or scan) that scans all database files and encrypts them (or decrypts them if you are disabling TDE). "

    Imagine the difference in the number of wrong answers if the question was more in line with the reference used:

    "If you enable transparent database encryption in your database, when is THE DATABASE encrypted?" (Emphasis added)

    While I appreciate the poster's efforts, I can't applaud this as a great question.

    Here's a thought, how about a small (10 or less) person question review panel to spot problems with questions BEFORE they are posted. That would be a check on the ever-present problem with these questions?

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn