Changes @ APEX Evangelists

I haven’t blogged for a while and it’s mainly due to the fact that I just haven’t had time (yeah yeah…I know that’s a weak excuse).

However there have also been quite a few changes going on at APEX Evangelists, firstly a while back we moved into some nice new offices.

APEX Evangelists Office

APEX Evangelists Offices

(I did try and take a picture on a sunny day, but hey this *is* England we’re talking about).

We have also taken on an Intern for a years placement, Paul will be working exclusively on Application Express (although we’ll be doing our best to give him a good grounding in the Oracle Database, jQuery and all the other things that we (AE) work with on a day-to-day basis). Is Paul perhaps the first Intern to be taken on specifically to do APEX work?

One thing I’ve already learned is that there is no better way to make sure you understand something than trying to explain it to someone else. We’re definitely looking forward to the year ahead with Paul (and hopefully he’s going to enjoy it too).

Paul - exploring the mysteries of jQuery

Paul exploring the mysteries of jQuery and PL/SQL

Thirdly, we have some interesting things in the pipeline for this year, we can’t say too much at the moment, but it should be an interesting year for APEX Evangelists hopefully.

Application Express Training - Leuven, Belgium

Application Express Training - Leuven, Belgium

Oh and finally, APEX Evangelists have just announced our next European Training Day event (to be held in Leuven, Belgium on 26th-28th October). You can find out more information here.

APEX 4.0 Presentation Video

The folks at ODTUG have just published the APEX 4.0 Presentation video presented at ODTUG 2009 by Mike Hichwa and other members of the Oracle team.

I was there at the time and all I can say it you have to see it to see some of the very cool features that will be coming in 4.0.

