ORACLENERD!

SQLDev Tip and Trick: Drag and Drop to Worksheet

Dragging and dropping tables to the worksheet is a pretty obvious feature – it copies the object names over for you. But did you know you had the option to get more bang for your buck?

Drag and drop preferences

Once you do the drag, you can select what you want copied to the Worksheet. If [...]

They Just Write SQL Statements

There are no dumb queries, only dumb…

“Those people are fine, they JUST write SQL.”

I often hear this in the context of visiting customers and offering to provide training (and yes, software) to their database users. There is a class of people who are deemed unworthy of such productivity tools because they do nothing but [...]

SQL_IDs, Plans, and Baselines, Oh My!

Do you run a 3rd party application that uses Oracle RDBMS under-the-hood? Do you experience performance issues? Frustrated that you do not own the application SQL that is causing the issues? Maybe an upcoming upgrade to 11g might give you some relief.

Somewhere, over the rainbow…lies 11g, unicorns, and databases that tune themselves.

Many of the [...]

Is Your Query Running?

You better run and catch it then!

You know you’re getting old when the new crop of kids don’t get this joke, or even worse, don’t understand what a prank phone call is.

I’m pretty sure that folks still get phone calls from frustrated people who want to know how much time is left before their query [...]

Who Owns Performance in the Database?

Many moons ago, this was a pretty straightforward question. It also had a very easy answer, the DBA owned performance. By that I mean if the database or it’s applications did not perform as expected, it was the DBA who would step in and fix it.

Several years ago this began to change. [...]

Driving Blind?

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 [...]

Related Posts Plugin for WordPress, Blogger...