Cheat Sheets
SQL Server
56 comments
Microsoft's SQL Server is a powerful database server that integrates well with other Microsoft technologies like ASP and .NET, and includes some of the best database management tools available. This A4 reference lists the various functions available in SQL Server, and demonstrates the creation of stored procedures, triggers and functions.
HTML
HTML is the language of the web. It is the semantic support on which websites depend. This A4 reference lists the various tags available to the web designer, as well as a selection of useful character entities, attributes and events.
Regular Expressions (V1)
Regular Expressions are very powerful, and many people find their unusual syntax hard to get to grips with. This A4 reference serves as a guide to regular expression patterns and options.
Microformats
Microformats allow us to add more information to our documents on the web, embedding semantic data in web pages that can then be parsed and used in other applications. This reference sheet contains an overview of the most often used microformats.
Ruby on Rails
A quick reference guide for Ruby on Rails, containing the default directory structure, predefined variables, methods, reserved words and regular expression syntax.
ASP / VBScript
A quick reference guide for ASP / VBScript, containing functions, collections, regular expression syntax and other useful bits of information.
JavaScript
A quick reference guide for JavaScript, listing methods and functions, and including a guide to regular expressions and the XMLHttpRequest object.
MySQL
A quick reference guide for MySQL, including functions (both in MySQL and PHP), data types, and sample queries. Available in PDF and PNG formats.
mod_rewrite (V1)
A quick reference guide for mod_rewrite, including server variables, flags and regular expression syntax. Also includes examples of commonly-used rules.
CSS (V1)
A quick reference guide for CSS, listing selector syntax, properties, units and other useful bits of information.
PHP (V1)
I'm fed up with having to visit php.net to look things up. This A4 cheat sheet is designed to sit by your desk and make your life easier.
Articles
Writing Secure PHP, Part 4
The fourth part of the Writing Secure PHP series, covering cross-site scripting, cross-site request forgery and character encoding security issues.
Writing Secure PHP, Part 3
The third part of the Writing Secure PHP series, covering weak passwords, clients and more advanced topics.
Writing Secure PHP, Part 2
Learn how to improve your security a little further with the second part of this PHP tutorial.
Password Protect a Directory with .htaccess
A tutorial explaining how to retrict access to a directory on a web server using .htaccess.
Writing Secure PHP, Part 1
Learn how to avoid some of the most common mistakes in PHP, and so make your sites more secure.
Caching output in PHP
High-traffic sites can often benefit from caching of pages, to save processing of the same data over and over again. This caching tutorial runs through the basics of file caching in PHP.
Blog Posts
Why You Should Always Salt Your Hashes
Hashes are used almost everywhere on the web, behind the scenes, to protect your passwords. Learn why it's important to always add salt to your hashes.
Click here to read this post »
16 December 2009 | 16 comments | security, database, passwords, programming, webdev
What Makes a Great Developer?
What makes a truly great developer? Some might say a positive attitude. Some might say a high-sugar, high-caffeine, high-bacon diet. Some might say an absence of sunlight and as many monitors as a desk can support. I say pessimism and laziness are high up the list.
Click here to read this post »
17 April 2008 | 68 comments | philosophy, programming, software, development, career, tips, job, developer, blog
