June 25, 2010 at 8:18 am
WayneS (6/24/2010)
GabyYYZ (6/24/2010)
CirquedeSQLeil (6/23/2010)
WayneS (6/23/2010)
Talk to your credit-card processor. I believe that they have some numbers that can be used for this type of thing - they pass the verification process but are completely fake and do nothing.Of course, this would mean that all records would have the same value for this column.
Having dealt with a few CC Processors, each one has provided test Card numbers that would pass validation. You should check with your processor and confirm as Wayne said.
Thanks Wayne and Cirque, will do so. The trick is I need 3+ million unique ID's but hope they have that many. I also found the algorithm and some TSQL do add a check digit to a 15 digit card number, making it a "valid" 16 digit number. I'm talking to the QA folks to see if there's a way for me to test if they pass.
Gaby, since this is in a test environment, wouldn't it be okay to have them be the same? If it's to test the process, does it matter if everyone has the same card?
Unfortunately not...it's a lookup table storing prior CC numbers for faster order processing in the future. The way it works is:
1. Order comes in
2. CC is encrypted
3. If Encrypted value matches encrypted value in lookup table, it is a prior existing card, else insert the card for future lookups.
Each order has a credit card ID that is the key that corresponds to the credit card and only the CC ID is stored for an order, not the CC.
This way, we don't have to compare unencrypted values at all.
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
June 25, 2010 at 8:27 am
What kind of encryption are you using? Most of the usual encryption algorithms are nondeterministic, so encrypting the same value twice gives different outputs.
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
June 25, 2010 at 8:43 am
Steve Jones - Editor (6/24/2010)
WayneS (6/24/2010)
Maybe we ought to send Steve out skiing more often?Yes, yes, yes, though I'm afraid that will have to wait for a few months. I'll be looking to
disappearstep away in late October.
Maybe you can visit Paul down in NZ, I hear they ski there this time of year.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
June 25, 2010 at 9:00 am
Hi Gail,
It's AES-256, CBC mode, with an IV. It's all done by an external appliance that holds the keys.
All inserts/updates to the encrypted column make a call via .dll to the device and encrypted value returned. All control/encryption/decryption is handled at the device. It actually works pretty well.
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
June 25, 2010 at 9:17 am
Trey Staker (6/25/2010)
Maybe you can visit Paul down in NZ, I hear they ski there this time of year.
The South Island resorts have good skiing most of the year 🙂
Mount Ruapehu, on the North Island, is good from June to October - though it is an active volcano (last eruption 2007).
http://www.fourcorners.co.nz/new-zealand/skiing/
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 25, 2010 at 9:19 am
PASS. No interest in flying 64 hours to ski for a couple days.
Send me pix, I'm happy to wait for Oct here. I went Oct 25 last year.
June 25, 2010 at 9:25 am
Steve Jones - Editor (6/25/2010)
PASS. No interest in flying 64 hours to ski for a couple days.
So come down my way. Only 20 hours of so of flying and the Eastern Cape mountains are lovely this time of year.
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
June 25, 2010 at 9:28 am
Ha! 20 hours?!?!?! Not for me. I'm not thrilled with anything over 4 hours.
Plus aren't there all sorts of extra footsie ball fans clogging the country now?
June 25, 2010 at 9:31 am
Steve Jones - Editor (6/25/2010)
Plus aren't there all sorts of extra footsie ball fans clogging the country now?
Unfortunately yes. They'll be gone in just over 2 weeks.
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
June 25, 2010 at 9:35 am
And here I have vacation scheduled for 2 weeks. Unfortunately heading to Vegas
June 25, 2010 at 9:38 am
Steve Jones - Editor (6/25/2010)
PASS. No interest in flying 64 hours to ski for a couple days.Send me pix, I'm happy to wait for Oct here. I went Oct 25 last year.
Where is your sense of adventure. If I could afford it, I'd give it a try just to say I did it!
June 25, 2010 at 9:48 am
My sense of adventure is tempered by the desire to enjoy my life in places other than airplanes.
Plus I'm not sure it's worth it to me. I've skiied in Switzerland. Better than CO, but not better enough to make me want to go back.
June 25, 2010 at 11:04 am
Lynn Pettis (6/25/2010)
Steve Jones - Editor (6/25/2010)
PASS. No interest in flying 64 hours to ski for a couple days.Send me pix, I'm happy to wait for Oct here. I went Oct 25 last year.
Where is your sense of adventure. If I could afford it, I'd give it a try just to say I did it!
Adventure, Excitement...A Jedi craves not these things! -Yoda
(I couldn't resist) 😀
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
June 25, 2010 at 11:07 am
GabyYYZ (6/25/2010)
Lynn Pettis (6/25/2010)
Steve Jones - Editor (6/25/2010)
PASS. No interest in flying 64 hours to ski for a couple days.Send me pix, I'm happy to wait for Oct here. I went Oct 25 last year.
Where is your sense of adventure. If I could afford it, I'd give it a try just to say I did it!
Adventure, Excitement...A Jedi craves not these things! -Yoda
(I couldn't resist) 😀
Which is why the Jedi are really flipping boring.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 25, 2010 at 11:14 am
Grant Fritchey (6/25/2010)
GabyYYZ (6/25/2010)
Lynn Pettis (6/25/2010)
Steve Jones - Editor (6/25/2010)
PASS. No interest in flying 64 hours to ski for a couple days.Send me pix, I'm happy to wait for Oct here. I went Oct 25 last year.
Where is your sense of adventure. If I could afford it, I'd give it a try just to say I did it!
Adventure, Excitement...A Jedi craves not these things! -Yoda
(I couldn't resist) 😀
Which is why the Jedi are really flipping boring.
They don't need to crave those things because they come naturally to a jedi.
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
Viewing 15 posts - 16,006 through 16,020 (of 66,688 total)
You must be logged in to reply to this topic. Login to reply