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”
I have been working with Kinvey as the backend for Critters 2.0 for about a month. I was having problems setting a filter on a paged query and getting a total count of results with it.
Continue reading “Kinvey – Simple Aggregates and Paging”
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.
This is a quick and dirty stored procedure that one can use to determine if a column or set of columns is a candidate for a primary key or unique index. The procedure takes a table name and a concatenated list of columns to be checked. Non-char columns must be CAST as VARCHAR.
Continue reading “SQL Server – Determine Column Uniqueness”
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!
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.
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”
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”
My Windows 7 install on my laptop became corrupted and I decided to fix things with a clean install of the OS. Since the Dell restore image on the laptop came will all the original bloatware, I thought it would be a good time to see what all the Windows 8 fuss was about (good and bad).
Continue reading “Windows 8 Professional Upgrade”
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”