Birmingham to Paris

airplane-flying-through-clouds-smallThe day started at a rather civilised time of 06:00, which makes a change. I usually book early flights, forgetting I have to get to the airport a couple of hours early, then regret the decision later. 🙂

The taxi driver didn’t have any receipts, then the lady “managing” the queue at the baggage drop left a lot to be desired. Fortunately the lady on the baggage drop desk was awesome and lifted my mood. The departures screen did its normal thing of saying “Gate opens in 5 mins” for 20+ minutes. I was one of the first on the plane and the flight was fine. A bit of a shaky landing, but that was probably down to the bad weather.

My original plan was to head into the city and have a look at the sites, but after I had got through airport security and made my way to the hotel, time was moving on.

The citizenM hotel is really cool. The rooms are quite small, but the lobby is great. Added to that the wifi is incredible. I uploaded the following video to YouTube in about 5 seconds. 🙂

I grabbed a coffee and headed off into the city. By the time i got there it was an hour before my session, so I parked myself at the AVNET office and wrote this blog post. 🙂

Cheers

Tim…

Paris and Netherlands Trip

Early tomorrow I start a small series of events in Paris and the Netherlands.

Tomorrow I fly to Paris to speak at the Paris Province Oracle Meetup. It will be my first time in Paris, so I’ll try to hit a few of the sites in the city centre if I can. I was originally hoping to fly out the same night as I have an event the following day, but the flights for that didn’t work out. Instead I’m staying in a hotel at the airport. I’ve got an early flight out of Charles de Gualle airport, so I figured I’d take the easy (but boring) approach of staying at the airport.

The next morning I fly to Amsterdam, take a train, then a taxi to the hotel, followed by a taxi to the OTN Cloud Developer Challenge (formerly known as the Hackaton). It started life as an extra day tagged on to an AMIS event by the Oracle ACE Program, like an ACE Briefing, but became a hackathon. I’m not sure if other people are allowed into it, but a few of us have got into teams and we are going to try and develop stuff with Oracle Cloud services. It’s going to be a bit of a magical mystery tour as most of the people in my team are database people and know nothing about the developer and mobile cloud services. If we are able to produce something with them, it will prove they are easy. 🙂

amisThe next two days are the AMIS 25 – BEYOND THE HORIZON event, which is a two day Oracle conference, celebrating 25 years of AMIS. In addition to the sessions, the hackathon teams will still be beavering away with their projects. 🙂

There are three days between this event and the next, so I decided to book myself into a hotel in the centre of Amsterdam for 3 days. It’s about 25+ years since I was in Amsterdam and I can’t remember a thing about the city. Both previous trips were with a gang of university friends and we pretty much slept through the day and partied at night.

I’ve been watching Casey Neistat‘s vlogs for some time and recently he spent a few days in Amsterdam and it looked really nice. Rather than staying in a hostel and seeing the city by night, this time I’m staying in a proper hotel and I’m going to take a look at the city by day. Getting old? Yeah! 🙂

oghThe last event of this mini-tour is the DBA and SQL Celebration by the Dutch Oracle User (OGH). This was actually the first event I was invited to and the rest just kind-of slotted in around it. It’s nice when you can get several events in to a single trip. It just feels more worthwhile somehow. 🙂

If you are coming to any of the events, it’ll be good to see you!

Cheers

Tim…

PS. If you can ask the French Truckers not to affect my travel plans that would be really nice! 🙂

 

Birmingham City University (BCU) Talk #5

bcuI had a day off work today so I could go over to Birmingham City University (BCU) and do a talk to the students.

Today’s session was more about giving them an idea of where databases fit into the big picture as far as data and data processing is concerned. I obviously come at this as a relational database guy, but the presentation also included NoSQL and Hadoop. I hope nobody is naive enough anymore to think relational databases are the correct solution for every use case, so it’s important to be objective about this stuff, rather than to push your own agenda.

