Monthly Archives: June 2009

My ODTUG adventure begins…with UFO’s on the flight!

After a long long day, I’ve finally arrive in San Francisco. I’m here a couple of days early because I’m going to Oracle HQ (in Redwood Shores) along with many of the other Oracle ACE Directors before we go over to Monterey.

In fact I already have a lovely view of the “Mothership” from my hotel window.

Oracle Headquarters

and speaking of ‘Motherships’, I had an interesting encounter with UFO’s on the flight over here.

No, it wasn’t that sort of UFO, the UFO I’m referring to was –

Uninformed about Features in Oracle”

It came about because when I was doing some work on my laptop, the guy next to me started asking what I was doing. It turned out he was a SQLServer guy (he wasn’t coming over for ODTUG, that’s why I don’t feel too bad telling you what happened next).

He told me that they had evaluated using Oracle in their company but had ruled it out in favour of using SQLServer instead, which is fine…these things happen. However being curious I asked him for what reasons they had ruled out using Oracle. I’m paraphasing what he said, but it’s pretty close to how he actually said it.

Him: “In Oracle there’s no way to automatically increment identifiers, like for primary keys”

At this point I already had my laptop fired up, so I showed him how you can use sequences to achieve that…

Him: “With SQLServer we can precompute aggregate queries so that they run faster, there’s no way to do that in Oracle”

