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 ««12

Database encryption Expand / Collapse
Author
Message
Posted Monday, August 29, 2011 7:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 12:18 PM
Points: 2,818, Visits: 2,561
I got a chart at a SQLSaturday that lists all the DMVs and their purpose. Looking at it regularly has really helped me with questions like this. Thanks,
Post #1166899
Posted Monday, August 29, 2011 7:22 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:40 PM
Points: 8,743, Visits: 9,292
stewartc-708166 (8/29/2011)
Interesting question, with some plausable wrong answers
Thanks, Steve

Yes interesting. But are any of the wrong answers actually plausible? Each of them says in effect that any-one with VWSS permission can get hold of actual keys to databases, which seems pretty implausible.


Tom
Post #1166902
Posted Monday, August 29, 2011 8:03 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:31 AM
Points: 4,000, Visits: 1,175
Plausibility is completely relative.
Post #1166916
Posted Monday, August 29, 2011 8:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:32 PM
Points: 13,302, Visits: 12,168
Good question but I don't really agree that it displays "The encryption state of all databases on the instance". This view does not have a record for a database that does not have a key. I have an instance with no encryption and the view returns no results. I suppose the argument could be that a database not displayed does indicate the encryption state as non existent.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1166921
Posted Monday, August 29, 2011 8:40 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:23 AM
Points: 3,299, Visits: 1,978
I checked this view on an instance without any encrypted databases as well and got no results back. I suppose that a better answer choice might have been that it "displays the encryption status of all encrypted databases on an instance." I think the answer was still easy enough to deduce from the choices given though.
Post #1166940
Posted Monday, August 29, 2011 8:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
Nice easy Monday question.
Post #1166950
Posted Monday, August 29, 2011 10:15 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:00 PM
Points: 33,204, Visits: 15,354
Added a note to the answer to specify encrypted databases. It's not necessarily wrong, but it makes the question better, I think.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1166988
Posted Monday, August 29, 2011 10:35 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
thanks for the ¿



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 #1167008
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse