Skip navigation.

Tim Hall

Syndicate content
Oracle related rants (and lots of off-topic stuff)...
Updated: 16 hours 26 min ago

Google as a Cloud Provider?

Wed, 2016-03-23 05:40

cloudI saw a tweet this morning that pointed me to this article.

Google To Challenge Amazon, Microsoft In Cloud Computing War

 

This comes hot on the heels of this article.

Google dumps ISP email support. Virgin Media takes ball, stomps home

I use a lot of Google services and I like them. Having said that, I just can’t bring myself to take their Google Cloud Platform seriously. It’s not that I don’t believe they have the capability to do cloud. The are Google after all. :) It’s more about trusting their services will exist in the future. If they are happy to dump 4.6 million email customers in one shot, why should I believe they give a crap about my IaaS stuff?

This kind of behaviour is not new from Google. They have taken an axe to many services before, but this seems so much more dramatic and significant from a company that is pushing their public cloud agenda.

Now it all comes down to money, and I guess Google couldn’t make enough off the this ISP email customer, but it is still a worrying signal. People should always have an exit strategy for every cloud project, but with Google it seems like it should be a bigger priority.

Maybe I’m just being paranoid. Maybe I’m not. I just feel unnerved.

Cheers

Tim…

Google as a Cloud Provider? was first posted on March 23, 2016 at 12:40 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Video : The MERGE Statement

Tue, 2016-03-22 01:28

After a what seems like an eternity of being ill and having a dodgy throat, followed quickly by a couple of conferences, I’ve finally got back on the horse and recorded another video.

I was explaining a specific aspect of the MERGE statement to one of my colleagues and while I was doing it I was thinking, “Have I done a video on MERGE yet?” Now I have.

The cameo for this video is Cary Millsap. If you watch the out-takes at the end you will see the level of respect and trust I have garnered in the community. The words confused and suspicious spring to mind! :)

An honourable mention goes out to James Morle for videobombing. :)

Cheers

Tim…

Video : The MERGE Statement was first posted on March 22, 2016 at 8:28 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle Midlands : Event #14 – Summary

Wed, 2016-03-16 08:17

Last night was Oracle Midlands Even #14 with Lothar Flatz.

The session started with “Raiders of the Data Dictionary I: Indexing for the Workload” where Lothar discussed a project he worked on based around completely revamping the indexing of a system. I guess the best way I can describe it is to say it’s a more scientific approach to indexing, using the contents of the dictionary to provide information about columns and column groups used in queries to determine the indexes to create. In some ways the approach was quite extreme (throw everything away and start again), but I also admire the bravery of that approach!

Next up was “Raiders of the Data Dictionary II: The Curse of the Buffer Cache” where Lothar discussed the problems associated with trying to keep large, frequently used tables in the buffer cache. Once again, some interesting points made and some things that will definitely influence my approach in future.

It was great to meet Lothar in person for the first time. After being in the game for 20+ years many subjects can start to feel a little repetitive, so it’s nice when someone comes along with a different spin on a subject. I certainly found myself asking a lot of questions of him and myself, which surely must be what this knowledge spreading thing is all about!

Thanks to Lothar for taking the time to come and speak to us and to everyone that came along to listen. Thanks to Mike for doing a great job in keeping Oracle Midlands going and to Red Stack Tech for their continued support.

See you at the next one! :)

Cheers

Tim…

Oracle Midlands : Event #14 – Summary was first posted on March 16, 2016 at 3:17 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

KeePass 2.32

Mon, 2016-03-14 05:33

KeePass 2.32 has been released. You can download it from here.

You can read about how I use KeePass and KeePassX2 on my Mac, Windows and Android devices here.

Cheers

Tim…

KeePass 2.32 was first posted on March 14, 2016 at 12:33 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle Midlands : Event #14

Mon, 2016-03-14 04:33

Tomorrow is Oracle Midlands Event #14.

om14

Please show your support and come along. It’s free thanks to the sponsorship by RedStackTech.

Cheers

Tim…

Oracle Midlands : Event #14 was first posted on March 14, 2016 at 11:33 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

UKOUG Application Server & Middleware SIG – Summary

Sat, 2016-03-12 08:08

ukougOn Thursday I did a presentation at the UKOUG Application Server & Middleware SIG.

As I mentioned in my previous post, I was not able to stay for the whole day. I arrived about 30 minutes before my session was scheduled to start. The previous session finished about 10 minutes early and the speaker following me cancelled, so my 45 minute session extended to about 70 minutes. :)

 

There had already been speakers focussing on Oracle Cloud and Amazon Web Services (AWS), so I did a live demo of Azure, which included building an Oracle Linux VM and doing an install of WebLogic and ADF. There was also a more general presentation about running Oracle products on the cloud. I’m not a WebLogic or cloud specialist, so this presentation is based on me talking about my experiences of those two areas. Peter Berry from Clckwrk and Paul Bainbridge from Fujitsu corrected me on a couple of things, which was cool.

After my session I hung around for a quick chat, but I had to rush back to work to do an upgrade, which went OK. :)

Thanks to the organisers for inviting me and thanks to everyone that came along. It would have been good to see the other presentations, but unfortunately that was not possible for me this time!

Cheers

Tim…

PS. Simon, the preinstall packages were installed in the Oracle Linux templates. :)

# rpm -qa | grep preinstall
oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64
oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64
#
UKOUG Application Server & Middleware SIG – Summary was first posted on March 12, 2016 at 3:08 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

UKOUG Application Server & Middleware SIG

Wed, 2016-03-09 05:50

ukougI’ll be speaking at the UKOUG Application Server & Middleware SIG tomorrow.

It’s going to be another hit-and-run affair for me. I’m in meetings at work all morning, then I’ll be doing a mad dash to get to my presentation at the SIG, then straight back to work to do an upgrade during the evening.

The agenda looks cool, so I would have liked to stay the whole day, but sadly that’s not going to happen. :(

My favourite bit of any tech event is interacting with people, so just turning up to present is not ideal, but in this case I don’t have a choice in the matter, unless I go AWOL from work… :)

Hope to see you there, even if it is only briefly!

Cheers

Tim…

UKOUG Application Server & Middleware SIG was first posted on March 9, 2016 at 12:50 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

OUG Ireland 2016 – Summary

Tue, 2016-03-08 08:05

oug-ireland-2016

The day started at 05:00. I lay in the bath for 20 minutes in denial, wondering how I would manage to stay awake for the day. I’ve been ill for ages, so I felt like I was running on empty anyway. Once I had managed to drag myself out of the bath and get dressed, I picked up my laptop and took a taxi to the airport.

The taxi to the airport was smooth enough. I was already checked in and had no bags to drop off, so I went straight for the security and was greeted by the biggest queue I had ever seen at Birmingham airport. To all those people that laugh at me getting to the airport 2+ hours before a short flight like this I say, “Better to be safe than sorry!”

Despite the massive queue for security, populated by people who didn’t understand commands like, “Belts off!”, and, “All liquids out of your bags!”, the queue moved quite quickly and the departure area felt relatively quiet. I grabbed some food and logged into work to find one of the DW loads had failed. I cleaned stuff up and reset it. As I was boarding I passed one of my colleagues who was off to Glasgow for a product user group. I shouted across that his DW load had failed, then turned the corner to board before he could quiz me further. :)

The ChavAir flight was fine. They are a basic bitch airline, but you can’t really complain when you are paying £27 for a return flight. I overheard three people saying they paid £20 return. I was robbed. :)

When I arrived in Dublin, I got the AirLink Express into the city, which was 10 Euros for a return ticket and dropped me off about 100 yards from the Gresham Hotel. Bonus!

