While plug-ins and even coding hacks can solve some problems and achieve some tasks, sometimes you don’t have any other choice than to execute SQL commands in phpMyAdmin or directly to the database via SSH. Let’s take a look at 8 useful SQL hacks for WordPress. Each section of this post presents a problem, suggests a solution and provides an explanation to help you understand the solution.

You create the perfect site in Photoshop using the latest trends. Half of your backgrounds contain a nice 50% opacity to simulate depth. The only problem comes from that darn old IE6, and how it decides to display a nasty gray background. You try to search the web for a solution, but there are dozens of choices. How do you know which methods are the best?

WordPress is incredibly versatile, in that although it is primarily known as a blogging platform, it can be used to run a non-blog web site as well. Learn how to convert your wordpress installation in a CMS

Having to upgrade your WordPress install every time a new version is released is necessary, but also very boring. If you have a SSH access to your server, here’s a very quick way to upgrade your WordPress install.

Lets assume that you have created a killer article and you know that it will bring tons of traffic once you digg or stumble it. Now tons of users are on your blog and your blog serving them content using the dynamic PHP scripts files, this will put tremendous load on your sever and even you can face CPU outage. This is more likely to happen when you have a self-hosted blog.

Creating a website is no easy task. WordPress is an easy solution for creating a Blog, but sometimes something a little more, in terms of functionality, is needed. After trying many other platforms, I have found WordPress to be the easiest to use. Because of it’s wide array of themes, great plugin system, and easy to use administration system.

The Links and Link Categories panels or sub menus can be used beyond the intended purpose of just adding links to the sidebar.

This WordPress optimization guide is a collection of useful tips and tutorials on how to speed up your WordPress site.

Many blog owners are scared and hesitated to move their blog to another domain because they fear to lose their visitors, downtime and other complications. I will show you now how to get rid off this fear and how to avoid problems while you moving.

For all you people out there that have better things to do than backups, here’s a process that makes backing up your WordPress site a walk in the park.