1
2011
Site Updates
I’m in the middle of testing a couple of new WordPress themes at the moment, so please bear with me. I wanted to go with something a litte more readable. I really like the ElegantGrunge theme by Michael Tyson, which I have been using since the site went live, but I think it’s time to simplify a little more. We’ll see which new theme wins out ultimately. I’ll take suggestions…
31
2011
Calculating Age Based on Date of Birth in SQLite
On a recent project I needed to calculate a person’s age relative to the system date based on an input value of a birth date. In this particular scenario I needed to do so using the SQLite engine, and the specific requirement was to calculate age using the following logic: If person is younger than 1 month, present the age in days (e.g. 30 days) If person is 1 month or older but younger than [...]
24
2010
How to Make a Long Running Query
Recently a colleague sent me a quick instant message asking if I knew of any way in Oracle to make a query run long enough to test a “cancel query” function he was writing in Java. He had tried several queries that usually produced the results he was looking for, however there wasn’t enough data in his test environment to reproduce the wait time he needed. I thought about it for a minute and then [...]
25
2010
“The Scott Wilder Show goes national!”
Finally! It looks like my favorite radio talk show host is coming back to the airwaves in a larger capacity than before. All I can say is it’s about time. Read more about it here.
9
2010
Exploring Mac World – Update
Well, it’s been well over a month since I discussed embarking on my Mac endeavor (http://www.mattoldham.com/2009/12/getting-ready-to-explore-the-world-of-mac/). I cannot believe it is almost the middle of February, and today is the first day I have not been onsite at my client since before the holidays began. That also means today is really the first chance I’ve had to come back around and give you an upadte on where I’m at with validating the viability of the [...]
2
2010
Handy Desktop Background For App Developers
Ever been working with an application window and wondered if it would fit into a particular screen resolution? I have. I am continually testing our apps in different browser windows and periodically I check to make sure we are still within the maximum screen resolution as indicated in our requirements documents. I had been using this nifty little Firefox plugin which did the job for me. But, I don’t have that capability yet (that I [...]
22
2009
Getting ready to explore the world of Mac
Never thought I would be saying that in my lifetime, but here I am nevertheless. I have been running Linux on my laptop for almost a year now, and I have thoroughly enjoyed the flexibility it has offered me. I weaned myself off of my old Windows XP VM a while back and have been living my daily development life exclusively in X Windows (Gnome). My Gnome environment has exposed me to GnomeEdit, Compiz, CairoDock, [...]
11
2009
OLAP Friendly OLTP Design
I thought I would post a whitepaper I wrote earlier this year under the auspices of my employer, M. Miller & Associates. This whitepaper is basically a summary of things I have observed over the course of my career in IT, particularly in regard to database design. I can assure you that I eat my own dog food when it comes to the things I discuss. I’m in the trenches every day putting into practice [...]
30
2009
You Are the Gold Ring…
This is something I periodically tell my daughters, although they are not really old enough to fully appreciate the meaning. The point I make is based on the following passage of scripture: A woman who is beautiful but lacks discretion is like a gold ring in a pig’s snout. –Proverbs 11:22 (NLT) And I make this point because as I read this passage growing up I for some reason always related the “beauty” to the [...]
18
2009
Jailbroken: The Story of My iPhone 3G
I finally decided to go for it. Sure, I could end up bricking my phone and have to shell out $300 for a replacement. And sure, it’s my only cell phone…tied to my main phone number…which also happens to be printed on my business cards…the sole means of my family contacting me once I leave the house in the morning. Who was I kidding – I could not afford to fail.
Apache Ant
Bible
Business Intelligence
Data Warehousing
Linux
Mac OS/X
openSuse
Oracle
Oyen
SQL
SQLite
Subversion
UEX
VMWare Data Warehousing (2)
Development (8)
Eternal (3)
iPhone (1)
Uncategorized (1)
Wasabi-SIG (1)
WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

An article by