After signing in and saying hello to a couple of people, including the wife, it was off to the first session. My timetable for the day was:

  • Marcin Przepiorowski with “Looking for Performance Issue in Oracle SE. Check What OraSASH Can do for You”. I’m lucky enough to have Oracle EE with the Diagnotics and Tuning pack for all the databases I work with, so I get to use the real ASH and the performance pages in Cloud Control. Even so, it’s worth keeping your eye on what others are doing, as you never know when you will need it!
  • Carl Dudley with “SQL Tips, Techniques and Traps”. I really enjoyed this session. It was a quick pace with lots of little and interesting points. I’m sure everyone picked up something they had not heard before. I know I did.
  • Oren Nakdimon with “Write Less (Code) with More (Oracle 12c New Features)”. This was another quick paced session made up of lots of little pointers. As I watched it I found myself thinking, “Have I written about that?”, or, “Did I include that in my article?”. There were certainly a few things that had passed me by during my time with 12c, so I made a note about them and will be revisiting a couple of articles. It was a really neat session!
  • Keith Laker with “SQL Pattern Matching Deep Dive”. I’ve written some stuff on pattern matching, but this was another level. After watching this session I know enough to know I don’t know enough. :) Definitely a subject I need to go back and revisit. I’m always a little nervous of deep dive sessions because often they don’t deserve that title. I think this one did! :)
  • Me with “Analytic Functions: An Oracle Developer’s Best Friend”. This was in the same room as Keith’s talk and had most of the same audience. I started by saying something to the tune of, if you understood the stuff from the previous session, you probably don’t need to watch this one. :) My analytics session is quite different to ones I’ve seen others do. It is an entry level session, where I repeatedly reference non-analytics stuff to try and simplify the concepts and syntax. If you have done lots of analytics it’s probably not for you, but I always get some comments from people saying they use analytics, but didn’t realise what some of the stuff did.
  • Me with “Oracle Database Consolidation: It’s Not All About Oracle Database 12c!”. This is an overview session where I discuss the methods of database consolidation I use along with their pros and cons. I don’t dislike any individual method of database consolidation, but I do react harshly to anyone who claims one method is superior. There is no one-size-fits-all solution to database consolidation and anyone that tells you there is is a bloody liar! You will always need a combination of approaches and this is very much my message here. It’s a light and fluffy session, which probably fits quite well towards the end of the day when everyone is fried. :)
  • Cloud Q&A Panel Session. I mostly turned up to support the wife, but it was actually quite relevant to my current company, who are in the procurement phase of a replacement for many of our core business systems, with “the cloud” being an option. Added to that, I’ve been doing POCs of Azure, AWS and Oracle Cloud recently for IaaS and PaaS.

From there is was a quick chat with some folks at the social event, then the AirLink Express back to Dublin Airport.

The flight back was fine, but I was starting to feel really worse for wear. At one point I thought I was going to puke, but I managed not to. I was imagining everyone else thinking I had been for a day on the lash in Dublin. :) We landed early and I got a taxi home and the day was done!

Big thanks to OUG Ireland for inviting me to the day. Sorry I couldn’t stay for the second day! Thanks to the other speakers and attendees, who are collectively the most important people there! Thanks to the Oracle ACE Program for letting me continue to fly the flag!

For anyone that is looking for a new conference to try out, you should give OUG Ireland 2017 a go. Just so you know, here is the breakdown of the travel costs for my day trip:

  • Taxi to airport: £25
  • Return flight between Birmingham and Dublin: £27
  • Return trip on AirLink Express into the city: 10 Euros
  • Taxi home: £35
  • Total: < £100

The costs have been similar for the last three years and it’s certainly something I’m happy to pay out of my own pocket!

See you all next year!

Cheers

Tim…

OUG Ireland 2016 – Summary was first posted on March 8, 2016 at 3:05 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

VirtualBox 5.0.16

Sat, 2016-03-05 07:53

VirtualBox 5.0.16 was released yesterday.

Downloads and changelog are in the usual places.

The installation went fine at work on Windows 7 and on Mac OS X (El Crapitan) at home.

Cheers

Tim…

VirtualBox 5.0.16 was first posted on March 5, 2016 at 2:53 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

UltraEdit 23 for Windows

Fri, 2016-03-04 05:49

UltraEdit 23 for Windows has been released. Followers of the blog will know I’m an UltraEdit junkie, so as soon as I got the email telling me UltraEdit 23 had arrived I installed it instantly. Fools rush in where angels fear to tread!

The glaring hideousness you are presented with is a ribbon! For ***** sake! Hasn’t the whole world spent enough time moaning about the Office ribbons already?

uedit23

Never mind. Right-clicking on the ribbon allows you to switch to “Toolbar/Menu Mode”, so that’s good right? Wrong! You switch and everything looks fine, but when you resize the window you lose half of the windows and the only way back is to enable the ribbon again. :( (Fixed by latest build)

So I’m left with this bloody awful ribbon, or a non-functioning editor. I am not happy!

Moving away from the ribbon issue, there seem to be a number of rendering issues about the product in general. Making minor theme or layout changes cause it to hang for a minute, before coming back to life.

This release seems to be mostly about the pretties, but the pretties make the product unusable. I can’t state how disappointed I am with this release. Let’s hope the patches come soon!

My advice, don’t upgrade to 23.00.0.43 as it is bloody useless. Wait until they sort out the rendering and the “Toolbar/Menu Mode”, then you can use something that doesn’t make you want to vomit or slash your wrists!

Cheers

Tim…

Update: It seems my problems with UltraEdit 23 may be caused by my work Windows PC being locked down to Classic Mode, rather than using Aero. If you also use Classic Mode, approach UltraEdit 23 with care. If not, then everything I say below is probably not relevant to you!

Update 2: IDM have sent me a new build (23.00.0.49) that works fine. I guess this will be available for others to download soon.

UltraEdit 23 for Windows was first posted on March 4, 2016 at 12:49 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

OUG Ireland 2016

Wed, 2016-03-02 02:24

oug-ireland-2016

Early tomorrow morning I will start my journey to Ireland for the OUG Ireland 2016 conference.

I’ve got back-to-back sessions in the afternoon on database consolidation and analytic functions. I was invited to a panel on the Friday also, but I had already booked my flights before that invite, so sadly I had to decline.

This year is going to be another day trip for me, with the flight costing a gigantic £27 on ChavAir. :)

See you there!

Cheers

Tim…

OUG Ireland 2016 was first posted on March 2, 2016 at 9:24 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Nothing you learn is ever wasted!

Fri, 2016-02-26 01:45

glasses-272399_1280-smallAbout 18 months ago I went on a couple of load balancer training courses at F5. It was over a year later that we actually got the things wired in and ready to go. I played with them for a couple of days, then nothing for another six months. I’ve only put one service live on them so far, but we are about to start the full rollout now. :)

In that time there has been a change of heart over which team will look after them, and it’s not my team. I’m still going to have to migrate 100+ services from our reverse proxy to the load balancers, but once everything is live it will probably get handed over to another team.

Last week we started the handover process, so I went and spent 2.5 hours with the guys, talking about the setup we had done and the sort of tasks they will have to pick up. One of the other guys has put together a workflow and a formal document. I took with me a little template of all the information I needed to plug a new service into the load balancer. When I got back to my desk, I removed all the config we had done together, then repeated it, but this time capturing my screen to make 8 little videos to go with the template doc. This all got put into the company knowledge base.

What’s this got to do with the title of this post?

  • My time figuring out what the hell a reverse proxy was and how to configure one helped me a lot when I went on the load balancer course at F5. It also meant I was still able to muddle my way through stuff having not used the load balancer kit for 18 months. When you understand where you have to go, it can sometimes make getting there a lot easier.
  • Speaking at conferences about Oracle stuff has a positive effect on your ability to speak about other subjects in public. This month at work I have done this handover and a general introductory talk about cloud technologies. Neither of these subjects are “what I do”, but both were a breeze because of the skills I’ve picked up elsewhere.
  • It took 2.5 hours to explain the load balancer stuff to the guys. Realistically, they will forget it in a few days. It will take them about 10 minutes to look through the knowledge base note and watch the video clips. I think that will pretty much remind them of the important points. I would never have attempted the video stuff if I hadn’t been playing with YouTube over the last few months.

You are the combination of your experiences. Everything you do and everything your learn combine to make you the person you are. I still complain when I’m asked to do random things, but in the back of my mind I know it will probably prove useful sometime down the line… :)

Cheers

Tim…

Nothing you learn is ever wasted! was first posted on February 26, 2016 at 8:45 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Always write everything down!

Tue, 2016-02-23 02:33

notes-514998_640In my second job we worked on projects in small teams, maybe 2-3 people. My boss at the time, the team leader, was a lady called Andrea. She wrote everything down. I mean everything! I was still pretty new to the business world and rather naive, so I tended to rely on my memory a lot. Needless to say, she saved our bacon on numerous occasions. That was a very good lesson!

Now I’m still a bit lazy where general note-taking is concerned, but where tech is concerned I write down everything. If they are “general recipes”, I’ve probably already done a run through at home and written it up on my website. If they are company-specific notes or scripts, they go into the company knowledge base, or are saved as text notes on a shared drive. If I’m not sure where it should live, it goes in my scratchpad until I find a real home for it later. Nothing is ever lost!

