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 Monday, July 4, 2011 11:13 PM


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 @ 1:14 PM
Points: 40,615, Visits: 37,081
Comments posted to this topic are about the item Transparent database encryption


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 #1136215
Posted Monday, July 4, 2011 11:38 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
Thank you Gail, this was tough. Not like last week's question .

Mohammed Moinudheen
Post #1136217
Posted Tuesday, July 5, 2011 1:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 12, 2014 5:26 AM
Points: 1,706, Visits: 252
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
Post #1136254
Posted Tuesday, July 5, 2011 2:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
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.


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1136262
Posted Tuesday, July 5, 2011 2:16 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:32 AM
Points: 1,417, Visits: 809
I'd have thought you can just reason this through to get to the correct answer.

Nice question Gail.
Post #1136264
Posted Tuesday, July 5, 2011 2:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
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


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1136265
Posted Tuesday, July 5, 2011 2:35 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 @ 1:14 PM
Points: 40,615, Visits: 37,081
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 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 #1136271
Posted Tuesday, July 5, 2011 5:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:55 AM
Points: 1,262, Visits: 13,558
very good, question!!!!

thanks Gail!!!!



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1136384
Posted Tuesday, July 5, 2011 5:46 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, June 19, 2014 8:00 AM
Points: 363, Visits: 1,425
Nice question - thanks!

-Ki
Post #1136391
Posted Tuesday, July 5, 2011 8:25 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 11:55 AM
Points: 2,227, Visits: 292
Good question!

Simone
Post #1136515
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse