In most MySQL GUI’s that offer the ability to alter the table definitions of a schema, if you add a…

I recently had to create a site for an education facility, and they turn on Compatibility mode for all their networked…

I wrote a site for my local pub and it involved a restaurant booking section. The user could select a…

I have had to create a few PHP sites that connect to a MSSQL server. Not being down with setting…

If you ever wanted to prevent certain IP addresses from accessing your site, you can easily acheive this in the…

This is a “script” to convert your latin1 myisam database to utf8 innodb Dump the database mysqldump -u root -p database_to_convert > db.latin1.sql…

Quite often I have to convert datasets from one source to another target. Sometimes I can only export them as…

There is a very useful command in Linux, called grep. It is a utility for searching plain text files using…

Say you are using Google Web fonts for some CSS. Well, if you don’t include the correct bits you may…

Sometimes sending mail to a dev account is all well and good, but if the mail server you are sending…