Transparent database encryption

  • Comments posted to this topic are about the item Transparent database encryption

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thank you Gail, this was tough. Not like last week's question :-).

    M&M

  • 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

  • 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

    That's right, for new writes, but when encryption is set the entire database is encrypted immediately using an asynchronous background thread.

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • I'd have thought you can just reason this through to get to the correct answer.

    Nice question Gail.

  • Great question. For me, I couldn't decide between the background task running after the ALTER DATABASE command completed or immediately, before the ALTER DATABASE completed, as the background thread is asynchronous and I wasn't sure if the ALTER DATABASE had other work to do after it kicked the thread off.

    Fortunately, I chose correctly 🙂

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • mohammed moinudheen (7/4/2011)


    Thank you Gail, this was tough. Not like last week's question :-).

    See, that was just a warmup. 🙂

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • very good, question!!!!

    thanks Gail!!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • Nice question - thanks!

    -Ki

  • Good question!

    Simone
  • Nice question Gail. Can you give us something harder? 😉

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR (7/5/2011)


    Nice question Gail. Can you give us something harder? 😉

    I could, but then people would complain.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Dang, I clicked too fast without thinking it through and got it wrong. Great Question though, thanks!

    ---------------------------------------------------------------------
    Use Full Links:
    KB Article from Microsoft on how to ask a question on a Forum

  • Lot of TDE questions lately. Is anyone using this feature?

    http://brittcluff.blogspot.com/

  • SQLRNNR (7/5/2011)


    Nice question Gail. Can you give us something harder? 😉

    Can't win them all...

    I think some trivia from Holy Grail would be good to toss in from time to time.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 1 through 15 (of 37 total)

You must be logged in to reply to this topic. Login to reply