Database encryption

Question

Post reply

Database encryption

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
August 28, 2011 at 1:13 am

#75605

Comments posted to this topic are about the item Database encryption
August 29, 2011 at 12:41 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply

CoolCodeShare SSCrazy Points: 2584 More actions · Answer 1

Question is nice but framed incorrectly. since it's a view, It doesn't store.

The concept is good.

M&M SSC-Insane Points: 21700 More actions · Answer 2

M&M

SSC-Insane

Points: 21700

August 28, 2011 at 9:31 pm

#1374363

Thanks for the question.

M&M

Kameswari Aravindh SSCrazy Points: 2380 More actions · Answer 3

Kameswari Aravindh

SSCrazy

Points: 2380

August 29, 2011 at 3:01 am

#1374405

Nice Question. Thanks.:-)

Arjun SreeVastsva SSCertifiable Points: 7141 More actions · Answer 4

Arjun SreeVastsva

SSCertifiable

Points: 7141

August 29, 2011 at 3:09 am

#1374410

N i c e Q u e s t i o n

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Great question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 6

good question!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 7

Thanks for the question even though nothing is stored within a view. It is display only in this case.

http://brittcluff.blogspot.com/

Mattrick Ten Centuries Points: 1176 More actions · Answer 8

Mattrick

Ten Centuries

Points: 1176

August 29, 2011 at 6:17 am

#1374453

Nice question. Thanks.

Matt

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 9

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,

TomThomson SSC Guru Points: 104773 More actions · Answer 10

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

LostAccount SSCarpal Tunnel Points: 4951 More actions · Answer 11

LostAccount

SSCarpal Tunnel

Points: 4951

August 29, 2011 at 8:03 am

#1374490

Plausibility is completely relative.

Sean Lange SSC Guru Points: 286590 More actions · Answer 12

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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Ken SSCoach Points: 17191 More actions · Answer 13

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.