Over recent weeks I’ve spent time trawling through material to get a feel for the subject matter, and it’s quite depressing to see the territorial pissing that goes on between all these camps. Each trying to convince you their solution is suitable for use cases where it clearly is not. To be fair, most of this is not coming from the experts themselves, but from the hangers on who can’t cope with the fact their favourite tech might not be perfect. We’ve all been there! 🙂

Over the weekend as I was putting the talk together and Mark Rittman tweeted a link to this article.

I could have kissed him. The article is really even-handed and certainly helped me to put some of what I wanted to say into context.

After the session I was invited to a staff meeting to discuss industry engagement. So that’s the second time today I had to discuss something I know nothing about. 🙂 It was actually really interesting though.

Presenting at conferences and writing on the internet makes you, to some extent, part of the education system. Getting involved in this stuff is quite an eye-opener and makes you think about how you approach things yourself. As I’ve said many times before, I do all this stuff on the internet for me, but if I can make a few adjustments to make what I do more useful and/or accessible to others, that is worth considering.

I got connected with BCU as part of the UKOUG NextGen event in 2014 and the relationship has grown from there. If you are interested in reaching out to some higher education (HE) establishments in the UK, you might want to contact UKOUG. You’re not going to get paid, but I think you will get more out of it personally than put put in! 🙂

Cheers

Tim…

The Oracle ACE Program : My 10 Year Anniversary

ace-directorOn 1st April 2006 I got an email telling me I was an Oracle ACE, so either this is the most drawn out April Fools’ Day joke ever, or I’ve been in the Oracle ACE Program for 10 years. Wow!

The numbers look something like this.

  • Nearly 21 years working with Oracle technology. (August 1995)
  • Nearly 16 years doing my website. (Original name: 03 July 2000 or Current name: 31 August 2001)
  • Nearly 11 years blogging. (15 June 2005)
  • 10 years on the Oracle ACE Program. (01 April 2006)
  • Nearly 10 months making videos. (6 July 2015)

It’s quite scary when you look back at it. 🙂

Cheers

Tim…

PS. A shout out to Thomas LaRock (@SQLRockstar) who got his Microsoft MVP on the same day several years ago. 🙂

Birmingham City University (BCU) Talk #4

bcuOn Thursday last week, the day after UKOUG Tech15, I did my 4th talk at Birmingham City University (BCU).

In my previous visit I did a talk about community and employability to the staff. This time I did a quicker version of the same talk, but to the students. I’ll be going back a few times this year to do technical sessions.

I’ve mentioned before, this type of non-technical presentation is really useful in developing yourself as a presenter. It’s easy to hide behind the technical content. Non-technical presentations have to be more conversational and have more “personality”, for want of a better word. I think that feeds back into your general presentation style.

After the session I always have a chat with Stuart about how it went and what comes next. I get the feeling he’s sometimes worried I’m not getting enough out of it, but that’s far from the truth. I think these kind of sessions are helping me far more than I thought they would.

If you are thinking about getting into the presenting game, I’ve written some public speaking tips. As well as all that, consider throwing in a variety of types of session. If you have any local universities or colleges, get in contact and see if they need some guest speakers.

Cheers

Tim…

AIOUG Sangam15 : It’s a Wrap!

The whole Sangam15 experience is over for me now!

Here are the posts I put out during the trip.

I did my thank you messages in the Day 2 post, but once again I would like to say a big thank you to AIOUG for inviting me, to the Oracle ACE Program for getting me to the event and to all the attendees for making it a great event and for making my Facebook go nuts! 🙂

See you all soon!

Cheers

Tim…

AIOUG Sangam15 : The Journey Home

The night before a morning flight is always a little tricky for me. I lie in bed thinking, “What if I oversleep?”, which winds me up and makes it really hard to relax and drop off. I dozed on and off, but eventually gave up, turned the TV on and watched some films for a few hours.

I grabbed a quick breakfast and got the taxi to the airport. The hotel staff advised leaving at 07:00 for a 10:15 flight. The traffic was very light and the queues for check-in and security very small, so I ended up sitting at the boarding gate two hours before the flight. Better to be early than late!

