Dec 15, 2007 @ 1:15 pm.
Using the MD5 and SHA1 hash functions
If you’re using a login script on your site you probably store usernames and passwords in a database for authenticating the login.
For security reasons, you should never store these as plain text but should encrypt them with a one-way hash function such as md5 or sha1.
Read the rest of this entry
Tags: ASP, Security, SQL | Categories: Software Development | 0 Comments
Dec 12, 2007 @ 2:27 pm.
Here’s a handy query for finding duplicates in a table. Read the rest of this entry
Tags: SQL | Categories: Software Development | 0 Comments
Dec 7, 2007 @ 4:31 pm.
I’m not always working with SQL Server, and sometimes keep forgetting which SQL join to use, this article keeps me refreshed and hopefully give you an overview of the three main join types: Inner, Left and Right.
Read the rest of this entry
Tags: SQL | Categories: Software Development | 0 Comments