Database

Databases are my "thing" and entries here discuss my thoughts and experiences with them.

3 random things
Posted : Tuesday July 6th, 2010

As the title implies there is no "theme" to this post it's just a collection of a few thoughts I've had or encountered recently. First to get a bit of housekeeping out o...read more

JDBC Best Practices
Posted : Friday May 15th, 2009

I have had a few posts before relating to some JDBC best practices but I thought I'd list the top five all in one post. These are good ideas for making your JDBC code safe, secu...read more

Don't panic
Posted : Tuesday April 21st, 2009

Since the news broke about Oracle trying to purchase Sun I have seen more than one article or opinion piece about how this is the end of the world. To which I would say, absolut...read more

Well I'm speechless (almost)
Posted : Monday December 15th, 2008

One of my current projects involves migrating data from one legacy format to another proprietary format for a CRM system. Well, migration is really the wrong word for it because...read more

JDBC Connection Errors Checklist
Posted : Wednesday November 5th, 2008

Alright. Mainly because posting the same stuff over and over on forums gets tiring I thought I'd put this list in a blog entry here and maybe link to it from other places. ...read more

Leveraging benchmark calibrations
Posted : Monday September 8th, 2008

When it comes to data it's quite easy to get trapped in a world of buzzword-laden and content-free meaning. And it makes it difficult when you are trying to get a list of requir...read more

Design trickyness
Posted : Tuesday August 19th, 2008

I think one of the hardest things to do in database design is figuring out how best to capture data that is based on numbers derived from formulas. I am working on such ...read more

Garbage in, garbage out
Posted : Monday August 18th, 2008

In the world's first tech-support issue Charles Babbage was asked about the world's first computer ...read more

Closing JDBC resources
Posted : Friday August 15th, 2008

I previously submitted this content to SDN Share, a Sun program to promote best practices, examples etc among developers. However it bears...read more

The hidden costs of bad data
Posted : Wednesday May 28th, 2008

I have been invited to do a little speaking/teaching gig on data integrity and why it's a good thing. It's an interesting topic because aside from the obvious good > bad most pe...read more

XML is not a database
Posted : Thursday May 1st, 2008

If there's a surer sign of portending doom then a person blathering on about an "XML Database" I couldn't tell you what it would be. I don't know how many times I have seen disc...read more