Hashing

Question

Post reply

Hashing

Viewing 11 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply

Dave62 SSCertifiable Points: 7459 More actions · Answer 1

Mattrick (1/24/2012)
... that shows why salting your hashes is so important ...

A little bit of pepper doesn't hurt either. :hehe:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Thanks yet again Steve.

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

mtassin SSC-Insane Points: 23099 More actions · Answer 3

paul.knibbs (1/24/2012)
A non-deterministic hash function wouldn't be terribly useful, would it? 😉

That's what I was thinking... I had to harken back to Advanced Concepts in C... at least it was considered advanced concepts in C 14 years ago.... these days this is probably beginners stuff (Hashes and the like)....

Aaah age.... where'd I put my walker?

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

Steve Jones - SSC Editor SSC Guru Points: 734459 More actions · Answer 4

Glad you liked the question. I was working on something else and learned a few things here.

TomThomson SSC Guru Points: 104773 More actions · Answer 5

paul.knibbs (1/24/2012)
A non-deterministic hash function wouldn't be terribly useful, would it? 😉

Why not? I can think of at least one use for one.

In the old days the apprentice engineer was sent to fetch a bucketful of holes, more recently people were asked to design a device driver for the GSD, and today we could assign the task of producing an effective access control system using an indeterminate hash - the ~~victim~~trainee would have exactly the same chance of carrying out this task as anyone did with the traditional spoof tasks.

Tom

BarbW SSCarpal Tunnel Points: 4759 More actions · Answer 6

BarbW

SSCarpal Tunnel

Points: 4759

January 24, 2012 at 9:14 am

#1437756

Nice question, thanks for the points!

Revenant SSC-Forever Points: 42467 More actions · Answer 7

Revenant

SSC-Forever

Points: 42467

January 24, 2012 at 9:26 am

#1437762

An easy one - thanks, Steve!

Paul White SSC Guru Points: 150467 More actions · Answer 8

Good question.

CREATE FUNCTION dbo.Hash_SHA (@data nvarchar(200))

RETURNS TABLE WITH SCHEMABINDING AS RETURN

SELECT HASHBYTES('SHA', @data) AS hash_value

GO

-- Returns 1 (true)

SELECT

OBJECTPROPERTYEX(OBJECT_ID(N'dbo.Hash_SHA', N'IF'), 'IsDeterministic');

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Andre Guerreiro SSCertifiable Points: 7319 More actions · Answer 9

I've never used the HashBytes() function so I learnt something new.

I got it right at first because of logic thinking but the options had me wondering and I had to research a little before answering.

Thank you for this QoTD.

Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 10

Iulian -207023

SSCertifiable

Points: 7639

January 25, 2012 at 6:59 am

#1438214

Thank you for the question

Iulian

Peter Trast SSCarpal Tunnel Points: 4392 More actions · Answer 11

OK, every other QotD has had explanations that were easy (for me) to understand. Since the question asked about the "relationship" between the 2, I assumed none since they were different variables.

Answer C, deterministic and always the same, looked right and I was inclined to pick that since I knew that was true, but what does that have to do with the relationship between the two? Or am I just totally misreading the question?

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems