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 …

Trailing or Leading Commas?

thatjeffsmith Database Stuff 16 Comments

For me, it’s leading. If I have a code or syntax problem, I find it easier to see the line missing the comma if I can look at the first char position. Of course you may say that’s crazy, and any reasonable programmer would demand trailing commas. I’m guessing your IDE offers formatting options that allow you to choose what …

Date Night

thatjeffsmith Toad® Stuff (Retired) 1 Comment

For most couples, ‘date night’ is something to look forward to, but unfortunately does not come around often enough. For others, even the word ‘date’ sends a chill down their spine. It’s not an adverse reaction to their partner, but rather a unpleasant reminder to the daily toil that is working with DATE formatted data in their relational database. Wow, …

SQL Saturday for an Oracle Guy

thatjeffsmith General 4 Comments

I recently had the opportunity to attend a SQL Saturday event, #46 in Raleigh, NC. Techie Training, on a Saturday. Really? Yes, really. And I had some reservations before attending. However the fact that this event was free, minus $10 for breakfast/lunch, and the entire #SQL universe on Twitter has had nothing but good things to say about the event …

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 …

Driving Blind?

thatjeffsmith Database Stuff 1 Comment

I travel quite frequently for my job. Number one on my list of ‘must have things’ on the road is a Navigation device. This used to be my trusty Garmin, but now thanks to my new Android device, I have Google Maps. There have been times and places where I don’t have the device available – either the GPS satellites …

SELECT * FROM Re-Visited

thatjeffsmith Database Stuff 0 Comments

In an earlier post, I discussed the merits and deficiencies around using the * syntax in a SELECT statement. I have been using this topic as a way to bring up lively discussions while doing database tools demos for our SQL and Oracle customers. I must admit I am extremely dismayed by the amount of Senior level folks who do …