I found that over time I had a vast number of custom fields set throughout my posts and pages, put there by plugins which are no longer used. In order to remove these unwanted custom fields, you need to edit each post and click on the delete option for each field no longer required, then save the post.
Microsoft SQL Server 2000 provides a method for obtaining meta data using information schema views. Continue reading
Databases can be compromised if they are open to SQL Injection Attack. Stripping invalid characters from form inputs will reduce this risk.
If you have a form on your site that interacts with a database (e.g. a username/password login form), you should secure the form by adding an additional stage between submission and the database look-up. One way to do this is to check for valid content. Continue reading
This article illustrates how you can easily connect to and manipulate SQL databases using ActiveX Data Objects (ADO) with Active Server Pages (ASP)
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.
Here’s a handy query for finding duplicates in a table. Continue reading
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.