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: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
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: Today @ 1:33 PM
Points: 8,571, Visits: 9,076
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
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: Today @ 7:43 AM
Points: 3,971, Visits: 1,154
Plausibility is completely relative.
Post #1166916
Posted Monday, August 29, 2011 8:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 13,126, Visits: 11,964
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: Sunday, July 27, 2014 10:34 AM
Points: 3,261, Visits: 1,955
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: Today @ 4:10 PM
Points: 33,095, Visits: 15,202
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: Today @ 4:30 PM
Points: 21,290, Visits: 14,982
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