Hyderabad airport is very clean, modern and has some reclining seats so I was able to chill out for a while. 🙂

The flight from Hyderabad to Dubai took about 3.5 hours. It was relatively uneventful, but rather uncomfortable. I had an aisle seat, but the guy in the centre decided he wanted to sit with his elbows digging into my ribs and his leg pressed against mine. I wouldn’t mind so much if he was a big guy and couldn’t help it, but he was a skinny little thing, so taking all of his space and part of mine seemed unnecessary. 🙂

As soon as we landed in Dubai airport, I grabbed some food and headed off for the boarding gate. Very soon we were on the plane and heading to Birmingham. I enquired about an upgrade, but it was going to cost $2,500 USD, so that wasn’t going to happen. 🙂

I got to experience wifi on the plane for the first time. It’s been “available” on other flights, but I’ve never got it to work before. I got it working on the flight between Dubai and Birmingham. It was ultra-slow, but better than nothing and only $1. 🙂 It made the 7 hour flight go a lot quicker.

I arrived back in Birmingham safe and sound. After a quick taxi ride home I put my washing on, scrubbed the smell of aeroplane off me and went to bed!

Cheers

Tim…

AIOUG Sangam15 : Day 2

My session on Day 2 started at 11:10, where I spoke about running Oracle Databases in the Cloud. This included a quick run through of the Oracle DBaaS offering and AWS RDS for Oracle amongst other things.

The session generated a lot of interest. In fact, I spent the next 5 hours answering questions and taking photos with people. It sounds kind-of crazy, but it was really good fun. As a result, I didn’t get to see any sessions, but as I said yesterday, I feel my purpose here is to connect with people and that is exactly what I did for 5 hours straight. Thanks to everyone that came to speak to me. You made me feel very special and I hope I was able to help you. It never ceases to amaze me what an impact one little website can have!

From there it was on to the closing talks. In addition to the normal closing speeches, there was a motivational talk by DR Rajdeep Manwani. I really enjoyed the talk and judging by the reaction of the crowd, so did everyone else. The talk used several anecdotes and his personal experiences to put across the message that your success or failure is your responsibility. You can blame others when things go wrong (external locus of control) or take personal responsibility (internal locus of control). Ultimately, successful people are those that take personal responsibility and do something about it, rather than blame the world for their failings. I wholeheartedly agree.

After that I spent some time saying my goodbyes, then it was off to get some food and then to bed, ready for my early start for the trip home.

I would like to say a big thank you to the AIOUG for inviting me and to all the AIOUG volunteers that made the event go so well. Thanks also to the Oracle ACE Program for getting me to the event. My special thanks go to all the attendees that made me feel really special for two days.

Tomorrow is the journey home. Fingers crossed for free upgrades to Emirates business class! 🙂

Cheers

Tim…

AIOUG Sangam15 : Day 1

I was up at about 04:00 on Saturday and waiting for breakfast to open at 06:30. Pretty much as soon as I ate something I felt really tired again. That after a day of sleeping… 🙂

I headed on down to the conference and instantly saw a bunch of friendly faces, including lots of people I had met on the OTN Yathra 2014 Tour.

After the keynotes, I got to have a quick chat about User Groups with Mary Lou Dopart from Oracle, then it was off to my first session about database consolidation.

I’m always more nervous about giving introductory/overview sessions than I am about full-on technical sessions. My database consolidation session is a little bit like a history lesson of consolidation, including old and new. The response was very good. I had a lot of people wanting to speak to me afterward, which meant I missed the next two sessions. I don’t mind that, as I feel my purpose here is to interact with as many people as possible. As long as people want to speak to me I’m willing to speak. 🙂

After lunch I had a major energy crash again. Whenever I was speaking to people I felt really up-beat, but as soon as the conversation stopped I felt like I wanted to collapse on the floor and sleep. To play it safe I went back to my room to sleep for a couple of hours.

Next up I went to see Debaditya Chatterjee and Giridhar Ravipati speaking about “Oracle Multitenant Best Practices”. Some points that came out of that were.

  • Always use the AL32UTF8 character set for the CDB. Most other character sets can be converted to that to allow them to become PDBs and in a future version, we might be able to plug in a PDB with any character set, provided it is a subset of the CDB character set.
  • Use OMF, as it simplifies file management substantially.
  • Consider the impact of operations, like patching. Are you patching all PDBs, or not? If not, you will be using the unplug/plug approach to patching.
  • Standardise as much as possible.
  • Size SGA, redo and undo correctly to allow for the combined needs of the consolidated workload.
  • Always use Resource Manager to control resource usage of each PDB.
  • Don’t modify PDB$SEED. Create a new PDB with the modifications, then use that as the clone source, for new PDBs, instead of the seed.
  • Stagger maintenance windows within a CDB so all PDBs aren’t doing maintenance tasks at the same time.

Some points about possible features in 12.2 were also mentioned, including:

  • Maximum number of PDBs increased from 252 to 4096.
  • PDB memory management via resource manager.
  • Ability to set CPU_COUNT at the PDB level to allow the equivalent of instance caging for the PDB.
  • Hot cloning of PDBs and incremental PDB refresh.
  • Application containers, to allow common definitions across all similar PDBs. Useful for ISVs who require many copies of the same PDB, like one for each customer.
  • Online relocate of PDB from on-premise to cloud, as demoed by Larry Ellison at OpenWorld 2015

Remember, all talk of 12.2 is covered by the safe harbour slide, so those features might not end up in the final release. 🙂

After speaking to Debaditya and Giridhar, we headed off to a panel session to close the day. As most people will know, putting me on a panel can be a dangerous thing. I ended up having something to say about almost everything. Panels are a mix of scary and fun. 🙂 As usual, the session was followed by additional questions and conversations which lasted about an hour. 🙂

After saying a few quick goodbyes, it was off to grab some food, then back to my room to sleep some more. Are you starting to sense a pattern here? 🙂

Overall, day 1 was a really fun experience. Let’s hope day 2 does not come with quite so much jet-lag! 🙂

Cheers

Tim…

AIOUG Sangam15 : The Journey Begins

The day started pretty early. I was packing at 00:00 and the alarm went off at 05:00. Nothing like last minute packing to focus the mind. 🙂

The taxi to the airport was good. The driver was interesting, speaking to me about his visits to India and Pakistan. It certainly helps pass the time when the driver is chatty.

I wasn’t able to check-in online, but there was no queue at the check-in desk, so that was quick. It’s such a short trip I’m only traveling with hand luggage, but I still checked it. I can’t be bothered to fight for overhead locker space with everyone. The queue for security was really long, but they had all the sections open, so it moved quickly. I had to get my laptop scanned because … reasons?

Once through security I bought myself a coffee and promptly threw it across the floor. Embarrassing much! I was hoping to find some floor to take a nap on, but after shaming myself with the coffee situation, I thought the last thing I needed was to shame myself further by sleeping on the floor. I try to limit myself to one shameful moment per airport visit…

The flight from Birmingham to Dubai was easy. It was meant to be 6.5 hours, but we arrived early. The plane was half empty, so there was free space next to me. Happy days. During the flight I watched:

After a 2.5 hour layover in Dubai, it was time for the next flight. The flight from Dubai to Hyderabad was really busy and some lucky people, including me, got upgrades to business class (see video). It was only a 3 hour flight, but I’m all about the business class these days! 🙂 The important thing about upgrades is you have to pretend it wasn’t a free upgrade and you could afford it. 🙂 During the flight I watched the second half of Mission Impossible : Rogue Nation. It was quite good.

After a very pleasant flight, I arrived at Hyderabad and bumped into Kamran Agayev at customs. We agreed to share a taxi to the hotel, then I made him wait for over an hour for my bag to arrive. It was really embarrassing. Sorry mate!

I’m now firmly ensconced in the hotel (see video). It’s 05:24 and I plan to spend the whole of today (Friday) in bed playing catch-up, before the conference starts on Saturday.

Cheers

Tim…