Must Have Scripts

thatjeffsmith General, Personal Tech 5 Comments

My former boss, and current friend, bought an Android phone for himself and his wife last week and asked me for a list of my must-have apps. I’ll list them here for the morbidly curious, but that got me thinking – what are my must-have scripts for managing my Oracle database? I know we’re supposed to use they ‘tool’ things, …

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, …

My goto Oracle Resources

thatjeffsmith Database Stuff 6 Comments

Someone suggested I document where, who, and what I use to get things done in my day-to-day dealings with all things Oracle RDBMS. Since I am very open to suggestion, here it is: Official Stuff Unofficial Stuff Twitter Folks Updated Dec 14, 2014 Oracle Docs Official Link Oracle’s official online documentation. I generally just ‘Google’ the term I’m interested in …

Oracle Open World Brain Dump

thatjeffsmith Expired 0 Comments

So this was my 3rd Oracle Open World, and not much has changed in terms of my experience as a ‘booth boy’ in the Vendor Exhibition Hall. However a few things definitely got my attention. I will need to re-evaluate how I treat the opportunity to attend this conference going forward. I should get registered as a blogger I should …

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 …

Password Expiration and Profiles

thatjeffsmith Database Stuff 1 Comment

Don’t you just love managing your 3,247 accounts and passwords in cyberspace? Imagine being a DBA who manages several hundred databases and requires a password for each of those. And of course said passwords expire after X days, right? Password rules, which cover things like limit of failed login attempts password lifetime reuse max password expiration grace time are defined …