Arvixe Hosting: Database Backups

Having just switched from ASP to Linux hosting at Arvixe, I needed to setup daily backups of my databases. ASP hosting made this very easy; however, the Linux move required me to dust the cobwebs off my shell scripting skills.

I had three MySQL databases to backup daily. I wanted to archive the backups and place the archive in a specific directory. I also wanted to delete any backup archives older than 7 days. The solution was quite easy starting with the backup script:

Continue reading “Arvixe Hosting: Database Backups”

Facebook SDK for Android

Wow, the quality of SDKs have really gone downhill. I just spent two days trying to get past the poor documentation and non-compiling sample applications of the Facebook for Android SDK. I also had a similar experience with the Android SDK from Kinvey. The difference is Kinvey wants you to succeed and has awesome developer support whereas Facebook really doesn’t care what they release. Facebook has become way too big, too fast to be able to release any sort of quality work. I look forward to good things from Kinvey.

Just a rant… there, I feel better.

Site Facelift

I don’t have much to report other than if you are reading this, you are seeing a number a changes I have made to the site since the last time you were here:

  • New header
  • Image slider
  • Static home page
  • Theme color tweaks

I hope it makes discovering what we do easier. The blog is still intact with all the technical articles you expect. I am not sure if I am satisfied with the changes, so leave any comments and/or suggestions you might have here. Thank you for your feedback!

Introduction to Hadoop

Here is a short presentation that I gave as a guest speaker to a group of graduate level statisticians at the University of Utah. It is a very high level view of what Hadoop is, who is using it, when you should use it, and bit on how it works.

SQL Server – Index Defragmentation Stored Procedure

I don’t remember who wrote the original code for this stored procedure; however, I found it useful enough I wanted to share it with my readers.

The following script does a fantastic job of allowing the user to defragment table indexes with a high degree of control. I have tested the procedure with SQL Server 2008 and 2008 R2. Your mileage on other versions of SQL Server may vary.

Continue reading “SQL Server – Index Defragmentation Stored Procedure”

WordPress Plugin Form Submissions

Development of my first WordPress plugin brought me to a basic piece of functionality, handling form submissions. I knew that I could submit a form via AJAX; however, that would not work for forms that allow file uploads without adding extra code and page markup. Being new to the world of WordPress, I went on a search for how this should be done. The search ended with a possible solution found on WordPress Answers.

Continue reading “WordPress Plugin Form Submissions”

Installing Cloudera CDH4 on Ubuntu 12.04 LTS

Presented are some short notes for installing Cloudera CDH4 on Ubuntu 12.04 LTS running as a guest OS on Oracle’s VirtualBox. For those unfamiliar with Cloudera and CDH, CDH is Cloudera’s 100% open source Hadoop distribution. What is documented here is not a complete tutorial, but rather pieces of information to be used in conjunction with the product’s documentation. Use these tips to make the installation of Cloudera on Ubuntu easier.

Continue reading “Installing Cloudera CDH4 on Ubuntu 12.04 LTS”