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...

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...

Steve Jones - SSC Editor (4/27/2016)

---

splitting hairs.

Losing the salt would be the equivalent of losing the symmetric key, if the domain is known. In the case of a social security...

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...

GilaMonster (4/27/2016)

---

I disagree. If you're using symmetric encryption and the key is compromised,...

Steve Jones - SSC Editor (4/27/2016)

---

Eric M Russell (4/26/2016)

---

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...

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',...

Aside from the debate of how to secure the SSN, it's also important to understand that SSN is often...

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...

Phil Factor (4/26/2016)

---

@eric,

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...

SQL_Surfer (4/24/2016)

---

Anyway, why my non-column store index is not performing well as it should? I'm querying a 5 million row table. I've attached a query plan. Any tips to speed...

I don't get the title: "A nice whistle and flute".

davidlester.home (4/25/2016)

---

While I can give the DDL for this, I don't think that this is a normal issue. I am good myself at performance tuning. It seems to be something...

So, have you compared the two execution plan: the plan...

... 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...