SQL Server Cheat Sheet
20 July 2007 | 68 comments | cheat, cheatsheet, development, mssql, mysql, programming, reference, sql, sql-server, sqlserver, toread
This A4 reference lists the various functions available in Microsoft SQL Server, and demonstrates the creation of stored procedures, triggers and functions.
MySQL Cheat Sheet
24 May 2005 | 143 comments | cheatsheet, webdev, development, mysql, reference, programming, web, php, database, guide, sql, webdesign, howto
A quick reference guide for MySQL, including functions (both in MySQL and PHP), data types, and sample queries. Available in PDF and PNG formats.
PHP and SQL Server are a powerful combination, however sometimes data stored in a text type column is truncated for no apparent reason after 4096 characters. Here's how to fix the problem.
Thoughts from a Brighton geek about web development, marketing, freelancing, entrepreneurship and fatherhood. Probably not in that order.
