Viewing 15 posts - 2,656 through 2,670 (of 6,041 total)
I'm assuming what you want to do is roll your own Change Data Capture, where you are capturing only those columns that changed within a row, and then insert into...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 28, 2016 at 9:27 am
If all the organization's databases and backups are encrypted, then a far more realistic scenario (although still improbable) is that an insider figures out a way to somehow copy and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 28, 2016 at 8:59 am
Steve Jones - SSC Editor (4/27/2016)
Losing the salt would be the equivalent of losing the symmetric key, if the domain is known. In the case of a social security...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 28, 2016 at 7:43 am
The "Right To Be Forgotten" is an interesting legal concept. Not only is it technically and logistically impossible, but apparently it doesn't apply equally to all individuals (ie: regular folks...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 28, 2016 at 6:52 am
GilaMonster (4/27/2016)
Eric M Russell (4/27/2016)
at this point you might as well use symmetric key encryption instead of hashing.
I disagree. If you're using symmetric encryption and the key is compromised,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 27, 2016 at 1:41 pm
Steve Jones - SSC Editor (4/27/2016)
Eric M Russell (4/26/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 27, 2016 at 1:11 pm
Post the SHA2_256 hash of any validly formatted plaintext SSN (ie: any code conforming to 999-99-9999), and I'll reply back with the un-hashed plaintext SSN number.
For example use this:
PRINT HASHBYTES('SHA2_512',...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 26, 2016 at 3:17 pm
First of all, I am against the use of SSN's as UID;
Aside from the debate of how to secure the SSN, it's also important to understand that SSN is often...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 26, 2016 at 1:26 pm
A SSN hashed using MD5 can be un-hashed by simply joining it on a dictionary table prepopulated with a billion sequential SSN codes that were hashed using the same MD5...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 26, 2016 at 12:20 pm
Phil Factor (4/26/2016)
The rise of rhyming slang was in response to the increasing enforcement of London's censorship laws. Originally, it was only used by a small number of cockney gangs...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 26, 2016 at 7:54 am
SQL_Surfer (4/24/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 25, 2016 at 3:55 pm
I don't get the title: "A nice whistle and flute".
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 25, 2016 at 3:11 pm
davidlester.home (4/25/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 25, 2016 at 9:17 am
.. So I went through the whole exercise of performance tuning and such, and could not get it to improve ..
So, have you compared the two execution plan: the plan...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 25, 2016 at 7:57 am
... It really doesn't enhance the relationship with the client to burst into giggles, or to exclaim 'What idiot wrote this stuff?' 'Silence', he told me, 'is usually the best...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 25, 2016 at 7:52 am
Viewing 15 posts - 2,656 through 2,670 (of 6,041 total)