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

But out of the box SQL Server's default settings are tight as far as security is concerned. We don't really need to nail things down so much as avoid bad...

Brent Ozar's popular sp_Blitz is mainly geared toward server configuration and physical modeling best practices, but it also contains some checks for security best practices as well; checking for things...

Also, confirm if there are any login triggers.

Phil Parkin (4/21/2016)

---

j-1064772 (4/21/2016)

---

Having said that, C# includes very efficient dictionary structures that can be used to process data way faster than the SQL Server can, if the network can...

tyranicide

singhamitpal (4/19/2016)

---

I have spoke to some people who claim themselves to be SQL Guru's. Anyways, below is what I found...

1.Very few developers will be able to create a consistent stored...