As a DBA, you are often asked to use bits of technology you’ve not touched for years, or to look at systems you set up months/years ago, so having notes is a life saver. Last week I was asked to alter some WebLogic config on a system I set up about 2 years ago and I honestly didn’t have a clue what I had done. A quick rummage around and I found my setup notes and within about 30 seconds I was ready to go. It would have taken me ages to figure this stuff out again.

When you are in the thick of things, you can’t imagine a time when you won’t remember everything about a project. A couple of months later, it’s like you never worked on it. The only way you can keep your head above water is to make notes. The trick is to write enough to explain things clearly, but not so much you can’t be bothered to read them. :)

I’m always telling people to write. It’s nice if it is something that you can publish on a website or blog, but even if all your notes are hidden away, you still need to write them. Very few people can keep all this crap in their heads at all time. The good people are those who know where to get the information from. The internet helps, but I would take my own notes over a random internet search any day. You know more about your job and your company than some random person in the internet. Make your own notes!

Cheers

Tim…

PS. I purposely stayed away from the words “document” and “documentation” as people hear them and switch off. I am of course talking about documentation, but not that bloated crap overpriced consultancies give you. :)

Always write everything down! was first posted on February 23, 2016 at 9:33 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle Midlands : Webinar

Mon, 2016-02-22 03:48

Just a quick reminder about tonight’s Oracle Midlands Webinar.

om-webinar

Cheers

Tim…

Oracle Midlands : Webinar was first posted on February 22, 2016 at 10:48 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

All change at oracle-base.com (MySQL 5.7 and PHP7)

Mon, 2016-02-22 00:51

Over the weekend I decided to upgrade from MySQL 5.6 to 5.7. I did some test upgrades a while ago and last week at work we did some practice upgrades on a clone of one of our production servers. I was pretty confident the upgrade would be fine and it was. I wasn’t totally sure how some of the surrounding applications would cope with the change though.

Once the MySQL 5.7 upgrade was complete everything was working fine, so I got a little excited and decided to switch to PHP7 as well. Before this I was just using the stock version from the CentOS6 yum repository, which was pretty old.

The switch to PHP7 was a little more problematic. Some of my code failed, but a quick look at the Apache error log showed I was still using split() in a couple of places where I should have been using explode(). Once I sorted that the main website looked fine. WordPress worked with no problems, which was nice.

I had a couple of issues with phpBB 3.1. First, I was still using the database type of “mysql” in the phpBB config, which means it uses mysql_connect() to connect to the database. That has been deprecated for a while, but has been desupported in PHP7. Once I switched the database type to “mysqli” and emptied the contents of the “cache” directory it connected OK. There are still some issues, which according to the change log will not get fixed until the phpBB 3.2 release, but with the exception of some ugly debugging messages, it kind-of works now.

Both MySQL 5.7 and PHP7 claim significant performance improvements, so it will be interesting to see if that is noticeable on my site.

Cheers

Tim…

PS. I don’t believe the downtime this morning was anything to do with the upgrade. I’ve been fighting with the server for a while now. My current contract comes to an end in about 4 months. I think I’ll make a move to AWS next. Maybe a couple of small servers and a load balancer in front of them!

All change at oracle-base.com (MySQL 5.7 and PHP7) was first posted on February 22, 2016 at 7:51 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Problem Solving (Breaking Things Down)

Fri, 2016-02-19 03:58

direction-1033278_640Some people are great at problem solving, others not so much. The people I meet that are good at problem solving always have one very important skill, the ability to break stuff down into its constituent parts. With practice, it can seem like they are making massive leaps of faith, but that is based on their experience. That experience came from breaking problems down and dealing with the little stuff. Here are some examples, including some you may not consider as classic problem solving, but illustrate the point.

Books: Ask somebody to write a book and they will crap themselves. The thought of writing a book is really daunting. Ask them to write a chapter and they might still be scared, but less so. Ask them to write a page and most people would probably grudgingly do it. A book is a collection of pages. If you can write a page, you can write a book. I’m not saying it’s a good book of course, but you get my point. So the problem of writing a book and be broken down into very manageable pieces.

