Encryption

Question

Encryption

Shanalise

Hall of Fame

Points: 3188
More actions
June 15, 2010 at 9:28 pm

#387163

Comments posted to this topic are about the item Encryption

Viewing 14 posts - 1 through 13 (of 13 total)

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

malleswarareddy_m SSCertifiable Points: 5847 More actions · Answer 1

I read msdn article for more than two hours.and finally answered correct and it is a complex topic and i learned some thing new about encrption.

Can any body send entire scripts to implement the cell level encrption.

Malleswarareddy
I.T.Analyst
MCITP(70-451)

Shanalise Hall of Fame Points: 3188 More actions · Answer 2

Hi,

You can make this your starting point

http://www.sqlservers.net/p145498-sql-server-optimization-and-the-performance.cfm

http://msdn.microsoft.com/en-us/library/cc278098.aspx#_Toc189384682

CavyPrincess Hall of Fame Points: 3336 More actions · Answer 3

Great question - still got it wrong, but learned a lot in doing so...

Cindy

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

Although my initial thought was the correct answer, I spent some time reading about a subject I don't know all that well. I went with my original thought, and learned something. Thanks.

Ken SSCoach Points: 17191 More actions · Answer 5

This article, while not from MSDN, gets right to the answer and provides a good starting point.

http://www.darkreading.com/blog/archives/2009/11/cell_level_encr.html?print=true

Trey Staker SSCarpal Tunnel Points: 4796 More actions · Answer 6

Thanks for the question. I knew the answer but didn't feel comfortable with it because this isn't an area where I've had experience. I Marked down what my answer would be then read up on it then answered the question and got it right with my original answer. I learned a lot.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

Dan Guzman - Not the MVP Hall of Fame Points: 3757 More actions · Answer 7

Perhaps I just got lucky, but it seemed that two of the answers were actually advantages, leaving only one as a possible disadvantage.

UMG Developer SSChampion Points: 13482 More actions · Answer 8

I agree only one of the choices seemed to be a disadvantage, which made me wonder if I was missing something.

OCTom SSChampion Points: 11785 More actions · Answer 9

Thanks for the question. It got me interested in this just at the time when I'm starting a project where I may have to use cell encryption. Very timely. Nice starting point. 🙂

brdudley SSCrazy Points: 2320 More actions · Answer 10

My first reading of the third option -- Useful in a targeted security environment -- made me think of a potential disadvantage.

Targeted, in the answers, was referring to selecting which columns required encryption and which do not.

It got me thinking, that if columns with a limited domain are encrypted, that might actually provide an attack vector.

Useful question...

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ziangij SSCrazy Eights Points: 8066 More actions · Answer 12

ziangij

SSCrazy Eights

Points: 8066

June 16, 2010 at 10:52 pm

#1181356

thanks 🙂

forsqlserver SSCoach Points: 18902 More actions · Answer 13

forsqlserver

SSCoach

Points: 18902

May 31, 2011 at 1:48 am

#1331828

Thanks...

Thanks