Eric M Russell (4/29/2016)

---

The following will build a dictionary table containing SSN and SHA2_512 hash for every possible social security number (~ 1 billion rows). I hacked this together in...

Iwas Bornready (4/28/2016)

---

David.Poole (4/28/2016)

---

The ability to remove an individual's records is a legal requirement in the UK. It is intended for data that is inaccurate or false.

We also have the...

I think there are plenty of people that use TDD well. I think it makes sense, but it's hard as a discipline. I suspect many people think David was too...

stakes (4/29/2016)

---

I recently did stress testing our new hardware, before we migrated our databases to it. I used Ditributed Replay to do the stress test (i.e. replay the workload from...

I like it. I'll open a ticket.

You certainly could take the SSN from the app and do a hash/map in another table. Use a salt, protect the tables with limited access and that can work. I...

It's still available in SQL 2016. My guess is it's not ever going away

The reason the procedure only exists in Enterprise is compression is an Enterprise only feature.

Looking forward to seeing you all at Nexus/Bits.

Notification icon where?

Eric M Russell (4/28/2016)

---

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

First, please format your code (spacing and use the code=sql shortcut to the left of the editor). Second, we don't have your environment, so if there are tables needed to...

typo corrected.

A couple things. First, use the code=plain code on the side to format your tables and use spacing so we can read things. Like this:

EmpID Date FieldName...

As Lynn noted, your query is incorrect. There are two different sets of columns in each SELECT. One column in the first, multiple ones in the second.

The format for substring...

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 number/taxid, this is the case....