SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite 8

Using Hashbytes in SQL Server 2005 / 2008

In this video John shows you how to use the Hashbytes function in SQL Server 2005 / 2008 is.

Duration:
4 mins 33 secs
Skill Level:
100
Rating:
4.08 out of 5
Publish Date:
February 26, 2009
Using Hashbytes in SQL Server 2005 / 2008 You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of John Magnabosco

References



Comments
SAy Soukamneuth on 5/11/2009
Excellent.

macs68 on 8/13/2009
Muy bueno, aunque también debería haber explicado como desencriptar...

kalpana on 8/13/2009
Nice one. Please show us some more.

Kevin MacKay on 8/13/2009
Great video John. Thanks for the clear overview of Hashbytes.

Louis Iacona on 8/13/2009
Pretty good overview of the mechanics, but you should have highlighted practical applications. Storing / validating 1-way hash passwords? What else?

Richard H. Lang II on 8/13/2009
An example of what this would be used for (e.g. storing passwords) would have been helpful. I spent half the video trying to figure out why you would one way encrypt something. Once I got that figured out and rewatched it, it was excellent. Thanks

Don Weigend on 8/13/2009
Nice explanation of salt and hash

Marc Moshman on 8/13/2009
What was the create table statement used for storing the hashbytes result? Other than that, excellent video.

Rod on 8/13/2009
I wasn't aware of the HASHBYTE() function, so this is good. Thank you!

Travis on 8/13/2009
Not sure of the usefulness of all of this. First, why would you encrypt something one way to start with? Secondly, why would you store the unencrypted value right next to it? Thirdly, what would happen if you lost the plain text or the Salt value?

Travis on 8/13/2009
Ok, now I get it..hashing is not really encrytion. That was confusing me..hashing is one way and you do not need to know the users password to validate it. But when the data is hashed it becomes unrecoverable so this is not a useful strategy for storing credit card numbers. Because credit card numbers need to be encrypted, so that they can be unencrypted before they are used. The terms used in the video were a little confusing...

Travis on 8/13/2009
Don't use this on a table that has a lot of rows in it. Big performance killer...

Mark Hions on 8/13/2009
You never gave a practical use for a one-way algorithm. Also, if all I know is the hashed value, is there a way to determine what algorithm was used?

hades on 8/14/2009
Do

hades on 8/14/2009
Sorry is there an equivalent of SHA256 in SQL server 2008 ?? Also is there an easy way of Encryption

nilanaksha on 8/17/2009
Good presentation and workaround in implementation.

Ron on 9/2/2009
Good topic - subpar presentation.

Edward Zann on 12/29/2009
Thanks, I learned something new today.

aks on 1/2/2010
Good..

Jim on 8/5/2010
And with salting, what is the easiest method to extract hashed data?

Jimmy May on 8/5/2010
Excellent illustrations of HASHBYTES & salting. Thanks for sharing!

SAy Soukamneuth on 8/5/2010
Good!

Jamshid Nouri on 8/5/2010
excellent demo!!!!

Johnny Wild on 8/5/2010
What is the practical use of this??

Desmond Cassidy on 8/6/2010
Dreadfully boring narrator...he should use a script if he is going to eh...hmmm...all the way through it. Content was good though...

Rick Fonner on 8/6/2010
Nicely done, very easy to understand!

Mike Nicholas on 8/6/2010
Yes! That's great. I see where this is a good practice to follow.

Matt on 8/8/2010
Nice video, I've personally never used this but I can see the value in it. Speaker sounded a little new to giving the presentation but he still did a great job. Props on that.

Thomas Kelley on 8/9/2010
Would like some more info on why one-way encryption would be helpful.

Clayton Smith on 8/11/2010
Good video. Came across hashing etc in the .Net membership database, so it is good to see this stuff from another angle.

Daniel McGivney on 8/24/2010
No Create table in script. What field types were used for each field. The encrypted text look binary when type = Varchar. The example look like a hex value? why is that?

rcva2010 on 10/25/2010
excellent video

Nate on 6/28/2011
I now understand this much much better.

zishan qureshi on 1/9/2012
Good to know about encryption. What the video didn't explain is how to de-encrypt?

Kasey Wheeler on 1/9/2012
Good vid.

Max Turavani on 1/9/2012
good demo. thanks.

SH on 1/9/2012
Should state when and why Hashbytes should be used.

Dan on 1/9/2012
For author only: the content was very good, but you need inflection in your voice. Listen to the video - you'll hear what I mean. Thanks!

Muzz on 1/9/2012
I felt that the author overdid it on the zoom somewhat. I also felt that while this was an introduction to hashbytes, there was no effort to explain how this might be useful in your application/DB.

F6D4BEF41F on 1/9/2012
I liked his examples and explanation but would like to know practical uses for this encryption other than for passwords.

Excellent info.

Excellent info.

Hashbytes is not solely about encryption. It's also a more reliable method of generating checksum values because no two unique strings will generate the same hashbytes value whereas that is not guaranteed to be the case with checksum.

Raymond Starkey on 1/10/2012
Super! Short sharp and useful.

Greg Joiner on 1/10/2012
Simple and clean way to demonstrate a funtion. We so wish that ALL commands had a simple video like this to explan what they do, and demonstrate a usage!!

chandrasekhar on 1/11/2012
very good

John Miceli on 1/11/2012
interesting

Antoon on 1/12/2012
This would have been better with a tighter script.

ROKKAM KIRAN KUMAR on 1/17/2012
Very nice concept thank you very much for your demonstration, It really helps....

A4A72D151B on 2/23/2012
still not up to speed with encryption

vikas jain on 5/5/2012
great video i am going to implement that thing in our applicaton



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions