I’ve just received an email telling me that Apress is having a “Happy Cyber Monday”. Translated into English this means that for today only they’re selling every eBook at $15.00 each. If you were planning to get an eBook version of Oracle Core, today might be the best day to do it. Here’s a link to the specific page on the Apress site. I’ve repeated this link in the picture of the book at the top-right of this page.
If you want the paper copy, it started shipping from Amazon in the US quite recently but isn’t yet shipping from Amazon UK.
Just a quick reminder if you’re in Northern Europe: I’ll be in Denmark on 13th December presenting a new tutorial event Beating the Oracle Optimizer.
If you’ve been on my “Designing Optimal SQL” course, this is a follow up that takes you in the realm of designing “strange” SQL for those occasions when the Optimizer isnt going to do well enough with “normal” SQL.
Don’t forget the UKOUG annual conference in Birmingham from 5th – 7th Dec.
Anyone attending the full event can register for a free seat at the Oak Table Day on Sunday 4th Dec. where I’ll be presenting a geeky session about Redo.
The agenda for the annual conference has just been published. (You have to pick at least one stream before clicking on “Agenda” button).
This year features an “Oak Table Sunday” that is free to conference attendees but has a very limited audience size, so you have to register for a place. I’ll be giving a presentation titled “Redo” (The Oak Table presentations will be repeated later in the week for larger audiences, and I’m repeating this one first thing Wednesday morning.
Tuesday afternoon I’ll be giving a presentation with the title: “Beating the Oracle Optimizer” and on Wednesday afternoon I’ll be chairing a round-table on Cost Based Optimisation.
Particular highlights for me this year: Connor McDonald is coming over from Australia to do a couple of presentations (including one on Optimizer Stats while I’m doing the round table), and Iggy Fernandez is coming over from California to do a couple of presentations on intelligent use of indexing.
I really don’t have time to do any blogging or do anything on the forums at present – book in progress, too many people people needing a couple of days here and there, and Open World with its ACE Director thing is about to take a big chunk out of my life – but I thought I’d just mention that 2012 is beginning to shape up.
I’ve submitted three abstracts for RMOUG – it’s a three-day event, and a progression of one presentation per day seems appropriate (if they get accepted):
Single Table Access Paths — with two indexes on a table I can find 89 different options for the most efficient way of querying the data (depending on the index definitions, column definitions, and query, or course). (The optimizer can do about 23 of them)
How to Optimise a two-table join — there’s a surprising number of things to think about
Beating the Oracle Optimizer — general principles for, and examples of, manual query transformations (i.e. rewrites) that the optimizer can’t do automatically.
I’m planning to bring my wife to Denver a few days ahead of the event this time – and we’ll be bringing some walking boots. Somehow I don’t think the mountains will be as easy as the Lake District, for walking though.
I’ve added Hotsos 2012 (the 10th anniversary) to my schedule. March 4th – 8th. I’ll be hosting the Training Day at the end of the symposium, and I’ve submitted an abstract for my slide-free presentation on “The Beginner’s Guide to becoming an Expert”.
It’s official – I’m writing a new book for Apress.
The working title is: “A look at the internal mechanics of the important bits of Oracle for people who aren’t planning to become rocket scientists but who do want to do a little more than just push buttons in OEM”. (I’m still working on making the title a little more catchy.)
Target publication time – some time in November.
While I was in Turkey a few weeks ago presenting the keynote at the Turkish Oracle User Group conference, I had a chat with one of the sponsors of the event who has a product that “does Web 2.0 for pl/sql specialists” – in other words, doesn’t require you to learn all the other transient technologies that get stuck around the edges of Oracle to produce application.
I said I’d take a look at it – but development really isn’t my area, which means I’m not really in a position to judge what they’ve done; so I thought I’d give it a brief mention here, in case anyone was looking for a way to move to Web 2.0 without throwing away their current Oracle investment. (I don’t usually consider doing adverts – but the idea was interesting, and I see that it’s got support from Paul Dorsey and that’s a reasonable recommendation in its own right.)
I’ve just bumped this to the top of the stack because the Call for Papers for the UKOUG annual conference (RDBMS and EBS themes, 5th – 7th Dec) is getting close to the closing date of 5th June. If you’re interested in presenting, you need to go to this link pretty soon.
I’ve just popped this posting to the top of the stack as the best place to mention a change in my “public appearances” listing. There’s still a link in the “Special Links” list near the top of the right hand column, but this now points to a page on the blog rather than to a page on my old web site. This should make it a little easier to keep it up to date in a more timely fashion.
I will be speaking at a couple of events for the UKOUG, over the next few months. The next is in Scotland on 8th June (details not yet published) – for a joint effort with Tony Hasler to repeat the debate I had with him at the UKOUG annual conference: “Does Oracle Ignore Hints”.
Moving out from the local user group – I will be heading to Zurich, Switzerland for May 24th/25th, to take part in the Trivadis Performance Days 2011 where I’ll be doing my presentation on “How to Write Efficient SQL”, and ending the event with my interactive “Beginner’s Guide to becoming an Expert” and one other presentation. And in other events in mainland Europe, I’ve got a date with DOAG (the German Oracle user group) for an event on 14th/15th September to present the two-day “Optimising Oracle – Foundations” course.
In the Oracle University “Celebrity Seminar” series I’ll be in in Prague (Czech Republic) in May and Munich (Germany) in June. For more details see the “Public Appearances” link near the top of the right-hand panel.
If you need to persuade anyone that they should give you the time and money to attend one of my full-day events you might want to show them these blog reports of three of my one-day tutorials: