Thursday, September 27, 2012

What to do with your Freebies from Oracle Open World

With 50,000+ people attending Oracle Open World (and associated other conferences) between 30th September and 4th October, and with over 400 exhibitors, there should lots of freebies available.

What do you do with all of these things like pens, pencils, notebooks, memory sticks, t-shirts, pen pots, stress balls, etc. ?

Do many of these items get given away as presents, gives to your colleagues, or at some point end up in the refuge collect, land fill or recycle centre ?

Why not give these items to primary and secondary schools in Africa?

image

Over the past couple of years I have been collecting some of these kind of things to send out to schools in Africa. What I try to do is to wait until I have enough items that can kit out students in a class with pens, pencils and notepads for a year.

There is no corporate sponsorship of this project that is called Tech Gear for the 3rd World.  I just ask for people to send me their spare items or old corporate items (due to rebranding etc.).  I look after identifying what schools to send the items too, packaging of the items and I pay for the shipping of the parcels to the schools.

So after visiting Oracle Open World you have suitcase full of stuff, or if you are an exhibitor and you have items left over, why not send them to Tech Gear for the 3rd World.

Click here for more details and postal details.

Wednesday, September 26, 2012

Oracle Magazine Collection

Are you going to Oracle Open World & have old Oracle Magazines.
I’ve been working in the Oracle World for 20 years now. During that time I’ve been collecting the print editions of Oracle Magazine since 1992.
I have all the Oracle Magazines from 1998, but I’m missing some of the editions prior to 1998.


Can you help me complete my collection ?   (I promise that you wont find them on ebay!!)

What I would really like to do is to have a print copy of every Oracle Magazine going back to the very first one in June 1987. To see the electronic version of the first edition, which was very kindly made available by Cary Milsap, click here.
image

So in the run up to Oracle Open World could you have a look to see if you have any of my missing editions or any of the early editions. I can collect them off you are Oracle Open World.

If you have a look through my blog you will see that I’ve been posting a review of some of the early editions of Oracle Magazine. Ideally at some time in the future I will have a review of all the Oracle Magazines available.

Saturday, September 22, 2012

Oracle Open World Schedule

Oracle Open World is fast approaching. Over the past couple of weeks I have been using the schedule builder tool to work out what sessions I would like to attend.  Unfortunately there are LOTS of sessions I would love to attend but I haven’t worked out a way to be in 10 places at the same time.

When attending a conference I try to achieve a number of things. These are find out about new topics/features, benchmark my knowledge of existing topics, try some of the hands-on labs, try something new and do something completely different. This will be my challenge at Oracle Open World.

image

There are a number of other people from Ireland who will be attending OOW, and there are some plans to have an Ireland social event. Plus there is lots of meetings/catch-ups planned too with people I know from the virtual Oracle world.

There will be some people from AIB who will be presenting at OOW. Their presentation will be on the Tuesday morning 10:15-11:00.  I’ll be there.

Other social things that are on include the Oracle ACE dinner, the Oracle Music festival, with Kings of Leon playing support to Pearl Jam on the Wednesdays night.

It is going to be a busy week, an enjoyable week, a week of learning new things and finding out lots of what the 12c database will be like. 

Will I get time to go to everything ?  The simple answer is NO.  So I will just have to try to get to another Oracle Open World soon.

Wednesday, September 12, 2012

Review Oracle Magazine–Sept/Oct 2006- 20th Anniversary

The Sept/Oct Oracle Magazine from 2006 was the 20th Anniversary edition.

The main articles were focused on Security, Unstructured Data, Using Ajax, Partitioning (this is a regular topic), Application Express and there was the regular articles from Tom Kyte and Steven Feuerstein

image

 

There was only one article focusing o the 20th Anniversary of Oracle Magazine, written by Jeff Spicer and gave a brief overview of how the magazine has progress and the main technologies. The highlights included

  • Oracle Magazine emerged in 1987 from the original newsletter that was issued every quarter
  • In the 1990's the magazine grew in size and was primarily focus on how Oracle customer were using the products
  • By the late 1990 the magazine evolved into have a number of distinct sections focusing on the wide range of products that Oracle now owned
  • Then into the 2000 Oracle magazine stated to introduce more user focused features. With this we get more user group news and features on community members.
  • Tom Kyte joins with a regular column in 2000
  • Back in 2006 Oracle magazine has a readership of nearly 1 million.

In the November/December 2011 Oracle Magazine, Tom Haunert give an brief history of Oracle Magazine, over its 25 year history

To view the cover page and the table of contents click on the image at the top of this post or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions and a PDF for the very first Oracle Magazine from June 1987.

Saturday, September 8, 2012

Scott/Tiger in Oracle

Almost everyone starting out with Oracle have come across the schema SCOTT.

So who was SCOTT?

Bruce Scott was employee number 4 at Oracle back in the 1970s and was part of the team responsible for architecting and writing version 1, 2 and 3 of the Oracle Database.

So he set up the first schema for testing and demo-ing how to use SQL in the Oracle Database. The EMP and DEPT tables and the data that we still see in this schema is still based on the original data that he created.

How did he come up with the TIGER password ?  Tiger was the name of his cat!!!

Sten Vesterli of Scott/Tiger Explaining about Usability (and other) Superheroes

Sten Vesterli of Scott/Tiger Group

Bruce co-founded Gupta Technology (now known as Centura Software) in 1984 with Umang Gupta, and later became CEO and founder of PointBase, Inc.

Wednesday, September 5, 2012

Review of Oracle Magazine- January/February 1997

The January/February 1997 edition of Oracle Magazine was the “10th Anniversary Special Edition”. They were celebrating a little bit early as it should be the June/July edition, as the first Oracle Magazine was published in June 1987.  This edition says that Oracle Magazine started in 1986. So there is a little bit of confusion on when Oracle Magazine started. Some people say Oracle Magazine started before the first edition, as there was a regular-ish newsletter for a couple of years before the June 1987 edition.

The January/February 1997 edition had its contents divided into two main sections. The first of these sections was on the typical articles you would find in Oracle Magazine and the other section was for a collection of articles for the 10th anniversary.

image

The articles for the main part of January/February 1997 edition of Oracle Magazine included:

  • Oracle Spatial Data option was released providing a full-function geometry server.
  • Developer/2000 for the Web gets released
  • Discoverer 3.0 beta is released
  • Objects in High Gear looks at object technology and how it is and can be used in our data and applications, with example applications for education and health.

The 10th Anniversary section articles included:

  • Oracle Magazine editor, Leslie Steere, had an article called The Cure for Information Overload. In this article she listed 10 questions that can help you determine if you are from Information Overload Syndrome.
    1. Has your job become unsatisfying?
    2. Do you find yourself unable to make important decisions?
    3. Have you lost the ability to prioritize?
    4. Has your work performance been less than stellar lately?
    5. Have you caught yourself snapping at coworkers?
    6. Do you feel unreasonably anxious at business meetings?
    7. Have your sleep patterns changed for the worse?
    8. Are you drinking and eating more compulsively than usual?
    9. Are you experiencing problems in your important personal relationships?
    10. Are you physically ill more often than usual?
  • Follow the Leaders article had short interviews with some of Oracle’s top executives on the past and future of Oracle. The executive included, Dirk Kabcenell, EVP Product Division Administration, Phil Wilson, SVP Human Resources, Ian Thacker, SVP Oracle UK, Thomas Theodores, VP Corporate Legal, randy Baker, SVP, Worldwide Customer Support and Nimish Mehta, SVP Industry Management.
  • Ken Jacob, VP of Product Strategy talks about about his time at Oracle and his vision for the next 10 years. “What are we going to do over the next few years in online transaction processing? How are we going to incorporate object-based technologies, asynchronous messaging, and multitier architectures. What are we going to do to enhance the data-warehouse features? There’ll be some internal architecture restructuring of the system, but the basic foundation is strong. There is nothing that we need to catch up on, so our task is to just keep moving ahead into the future.
  • Sohaib Abbasi, SVP of Oracle Tools Division, who has been working in Oracle since 1982 and lead up the SQL*Forms development in 1984. He talks about the Oracle Development Tool.
  • An early customer for Oracle was the particle research centre CERN. This article charts how CERN has used Oracle from version 2 to Oracle 8.
  • Kevin Loney gives 10 scripts that every DBA needs for managing the database.

To view the cover page and the table of contents click on the image at the top of this post or click here.

In my next blog post I will look at the 20th and 25th Anniversary editions of Oracle Magazine.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions and a PDF for the very first Oracle Magazine from June 1987.

Saturday, September 1, 2012

Events for Oracle Users in Ireland–Winter 2012

Over the next couple months there are a number of events happening for Oracle Users in Ireland.

There are a number of OUG Ireland SIG meetings happening. These are:

11th September : Joint SIG meeting of the BI & EPM SIG and the first Tech SIG meeting

12th September : HCM SIG meeting

20th November : BI & EPM SIG.  This will be a full day SIG event.

3rd-5th December : The annual UKOUG Conference in Birmingham. There is usually a good attendance from Ireland at this conference. On the Monday night there will be the focus pubs. Join me at the Ireland table.

Oracle and the Oracle User Group have arrange to have Tom Kyte come to Dublin on 19th September, to give a number of presentations. Check out this link for more details and how to register.

Oracle will be having an Oracle Technology Day in Dublin on 15th November in the Croke Park Conference Centre. They will be talking about Cloud Computing, Mobile Computing, Social Media and Big Data. They are also hoping to include some of the updates and product news that will be announced at Oracle Open World in early October. You will need to register for this event.