I believe the feature he was talking about is called Indexed Views in SQLServer (I’m not a SQLServer guy, so I could have the terminology wrong. Anyway, I quickly showed him how you can create Materialized Views in Oracle and also use Query Rewrite features so that you don’t even need to modify your original queries to use the new materialized views (I also showed him Global Temporary Tables as he asked that as a side-question).

Him: “Great, but in SQLServer we can not only do queries but we can do real procedural coding too”

At this point, I brought out SQLDeveloper and showed him a few examples of how easy (and powerful PL/SQL) is, his response was “Oh I didn’t know you could do that!”

It was interesting for me, because since I’ve been using Oracle for a long time now, you sometimes forget that some of the really ‘simple’ features and pieces of functionality might not be easily discovered by people who are just given a few days exposure to the tool (seriously he told me they had a week to evaluate Oracle).

Anyway, I’m here now…looking forward to Oracle HQ tomorrow!

p.s. please don’t let this post put you off sitting next to me on a flight, I’m not always ‘talking shop’ πŸ˜‰

What I’ve learned going to conferences

With ODTUG 2009 just around the corner now, I thought I’d do a quick reflection on some of my observations and feelings about the (now many) conferences that I’ve attended in recent years.

I first started going to (Oracle related) conferences a few years back, firstly as an attendee then I took the jump and started presenting (and have immensely enjoyed presenting…even when laptops die, projectors don’t work and demo’s fail dramatically…).

Anyway, here are a few rambled thoughts about attending conferences (from an Oracle conference perspective).

Regimental Planning…or Go With the Flow?

If it’s your first conference, it’s going to probably be a bit overwhelming at first (particularly if it’s a big one like Oracle OpenWorld), however take a deep breath and make sure you check all the daily updates. Priorities change, sessions get cancelled etc, so don’t get too hooked up on trying to meet your original ‘schedule’, sometimes going with the flow is a better approach. My first OpenWorld conference I felt like I’d ran a marathon by the end of the week, because I’d been literally running between East and West Moscone to catch different sessions.

Presentation Nightmares

If it’s your first time as a presenter, expect something to go wrong. Laptops die, projectors sometimes don’t work, I’ve even seen ‘clickers’ seem to get possessed by demons. However remember, the audience is there to see you succeed, we want you to do a good job. Anyone who has presented before knows that horrible feeling when you go to run a demo and the machine just hangs (or blue-screens), don’t get too chewed up about it…try and ad-hoc for a couple of minutes and you’ll be surprised how often taking a mental step-back can stop you panicking into a worse mistake (I once saw someone almost do a full DB recovery during a session because something hadn’t worked).

Don’t be Shy!

It can be very overwhelming when everyone else seems to already know each other and nobody knows you. But do make an effort to introduce yourself to people (how else will they ever know who you are?). At ODTUG I’m looking forward to meeting lots of ‘old friends’, but they’re only ‘old friends’ because we’ve previously taken the time to get to know each other!

This also extends to introducing yourself to some of the more ‘famous’ Oracle types (you know who they are), remember it’s a rare opportunity to actually get to speak to some of those people who wrote the books sitting in your office, or whose blog you read daily etc. I remember a few years ago I was chatting to Jonathan Lewis about something and almost as an aside mentioned something about a problem I’d been having (some very obscure issue with pipelined functions and the CBO) and he mentioned something which gave me a ‘lightbulb moment’, as soon as I got back from the conference I fixed an issue that had been causing problems in production for weeks.

Remember, we’re all at that conference because we share a love/passion/interest for something (even if we might disagree about certain aspects of it!).

Early Breakfasts and Early Nights

A lot of the Oracle conferences are in the US and when they’re on the West coast it means one thing…a lot of very jet-lagged Europeans (and antipodeans etc). I’ve lost count of the number of times I’ve woken up, bright eyed and ready for the day ahead only toΒ  look at the clock and seen that it’s 3am. It can be quite funny to play the “Where in the world is my hotel room neighbour” from, based on what time their shower goes on in the morning.

This of course has a side effect, if you happen to be talking to someone and they yawn during the conversation, don’t be offended, it’s probably not personal! A lot of people have probably travelled quite far to attend the conference and it takes some of us a while to figure out what day it is, let alone what the time is.

Plan some extra time for sight-seeing

If you’re not on a tight schedule, try and fit in an extra day or two to at least see some of the local sights. Admittedly this can be a difficult one to swing by your boss (or whoever else is footing the bill for your trip). However I always take the view that it seems silly to travel all that way and either sit inside a conference centre, a hotel room or a bar all day and never step out into the sunlight.

I remember one of the most memorable times I’ve had at a conference was when Carl Backstrom took me around San Francisco and gave a great guided tour (including some great bars and food).

Pack light (during the day at least)

Sure, that 17 inch laptop looks great on your desk, but let me assure you…you’ll soon get tired of lugging it around the Moscone Centre for 8 hours a day all week long. Remember also that at most conferences they’ll be giving you ‘goodies’ to take back with you (often another bag/rucksack).

Behave in a presentation how you would want people to behave in yours

This one always amazes me, I have been in presentations where someone has –

  1. talked pretty much non-stop to the person next to them
  2. repeatedly received calls on their phone (and never switched it onto mute).
  3. actually had a phone conversation which was so ‘urgent’ they couldn’t bear to leave the presentation throughout.
  4. brought in a contender for the world’s loudest bag of crisps (chips for American readers)…seriously….if you need to eat in a presentation try bringing in something quiet!

I just can’t understand why someone would go to a presentation and not actually want to pay attention to it? Why waste your own time (as well as potentially denying that seat to someone who did want to see the presentation?).

Be social (or ‘beer is a great social leveller’)!

Sometimes, actually I’ll go so far as to say almost always, the best parts of the conferences happen in the evenings.

Again, this can be a very difficult one to swing by your boss to convince them to send you to the conference. However socialising with your peers at these events can be a huge benefit to your company, not only in the knowledge and extra insight you might gain, but also from the contacts you’ll build up.

As the title says, beer can be a great social leveller, everyone there is there to enjoy the experience and socialising in the evenings is a part of that experience.

There can be some great technical debates, discussions and disagreements going on in the corner of that bar, you might overhear that single snippet of information that makes all the difference to your project when you get back home, or you might hear something blatently incorrect that you can challenge and correct (it’s just as important to dispel incorrect information as to propagate correct information in my opinion).

Wrap Up

Perhaps one of the most important things, once the conference is over and you get back home is to make use of your new found knowledge. Dig back through your notes (you did take notes right?) and find those 2 or 3 things that made it worthwhile for your boss to send you to the conference, because that is the best way to make sure they agree there and then for you to go again next year.

APEX Meetup at ODTUG 2009

ODTUG Kaleidoscope

ODTUG Kaleidoscope

ODTUG Kaleidoscope is just around the corner now (time flies!), now traditionally Dimitri is very good at organizing the APEX Meetup, however this year unfortunately he can’t make it (for very good reasons).

So, this time after lots of prompting (thanks Monty and Bharat) that I still hadn’t got round to announcing anything, I thought I’d put together this blog post to see how much interest there was in an APEX Meetup in Monterey for those of us going to ODTUG this year.

At the moment I think the way the schedule is, monday (during the ‘Shop, Dine and Play in Monterey’ night) or tuesday night (after the sundown sessions) looks best.

So if you’re going to ODTUG and fancy joining in with an APEX Meetup, drop a comment below and we’ll try and come up with a date/time/venue to suit the majority.

See you there!