When using ASP.NET themes and you specify the global theme in web.config you can run into problems when you want to create a page that does not use the theme. Read More
When using stored procedures with MySQL you may at some point want to get a list of all the stored procedures that exist in your database. Using the MySQL INFORMATION_SCHEMA database and the ROUTINES table we can easily list information about procedures or functions. Read More
When working with an ASP.NET page or control you many want to remove code temporarily or stop some code executing while debugging. This can be achieved easily using the server-side comment opening, <%--, and closing tag, --%>.
It can take a long time to upload images to a website or send an email with lots of images attached. To save time uploading files it is a good idea to resize images first on your computer and then upload or attach the smaller files. Bigger websites like Facebook and Flickr will do this for you on your computer without you really knowing but in other cases you will need to resize the files first yourself. Read More
A WordPress website consists of two main parts:
Backing up just the database will mean you do not have a backup of images and files uploaded which are usually very important to a website. So for a reliable backup of your WordPress website you need to backup the database and files. Read More
Spam is always going to be a problem when running a blog and it seems the spammers have taken a friendlier tack of late. We keep getting lots of flattering comments that are unfortunately too good to be true! Read More
ASP.NET automatically checks for HTML being sent by GET or POST requests as a security precaution and throws the following nasty error if it finds any: Read More
To access MySQL Server over a local Windows network you will need to open up the port that MySQL is using and also grant privileges for the user that will access the database server.
SQL Server hosting is usually expensive so shared hosting is often used to keep costs down. With shared database hosting, and with shared web hosting, security is usually tighter and this leads to some standard functionality not being available. With SQL Server 2008 shared hosting the Back Up task is often disabled.
In this article we cover an alternative way to backup your database using the Generate Scripts and Export Data database tasks. Read More