Development: I’ve been involved in some really complicated development projects in my career. When you’ve finished, you take a look back and think, how the hell did we manage to do that? When you look at the individual bits, they are all pretty simple. The skill is breaking down that massively complex development into manageable chunks. The classic top-down or bottom-up approaches to programming encouraged this. Agile, when done properly, also encourages this approach of breaking down problems to small units of work, delivered on a regular basis. So the big problem is broken down to little bits, that get put together and you end up with something that seems bigger than the sum of its parts.

Infrastructure: When you are dealing with multi-tier architectures, finding the cause of a problem can be quite complicated. You get questions like, “this URL is not working, why not?”. Based on experience of your environment, you might know likely candidates, but if not, you may have to take the long route, which may look like this:

  • Can I connect to the database?
  • If I connect directly to the App Server, rather than via the web layer (Load balancer, Reverse Proxy, web server) does the application work?
  • If I connect via the web layer, does the application work?
  • If I connect from different network zones, does the application work?

Based on the answers to those questions, I will know which part of the chain is broken and I can look at that specific section and break it down further, eventually finding the root cause and getting the relevant people involved to fix it.

SQL Tuning: Looking at a 10 page execution plan is really scary. What is a plan made up of? Lots of individual steps that combine to form the whole plan. If you work your way through the plan in order, operation by operation, it is often very obvious what is going wrong. Typically, a bad cardinality estimate somewhere causes the optimizer to make a bad decision, which kind-of propagates up the plan. Fix that cardinality estimate, or help the optimizer by “shaping” the plan in a more sensible fashion and things often fall into place. If you get a chance to see Jonathan Lewis talking about SQL tuning and shaping execution plans, or Kyle Hailey speaking about his approach to SQL tuning, you will see they both focus on breaking stuff down to their constituent parts, and you will realise the “black magic” they perform is actually very doable by mere mortals like us if we take a consistent and meticulous approach.

Life is all about breaking down big and daunting tasks into smaller, more manageable tasks. You can either get used to it, or spend the rest of your life achieving nothing and wondering what magic button everyone else is using! :)

Cheers

Tim…

PS. I understand there are lots of ways to achieve a goal and successful people will find a way of working that suites them. :)

Problem Solving (Breaking Things Down) was first posted on February 19, 2016 at 10:58 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Sharknado 3: Oh Hell No!

Wed, 2016-02-17 15:49

sharnado3Sharknado took the bad B-Movie concept to it’s ultimate conclusion, making it an instant classic. A tornado sucks up a bunch of sharks to create a sharknado that passes over Los Angeles.

Sharknado 2: The Second One was a parody of Sharknado, with everything bigger, crazier and better. Not one, but two sharknados, threatening to merge to forms a super-sharknado over New York!

Sharknado 3: Oh Hell No! has finally come to NetFlix in the UK and managed to do the unthinkable. Not one, not two, but a whole wall of sharknados hitting the entire east coast of the USA. Can anyone save the whole of the east coast? Watch the film and find out!

After seeing this masterpiece of modern film making, I’m going to struggle to find the motivation to ever watch another film again in my life. When you’ve reached the top, the only way is down!

Cheers

Tim…

Sharknado 3: Oh Hell No! was first posted on February 17, 2016 at 10:49 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

I’m not spamming your blog comments!

Sun, 2016-02-14 06:58

confused-panda-303949_640It has come to my attention that there is a new website in town that happens to have a URL extremely similar to mine. Literally one character different. The domain in question was registered on 3rd November 2015.

Let me first say, the site in question does not contain any of my content (*see update*) and as far as I know is not doing anything wrong from a content perspective. The reason I am writing this post is to protect myself.

It has come to my attention the owner of this site is spamming links to his site in the comments of other bloggers. It’s your typically link spam stuff, seldom any relevance to the original article, and just trying to get attention. Why do I care? In some cases these spam comments are obviously nothing to do with me, because they are posted under this guys own name. In others, it is very easy to mistakenly believe it is me spamming links to my site, because the URL is so darn similar. In fact, when it was first pointed out to me, I didn’t even notice they weren’t links to my site. My brain just auto-corrected it. :)

I just want to make it very clear, if you see spam links in your blog comments or forum answers that at first glance seem to point to “oracle-base.com”, please double check the URL before you get pissed off with me. It is not me posting this stuff. They are not links to my website. I’m gaining nothing out of this, but potential bad feeling from other bloggers!

To the individual in question, I have a few words of advice.

  • Spamming links to your website from other people’s blog comments really doesn’t do much to publicise your content. Most CMS tools, like WordPress, give external links in the comments section a NOFOLLOW value. As a result, those links don’t get followed by the search engine spiders and don’t help with your search ranking. You are literally wasting your time.
  • Content producers get really annoyed by spam comments. The more you do this, the more you get a reputation of being a dick. I wrote this post because I don’t want people to mistakenly blame me, for what you are doing.
  • Choosing a URL so similar to someone else’s is either a really lazy move, or a cynical attempt to piggy-back on their reputation. Either way, it doesn’t reflect well on you as an individual. It’s cool that you are producing content in the community to help others and gain some profile. I just don’t see how the URL you chose to use will be viewed in a positive light by anyone.
  • Once someone knows the domain, a couple of Google searches and it becomes obvious who you are, that you already have an existing blog. I would suggest the content you are producing would be better posted to that blog. You are obviously fairly new to the content production game, so building a reputation associated with your name seems like a much better idea from a career perspective. My website is very well know, but in comparison I am not. That is kind-of the opposite of what most people want when they are trying to build a profile to help with their career.

If you are one of the bloggers I’ve contacted about this link spam, I would prefer it if you don’t mention the domain in question. At this point I think the individual is just misguided, so I don’t want this to become a witch hunt.

Cheers

Tim…

Update: I have found one of my articles on the site. I wrote to the owner of this website and ask for it to be removed. I’ve heard nothing back, so I’ve filed a DMCA take down notice.

I’m not spamming your blog comments! was first posted on February 14, 2016 at 1:58 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

UltraEdit v16 for Mac

Sat, 2016-02-13 07:59

Followers of the blog will know I’ve been a long time user of the editor UltraEdit.

uemac-theme

I got introduced to UltraEdit about 15 years ago. At the time everything else around sucked. I paid my money and was hooked pretty much instantly. At that point it was a Windows-only product. When I later ditched Windows in favour of Linux at home, I went through a succession of crappy editors and was never really happy. I eventually started running UltraEdit on Linux using Wine and it “mostly” worked.

A few years ago I switched from Linux desktops to Mac and went through another succession of crappy editors that everyone told me were amazing. One day I woke up to find UltraEdit had released a Mac and Linux version of their editor. It was lacking features compared to the Windows version, but it worked. I immediately switched and have been there ever since.

I have a multi-platform unlimited upgrades license, which cost me something like $200 a few years ago. I use UltraEdit for Mac on my desktop at home. I use the Windows version when I’m at work. Very occasionally I fire up the Linux version on one of my servers, but that tends not to happen much these days as I just connect to that stuff from my Mac.

Today I’ve upgraded to UltraEdit for Mac v16. It still doesn’t have 100% of the features of the Windows version, but it’s getting close. Happy days!

I know there are a lot of good editors out there (Sublime Text, NotePad++, Atom etc.), but I don’t get on too well with any of them. I’m sure a lot of if comes down to familiarity, but I find myself saying, “If only they could do …” all the time. Aaaahhhh, to be old and set in your ways. :) Anyway, if you like any of those, all power to you. If you are struggling against them, you might want to give UltraEdit a try!

Cheers

Tim…

PS. This is not a sponsored ad. I’m just a fan! :)

UltraEdit v16 for Mac was first posted on February 13, 2016 at 2:59 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Video: Amazon Web Services (AWS) : Relational Database Services (RDS) for SQL Server

Thu, 2016-02-11 01:15

Here’s another video on my YouTube channel. This one is a quick run through of RDS for SQL Server, a DBaaS offering from Amazon Web Services.

The video was based on this article.

The cameo for this video is Garth Harbach, a former colleague of mine. :)

I’ve been ill recently and my voice is pretty shot. The last three videos have all be on AWS RDS, which has very similar setup regardless of which database engine you use. This has been really handy, as I could pretty much reuse one vocal track for all three videos. Not sure if anyone would have noticed, but I felt guilty, so I thought I would confess up front. :)

I’m hoping I’ll get my voice back in the next few days so I’ll be able to do something different. :)

Cheers

Tim…

Video: Amazon Web Services (AWS) : Relational Database Services (RDS) for SQL Server was first posted on February 11, 2016 at 8:15 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.