Nerd It Up!

Stupid Copy & Paste Tricks

The Late Show with David Letterman used to have a bit called, ‘Stupid Pet Tricks.’ I quit watching because I prefer his Scottish and funnier future-replacement, Craig Ferguson. But I will take advantage of some Google-Fu to drive some traffic to ye olde blog (can you tell I’m in the UK this week?)

So most folks [...]

SQL Developer: Tastes Great, Less Filling?

The ‘Holy Grail’ of software tools is the environment where things are made easy, but not at the expense of usability or simplicity. You use a tool because it makes something ‘easier’, but some software products are anything but.

SQL Developer is fairly scaled down. You have a few toolbars, several menus, and 2 driving windows [...]

Quick Tip - Comparing Explain Plans with SQL Developer

I love it when a plan come's together!

SQL optimization and tuning is fun for a lot of folks. For others it’s a affirmation that the database is ‘magic.’ I fall somewhere in the middle. No matter where you fall on that spectrum however, it’s pretty safe to assume that at some point you will [...]

Oracle Date Datatype Should be DateTime DataType

Want to confuse an Oracle database n00b? Ask them if their query takes into account the time component of a date when they code their WHERE blahDate between … AND … logic.

But sir, my dates do not have a time associated with it. You must be confusing this with TimeStamp. See, that has the word [...]

Your Guide to New Features in Oracle SQL Developer version 3.1

Did you miss the big news yesterday? We released the next version of Oracle SQL Developer, 3.1. SQL Developer is the IDE for the Oracle database. Millions have downloaded it, more have used it. We try to do one to two releases a year and look to support those folks doing development, management, modeling, migrations, [...]

SQL Developer Quick Tip: Pretty It Up a Bit

No, not your code. I want you to take a quick look at the visual preferences for SQL Developer. In an earlier post I pontificated on the top 10 options to tweak before starting to use SQL Developer. Now once you have the tool operating the way you want, I think it’s time to make [...]

SQL Developer Trick: Double-Click to Go Full Screen

No matter how many monitors you have or how large they may be, sometimes you just need more real-estate for your coding. You can have a whole lot going on in your IDE, and SQL Developer is no exception. Of course you can always close or hide the offending panels and windows, but then it’s [...]

SQL Developer Data Modeler Navigator Can Get You There I Bet!

Just so you don’t think I’m crazy, you should know that I’m a father to a wonderful two year old daughter. She’s awesome, except when she wants to act her age. When we get desperate, we turn on her favorite show. I have seen about 200 different episodes of Dora the Explorer. My Spanish is [...]

Getting Your Mind Out of the Gutter and Your Line Numbers In

Hopefully your code is cleaner than what runs through this every morning

I’m not sure if I can help with the mind part, but I can definitely add some perspective on the line numbers. Quickly, let’s define just what the ‘gutter’ is in the world of programming and database GUIs. I found a good definition [...]

Average Run Time for Oracle Jobs

Oracle SQL Developer Job Run Log

Starting with 10g and the introduction of DMBS_SCHEDULER, Oracle database began tracking and storing the execution duration of a job. By default this information is kept around for 30 days. You can of course change the logging level and the retention period for the job runs – read the [...]

Related Posts Plugin for WordPress, Blogger...