Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Transparent database encryption Expand / Collapse
Author
Message
Posted Tuesday, July 5, 2011 9:39 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 21,187, Visits: 14,879
Nice question Gail. Can you give us something harder?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1136588
Posted Tuesday, July 5, 2011 10:03 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:54 PM
Points: 42,434, Visits: 35,488
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 2008, MVP
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

Post #1136615
Posted Tuesday, July 5, 2011 10:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 11, 2014 12:42 PM
Points: 1,380, Visits: 2,682
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
Post #1136620
Posted Tuesday, July 5, 2011 10:07 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Lot of TDE questions lately. Is anyone using this feature?

http://brittcluff.blogspot.com/
Post #1136621
Posted Tuesday, July 5, 2011 10:08 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 21,187, Visits: 14,879
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1136622
Posted Tuesday, July 5, 2011 10:14 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:54 PM
Points: 42,434, Visits: 35,488
SQLRNNR (7/5/2011)
SQLRNNR (7/5/2011)
Nice question Gail. Can you give us something harder?


Can't win them all...


If you want... I have a log internals question that I can submit. The chance of anyone getting it right except by guessing however is minimal...



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1136633
Posted Tuesday, July 5, 2011 10:20 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 21,187, Visits: 14,879
GilaMonster (7/5/2011)
SQLRNNR (7/5/2011)
SQLRNNR (7/5/2011)
Nice question Gail. Can you give us something harder?


Can't win them all...


If you want... I have a log internals question that I can submit. The chance of anyone getting it right except by guessing however is minimal...


<devil advocate> Awesome </devil>

Even if I do miss it. I would learn something. Heck, I wouldn't even have a problem admitting that I missed it




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1136637
Posted Tuesday, July 5, 2011 10:24 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:54 PM
Points: 42,434, Visits: 35,488
Ok. I'll write it up (carefully). You're warned...

Not really useful information for most people. Internals stuff.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1136641
Posted Tuesday, July 5, 2011 10:31 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:44 PM
Points: 21,187, Visits: 14,879
GilaMonster (7/5/2011)
Ok. I'll write it up (carefully). You're warned...

Not really useful information for most people. Internals stuff.


Want me to review it for you??¿




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1136659
Posted Tuesday, July 5, 2011 12:17 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:31 AM
Points: 1,758, Visits: 2,135
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?






Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1136741
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse