Access of Evil

thatjeffsmith Database Stuff 3 Comments

A play on words – the Axis of Evil, three countries that foster or promote terrorism. This is not a history lesson or political discussion, go here for that. So what is the Access of Evil? I would propose that the following practices conspire to bring down any well-ordered collection of data: MS Access MS Excel SELECT *. So do …

Excel and Oracle? Yes, but Should You?

thatjeffsmith Database Stuff 8 Comments

Microsoft has a lot to be proud of. They helped pioneer desktop computing. They have very successful platforms like SQL Server and Sharepoint. They are even working on a new mobile phone that doesn’t support copy and paste. But, I would argue their most popular product in use today is Excel. Mayhaps ‘popular’ isn’t the best word here. Most reasonable …