Database Master Keys

Question

Post reply

Database Master Keys

Steve Jones - SSC Editor

SSC Guru

Points: 737751
More actions
November 12, 2014 at 11:55 pm

#73579

Comments posted to this topic are about the item Database Master Keys
November 13, 2014 at 1:34 am

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

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

ksatpute123 Hall of Fame Points: 3325 More actions · Answer 1

Ah! Read the options in a hurry and ended up selecting the incorrect answer.

Next time I will will count to 10 slowly before answering.

Nice question.

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 2

Nice question, thanks.

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

TomThomson SSC Guru Points: 104773 More actions · Answer 3

Nice clear question.

The proportion of wrong anwers suggests that security still isn't an important part of the job for most DBAs, which is a pity.

Tom

sestell1 SSChampion Points: 10230 More actions · Answer 4

Stewart "Arturius" Campbell (11/13/2014)
Good question, thanks Steve
Found myself looking for a catch, but went with my knowledge anyway.

Yea, I spent a bit of time trying to figure out the catch as well. I don't use encryption much, so I was sure I was missing something.

Glad to see my limited understanding of database encryption seems to be correct.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 5

Dana Medley

SSCertifiable

Points: 6764

November 13, 2014 at 7:56 am

#1758242

Great question Steve, thanks!

Everything is awesome!

Kick6Tiger SSCrazy Points: 2380 More actions · Answer 6

TomThomson (11/13/2014)
Nice clear question.
The proportion of wrong anwers suggests that security still isn't an important part of the job for most DBAs, which is a pity.

Until it's required by law or upper management, adding another layer of security is usually viewed as a waste of resources. I think with the rash of data breaches in the news recently, you will see more of a focus on this subject. I know my company is about force us to de-identify all data not in production...which is going to make my job of analyzing production issues a nightmare.

Aigle de Guerre!

malleswarareddy_m SSCertifiable Points: 5847 More actions · Answer 7

Nice question. Confused with first two answers.

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 8

I thought this was a good question and like Tom pointed out, not a lot of people are familiar with them. It does come with some overhead, but it's a pretty powerful approach for column encryption. I usually enjoy questions about encryption, so thanks for it.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Hany Helmy SSChampion Points: 13921 More actions · Answer 9

Definitely lerned somthing new, gr8 question, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 10

Thanks for the question. I can always use help with security.

Database Master Keys

Cookies on SQLServerCentral