What Data Should You Protect?

Question

Post reply

What Data Should You Protect?

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
August 29, 2009 at 9:32 pm

#138516

Comments posted to this topic are about the item What Data Should You Protect?

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

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

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 1

Before I even read the article, I'll say "all of it".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 2

Heh... and now that I've read the article, I'll say again... "All of it". 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Edit: Nevermind. Did like Jeff and commented before reading and read protect as in backup up, not protect as in secure.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

Easy to say all of it, but sometimes you need to make choices, especially with encryption. Doing the whole database can have a detrimental effect on performance.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 5

Steve Jones - Editor (8/30/2009)
Easy to say all of it, but sometimes you need to make choices, especially with encryption. Doing the whole database can have a detrimental effect on performance.

Nope... didn't mean encrypt it all... limit access. BUT... I was mostly referring to personal information... that MUST be protected. To use your example about birthdates... why would any "casual" user need someone's birthdate? The answer is almost always "never".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

GSquared SSC Guru Points: 260824 More actions · Answer 6

The point of the data about birthdate and Zip code isn't that knowing those allows someone to figure out who you are, it's that those data are adequate to operate as a PK for people in most circumstances.

If you really want to see how much is already available about you out there, take a look at http:\\snitch.name. It's pretty darn easy to find out data about someone on there. It's not really paranoia to assume that everything about you is already known.

Privacy is an illusion. The difference between now and 100 years ago is that now it's cheaper and easier to find out someone's facts. That's all.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 7

Hey, I came up first on Snitch! That doesn't happen often. Usually Steve Jones starts with the muscian, golfer, professor or basketball player.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 8

Steve Jones - Editor (8/31/2009)
Hey, I came up first on Snitch! That doesn't happen often. Usually Steve Jones starts with the muscian, golfer, professor or basketball player.

Heh... Celko's picture came up as one of my possible pictures... I'm gonna sue! 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

GSquared SSC Guru Points: 260824 More actions · Answer 9

Steve Jones - Editor (8/31/2009)
Hey, I came up first on Snitch! That doesn't happen often. Usually Steve Jones starts with the muscian, golfer, professor or basketball player.

And here I was, assuming you were this multi-tallented shape-shifter born on different days in different years. 🙂

Internet stalking is only fun till you realize it goes both ways. :w00t:

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

RBarryYoung SSC Guru Points: 143329 More actions · Answer 10

Well they can't freakin' find me. And I'm trying to be found!

Story of my freakin life. Apparently, I am so forgettable that even computers can't remember who the heck I am. I mean c'mon, there's no picture, phone number, anything of me in these things, yet I've got 8000 copies of this information pasted onto this site alone, for Pete's sake!

:angry: #### frickin, frackin stupid frisifrasin ... ####

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 11

Don't worry, Barry, we know who you are!

And I've got your blog in my DBW list, so you'll be showing up soon everywhere!

RBarryYoung SSC Guru Points: 143329 More actions · Answer 12

Well, that's something then. 🙂

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

James Stover Hall of Fame Points: 3393 More actions · Answer 13

C'mon, where are the "Mark of the Beast" comments??

Really, nature has already given us a GUID. It's called DNA. That bit of technology has been around for billions of years. It's just that we have only recently (by comparison) learned to crack the code. I wouldn't doubt that future technology will allow our DNA to function like an RFID tag. A bit of electronica will "ping" our DNA which will uniquely resonate allowing instant identification. "But DNA doesn't work like that". Sure. So anyway, I believe it's inevitable that somewhere in the not-so-distant future, DNA collection will be mandatory at birth and we will all end up in a database somewhere (it could already be happening). So, the 10-digit thingy is really just an interim step towards that inevitability.

I'm thinking...Gattaca meets 1984 🙂

James Stover, McDBA

thelabwiz Old Hand Points: 389 More actions · Answer 14

Many sites that want your birthday are trying to determine if you are old enough to be allowed in (13 and up for kid-related sites, 18 and up for others [merchants, hard gaming, whatever]). I generally give them an easy to remember date that makes me old enough to use the site 😉

5/5/55 or 6/6/66 or 7/7/77 are good candidates and are nowhere near my birthdate.

John