Comments on: A puzzling situation… http://michaeljswart.com/?p=445 Database Whisperer Mon, 06 Sep 2010 00:56:15 +0000 hourly 1 http://wordpress.org/?v=3.0.1 By: Adam Machanic : T-SQL Tuesday #002: The Roundup http://michaeljswart.com/?p=445&cpage=1#comment-1991 Adam Machanic : T-SQL Tuesday #002: The Roundup Mon, 08 Feb 2010 19:15:05 +0000 http://michaeljswart.com/?p=445#comment-1991 [...] Swart comes up with a difficult puzzle of his own. Can you reverse-engineer an MD5 hash? You shouldn't, in theory, be able to do so (at least, easily), but here are some hints... And if [...] [...] Swart comes up with a difficult puzzle of his own. Can you reverse-engineer an MD5 hash? You shouldn't, in theory, be able to do so (at least, easily), but here are some hints… And if [...]

]]> By: Michael J. Swart http://michaeljswart.com/?p=445&cpage=1#comment-1785 Michael J. Swart Mon, 18 Jan 2010 21:28:37 +0000 http://michaeljswart.com/?p=445#comment-1785 All right. All right. Congrats Brad. Winner. I'll post a link to a solution within a day. All right. All right.
Congrats Brad. Winner.
I’ll post a link to a solution within a day.

]]> By: Brad Schulz http://michaeljswart.com/?p=445&cpage=1#comment-1784 Brad Schulz Mon, 18 Jan 2010 21:23:02 +0000 http://michaeljswart.com/?p=445#comment-1784 This puzzle is the most frustrating (albeit intriguing) damn thing I've encountered in a while. But I'm determined. I'll solve it even if it takes me an entire decade! --Brad This puzzle is the most frustrating (albeit intriguing) damn thing I’ve encountered in a while.

But I’m determined. I’ll solve it even if it takes me an entire decade!

–Brad

]]> By: Michael J. Swart http://michaeljswart.com/?p=445&cpage=1#comment-1783 Michael J. Swart Mon, 18 Jan 2010 20:33:59 +0000 http://michaeljswart.com/?p=445#comment-1783 Thanks for spreading the word. Thanks for spreading the word.

]]> By: Pinal Dave http://michaeljswart.com/?p=445&cpage=1#comment-1780 Pinal Dave Mon, 18 Jan 2010 10:36:52 +0000 http://michaeljswart.com/?p=445#comment-1780 Hi, I have forwarded your post to my friends and UG members. Let us see! Couple of people called and they said it is really difficult. Kind Regards, Pinal Hi,

I have forwarded your post to my friends and UG members. Let us see!

Couple of people called and they said it is really difficult.

Kind Regards,
Pinal

]]> By: An incentive, and a hint | Michael J. Swart http://michaeljswart.com/?p=445&cpage=1#comment-1777 An incentive, and a hint | Michael J. Swart Mon, 18 Jan 2010 01:26:33 +0000 http://michaeljswart.com/?p=445#comment-1777 [...] last week, I challenged the world to solve a puzzle. This was part of Adam Machanic’s T-SQL Tuesday. And while the entire world does not read my [...] [...] last week, I challenged the world to solve a puzzle. This was part of Adam Machanic’s T-SQL Tuesday. And while the entire world does not read my [...]

]]> By: Michael J. Swart http://michaeljswart.com/?p=445&cpage=1#comment-1753 Michael J. Swart Tue, 12 Jan 2010 17:11:15 +0000 http://michaeljswart.com/?p=445#comment-1753 Sure here you go: <code>--visit: http:/www.michaeljswart.com/???.jpg DECLARE @big BIGINT = ??? SELECT hashbytes('MD5', CONVERT(NVARCHAR ( 15 ) ,@big)) AS big_hashed /* big_hashed 0x61B82A23F75874A88FCC096ED623D563 */</code> Sure here you go:
--visit: http:/www.michaeljswart.com/???.jpg
DECLARE @big BIGINT = ???
SELECT hashbytes('MD5', CONVERT(NVARCHAR ( 15 ) ,@big)) AS big_hashed
/*
big_hashed
0x61B82A23F75874A88FCC096ED623D563
*/

]]> By: Rajib Bahar http://michaeljswart.com/?p=445&cpage=1#comment-1752 Rajib Bahar Tue, 12 Jan 2010 16:05:12 +0000 http://michaeljswart.com/?p=445#comment-1752 do you have text version of the tsql above? If not, I'll type what i see. do you have text version of the tsql above? If not, I’ll type what i see.

]]>