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: Tuesday, November 4, 2014 12:48 PM
Points: 2,818, Visits: 2,566
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:38 AM
Points: 7,850, Visits: 9,600
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: Monday, November 17, 2014 7:35 AM
Points: 4,082, Visits: 1,220
Plausibility is completely relative.
Post #1166916
Posted Monday, August 29, 2011 8:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:31 PM
Points: 13,207, Visits: 12,688
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: Wednesday, November 19, 2014 12:24 PM
Points: 3,384, Visits: 2,017
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,228, 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 @ 4:55 PM
Points: 31,278, Visits: 15,736
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 12:45 PM
Points: 17,947, Visits: 15,941
thanks for the ¿



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1167008
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse