July 4, 2011 at 11:13 pm
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
July 4, 2011 at 11:38 pm
Thank you Gail, this was tough. Not like last week's question :-).
M&M
July 5, 2011 at 1:46 am
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
July 5, 2011 at 2:13 am
ako58 (7/5/2011)
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/c75d0d4b-4008-4e71-9a9d-cee2a566bd3b.htmThe 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]
July 5, 2011 at 2:16 am
I'd have thought you can just reason this through to get to the correct answer.
Nice question Gail.
July 5, 2011 at 2:18 am
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]
July 5, 2011 at 2:35 am
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
July 5, 2011 at 5:41 am
very good, question!!!!
thanks Gail!!!!
July 5, 2011 at 5:46 am
Nice question - thanks!
-Ki
July 5, 2011 at 8:25 am
Good question!
July 5, 2011 at 9:39 am
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
July 5, 2011 at 10:03 am
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
July 5, 2011 at 10:06 am
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
July 5, 2011 at 10:07 am
Lot of TDE questions lately. Is anyone using this feature?
http://brittcluff.blogspot.com/
July 5, 2011 at 10:08 am
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 36 total)
You must be logged in to reply to this topic. Login to reply