Summary of Dates & Events to add to your diary.

11th September : OUG Ireland BI & EPM and Tech SIG meeting

12th September : OUG Ireland HCM SIG meeting

19th September : Tom Kyte in Dublin

15th November : Oracle Technology Day

3rd- 5th December : UKOUG Conference in Birmingham.

Saturday, August 25, 2012

Peer-to-Peer in Oracle Magazine–September/October 2013

The latest edition of Oracle Magazine is now available online and can be viewed at http://www.oracle.com/technetwork/oramag/magazine/current-issue/index.html

I’ve been included in the Peer-to-Peer feature, along with two other Oracle ACEs. The Peer-to-Peer feature is a regular part in Oracle Magazine and typically gives a short profile of 3 Oracle ACEs or ACE Directors.

September/October Cover

If you have subscribed to get a printed copy, we should be getting a copy of it in the post over the next couple of weeks.

Tuesday, August 21, 2012

Review of Oracle Magazine–November/December 1996

The headline articles for the November/December 1996 edition of Oracle Magazine were focused on VLDB with articles on scaling to petabyte sized databases, the latest and best hardware to use, what new exist features in 7.3 and 8 for VLDBS, what new tools exists to assist administrators with the scale of the database.

image

Other articles included:

  • There was an article on what is a Operational Data Store (ODS) and it also highlights how and ODS is different to a Data Warehouse. Despite this article and many, many more like it in the wider press since 1996 there is still lots of confusion out in the IT world on what whey are and how they are different.
  • A new Database Design tool has been added to the Oracle Designer/2000 suit. This new tool was supposed to be lightweight, etc.  Oracle Data Modeler is a much better tool.
  • Oracle outlines their roadmap for making their database and certain tools available on Windows NT.
  • IKEA has implemented and Oracle 7 DB on multiple platforms, including IBM MVS, Digital VMS, IBM AIX and other UNIX variants. Other tools used by IKEA included Developer/2000 and Designer/2000.
  • How to manage multi-table joins to reduce the amount of processing. The article looked at how to use Nested Loops, Merger Joins and Hash Joins. The article also suggests that in some cases maybe you need to consider redesigning your tables/data model.
  • Motorola implements multi-lingual Oracle Human Resources 10SC in 14 offices in 8 countries. There was a lot of use of NLS functionality in the database including NLS_LANG, NLS_NUMERIC_CHARACTERS, NLS_SORT and the translated _TL tables in Oracle Applications.
  • We have the first Y2K related article, an much of the discussion focused on how Oracle Stores Dates in the database. Most of the fuss focused on if you captured and stored a two digit year or a four digit year. Oracle provided the RR format mask to minimise the amount of recoding that needed to be done to Many applications around the world.
  • There was 6 pages of job adverts from Oracle Australia, Database Consultants Inc, ACT1, BPA, Profound Consulting, RHI Consulting, Ernst & Young, TransTech, Wilco, Information Alliance, Exor Technologies, The Consulting Team, InTimeSystems, May&Speh, Price Waterhouse. I wonder where some of those companies are now.

To view the cover page and the table of contents click on the image at the top of this post or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions and a PDF for the very first Oracle Magazine from June 1987.

Tuesday, August 14, 2012

Tom Kyte Seminar–Dublin 19th September 2012

Calling all Oracle users in Ireland.

Tom Kyte will be back in Dublin on Wednesday 19th September for a half day seminar.

image

The event is is being organised by the Ireland OUG and Oracle.

It will be in the Gibson Hotel beside the Point village.

This is a FREE event for everyone, so share the news and get to see Tom Kyte present for a 4 hours.

As they say spaces are limited, so book your place today. I have.

To register for the event – click here.

Friday, August 3, 2012

Call for paper for Oracle Scene-Winter 2012 Edition

The call for papers is now open for Oracle technical papers for publication in the UKOUG Oracle Scene magazine.

The submission date for completed papers is 24th August. 

To get more information of paper guidelines and submission details go to,

http://www.ukoug.org/what-we-offer/oracle-scene/

The Winter edition will be published online and in print format around the end of October. This will be in time for the EPM & Hyperion, JDE and UKOUG 2012 conferences. So this is a chance to get your message across to these communities.

Did you get a presentation accepted for the UKOUG annual conference or were you disappointed ?  Maybe you could consider writing a paper based on your presentation and submit it for consideration.

How about advertising in Oracle Scene. Over the past couple of editions we have had a significant increase in readership, with readership from countries around the world.

Over the past few years Oracle Scene has moved from being a regional User Group magazine to having a readership in 30+ countries around the world.

Why am I writing this post ?  I’m a deputy editor of Oracle Scene Smile