You can see the video here (the full link is http://www.odtug.com/apex/f?p=500:235:0::::P235_NEWS_ID:2240).

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!

ODTUG Kaleidoscope 2009 – Last Chance for Early Bird Registration

ODTUG Kaleidoscope 2009

ODTUG Kaleidoscope 2009

The discounted early bird registation for the upcoming ODTUG Kaleidoscope 2009 conference ends on the 2nd June, so you really need to get your skates on if you want to save $200 (USD) on the conference registration costs.

The conference this year looks to be outstanding from an Application Express point of view (with over 50 sessions purely on APEX), let alone all the other great presentations that are planned.

I’m doing a couple of presentations there (“Dispelling Myths about Application Express” & “Increasing Scalability with Application Express” as well as a panel session and anything else I can get roped into – often  the ad-hoc activities are just as much fun, if not moreso, than the planned activities).

So, if you’re going..make sure to book before June 2nd or you’ll kick yourself for missing out on a free $200 saving, if you’re not going…you really should!

Heading out to Collaborate 09

Collaborate 09Just a few more hours and then I’m heading out to Collaborate 09. In a break with tradition I’m actually flying out a bit later than usual and flying back a bit earlier (pressure of work and all that!), but I’m looking forward to it immensely.

If you’re looking for information about APEX sessions at Collaborate, Dimitri posted a list of the sessions and David Peake also made a nice (APEX of course) application where you can use an Interactive Report to view the sessions.

In terms of my own involvement at the conference, I am -

  • APEX ‘Ask The Experts’ Panel – Tuesday 13:30 – 14:30
  • Book Signing for Pro Oracle Application Express – Tuesday 14:30 (at the bookstore)
  • Presenting “Dispelling Myths about Oracle Application Express” – Wednesday 15:15 – 16:15

I’ll also be catching a lot of the other APEX sessions as well as lots of the non-APEX ones (I also like to go to at least 2 sessions that are not even remotely related to what I’m doing, just to check out the areas that I wouldn’t normally be exposed to).

So, if you see me at Collaborate (I’m usually the one wandering around lost trying to find the right room that I needed to be in 10 minutes ago), then please say hello, conferences are great places to catch up with old friends but also to make new ones.

Right…better start packing!

Charting the rise of Application Express

A recent post by Dimitri on whether APEX is still worth looking at (read the article to see the context!), and in particular the comment by David Peake

For some proof points look at the number of APEX sessions at Oracle Openworld 2008 = 38

reminded me that I still had an old post sitting in my drafts folder regarding the numbers of sessions related (directly or indirectly) to Oracle Application Express at the conference I’ve attended in the last couple of years, so I’ve dusted off the post (this one now!).

So since a picture is worth a thousand words, here’s the chart -

APEX Presentations Totals

Note: I have just included the Collaborate, ODTUG, OpenWorld and UKOUG events as those were the ones I attended. There were many other events during those periods where there were Application Express topics being presented. Also note that there are no released figures for OpenWorld 09 and UKOUG 09 yet.

There are a few different ways to interpret these figures, firstly cynics might say, “ahh but look how the number at Collaborate 09 is less than 07″, or “look how the number at UKOUG 08 was less than 07″, well remember that the APEX abstracts are competing with lots of other abstracts to make the final cut into the accepted presentations.

Looking at 2008, it was a huge increase (not far off double) the number presentations that were given in 2007.

Currently in 2009, even with just the ODTUG and Collaborate figures to go off, we have around as many as there were in 2007 and almost half as many as there were last year (and remember we still have the OpenWorld and UKOUG figures to add to that).

So…in my opinion, yes Application Express is definitely growing, it’s certainly a good time to be involved with it.

UPDATE: I created a small APEX application on top of the data behind that chart, so you can see the session details, break by presenter etc.

You can access the application here, if you are aware of any omissions, errors or additional conferences that should be included drop me a mail/comment and I’ll try and update it.

Oracle Application Express Stimulus – Win a free training course

As we all know, the economy is making doomy, gloomy reading these days.

So, in the spirit of doing our own little ‘stimulus package’, we have decided to give a free place on our upcoming Application Express Training course to the person who can give us the best reason why they deserve the place.

There are very few rules, only -

  1. Your reason must be 50 words or less.
  2. You must be able to attend the course (so please don’t apply if there is no chance of you attending).
  3. Our decision is final and will be based purely on the one that makes us laugh the most.
  4. The winning entry (and any other notable ones) will be displayed on our site/blogs so please try and keep it clean!

It’s not often you get something useful for nothing these days (errr except APEX and SQLDeveloper of course), so we’re looking forward to seeing some good entries.

Email your submissions to training@apex-evangelists.com with a subject line of ‘Free Place Submission’ (or click here to have it auto-filled for you). Don’t post your submission as a comment (we need it via email please).

Signs you might travel too much

Flying Last year I did a lot of travelling, sure…not as much as some people probably did, however it was still a heck of a lot of travelling (at last reckoning around 50 or so flights).

This year is shaping up to be similar to last year (perhaps even more travelling!), so here’s my thoughts on some signs you might be travelling too much (in no particular order other than how they sprang to mind):

  • You always know where your passport is at any point in time (seriously, when I didn’t travel that much I would always have that mild panic of “where’s my passport?”…not any more.
  • You recognise many of the people at the immigration desk in another country.
  • You can recognise exactly what the flight meal is just by the smell of it, even the desserts.
  • You always carry spare laptop batteries for your flight, even if you plan to sit in a seat with power…because odds are that it won’t be working the day you really need it.
  • You’ve had your luggage lost…(you were expecting that one right?)…but here’s the kicker, you’ve had your luggage lost and you’re actually not that worried about it, because hey…these things happen when you travel alot, worrying and shouting about it won’t make it turn up any faster.
  • You realise that the only essentials you really need, are a passport, boarding card and a credit card. Everything else can be bought, borrowed or improvised (see above).
  • You have been stopped by the LAPD for turning right on a red-light…at a ‘Do Not Turn Right On A Red Light’ sign…with the LAPD car right behind you.
  • You start turning right on red lights, even though you’re back in your home country which has no such law (see above).
  • You have (at least once) got into your own car and thought “Where has the steering wheel gone?”…only to realise you’re back in your home country where they put things on the *correct* side ;)
  • You got that free airline upgrade. Upgrades are harder and harder to get these days, but the sheer number of times you travel means that the odds are that one day you’re going to have something really horrible happen during your flight that the airline has to compensate you for…in that sense upgrades are the peak before the next trough.
  • You have more than 3 types of currency in your wallet at any point in time.
  • You use your iPhone to mark the GPS location of your car in the airport carpark.
  • You have, at least once, returned back to your country to a different airport than you left your car at (see…now the GPS location one doesn’t seem so silly does it?).

I could go on, but I won’t….additions to the list very welcome though!