You Know What Grinds My Gears? – Database Design Edition

thatjeffsmith Database Stuff, SQL Developer 0 Comments

I think one of the dirty secrets in the software business is how LITTLE feedback we get from our end-users. You know they are out there though, gritting their teeth, cursing the day someone trusted you with a keyboard and mouse. Some of this software is very expensive to boot, so one would expect these users would be very vocal …

Click AND Type your Queries with the Integrated Query Builder

thatjeffsmith SQL Developer 23 Comments

I was perusing the SQL Developer Feature Requests Exchange and was not surprised to see this – a request to have the Query Builder disabled. My favorite (and most predictable) comment among the voters for this request is something along the lines of ‘feature totally useless for us professionals’ Let’s explore that for a second. First of all, I’m not …

Day 1: Give me a keep-alive button!

thatjeffsmith SQL Developer 24 Comments

In case you’re curious, I’m calling yesterday ‘Day 0’ as it was spent doing trivial things like getting email setup. Today I feel like was closer to a real day of work. I spent a few hours this afternoon going over some request from the users. One stuck out pretty prominently – ‘Keep-alive functionality’ The basic gist is at some …

Day 0: In the beginning…

thatjeffsmith General 4 Comments

…there were email and VPN accounts. Had my first conference call, complete with desktop sharing. Direct deposit and tax forms are out of the way. Everyone (I think) is remote, so instant messaging is one of the preferred communication methods. Looks like we’ll have a chance to meet in person for a team meeting outside of London in a few …

My New Gig

thatjeffsmith General 5 Comments

The good folks at Oracle, namely @krisrice, approached me this past Summer with an offer I found myself unable to refuse. The short version would be something like, ‘Hey, come join our SQL Developer team.’ So next week, I will start the next chapter of my professional life as the Product Manager for Oracle’s primary database development tool. This is …

Oracle: Move Table to new Schema and Tablespace

thatjeffsmith Database Stuff 5 Comments

A Toad user posed this question today: Is there a way to move a (marked) TABLE mytable123 from Tablespace AAA and Schema BBB to another Tablespace USERS and Schema MYSCH? Let’s tackle the 2nd and easiest part first! Moving a table or partition to a new tablespace is pretty straightforward: ALTER TABLE table_name MOVE TABLESPACE tablespace_name; The ALTER TABLE MOVE …

What’s Your Favorite IDE for PL/SQL Programming?

thatjeffsmith Database Stuff 10 Comments

I stumbled upon an interesting discussion in the ODTUG group on LinkedIn this weekend. A vendor is doing some research I suppose and wanted to know who enjoyed using what IDE and why. Here’s the original question: In your opinion which is the best IDE for PL/SQL programming and why? e.g. PL/SQL Developer, Toad, Oracle SQL Developer. To participate in …