Categories
Cycling Fitness Running

July – Keep Fit – Update

Just to show that I have been doing “some” prep work for my up and coming fund-raising events:

Running

Runs : 4
Distance : 8.81 miles
Time : 01:40
Avg Speed : 5.3 mph

Cycling

Cycles : 4
Distance : 15.82 miles
Time : 02:32
Avg Speed : 6.2 mph

Summary

Must Try Harder.
Concerned by the verl low average speed of the cycling !
August WILL be better!

Categories
Gardening

Gardening Update

Where The Rainbow Starts
Creative Commons License photo credit: Kuzeytac (OUT, till 20.08.09-see profile)
I’ve been neglecting my garden recently, the grass is being cut but that’s just about it.
Everything is growing but not as well as I wanted.

Categories
This Site

Back To Blogging – Shortly

Moo cards for blogging workshop
Creative Commons License photo credit: Mexicanwave
I have ben spending far too much time on Twitter and not enough time blogging.
This will be changing shortly.
I’m planning a redesign of the site.
First steps are I’ve cleared out all of the subscribers to my site and left only the people I have physically met. If I have deleted you by accident, I apologise.
If you would like to have an account e-mail or tweet me and I’ll create one for you.

More soon !

Categories
Oracle Work

Oracle Datatype Conversions

Last week I gave a colleague a demonstration on why, if you have numbers stored in a character string you should convert them explicitly to numbers:

select ‘Yes’
from dual
where ‘1000’ between ‘000’ and ‘999’;

‘YES’
—–
Yes

Categories
Gardening Home Improvements

The Great Gardening Project

DSCN0399

Whilst nowhere near as ambitious as J.D. and Kris’ project here I have decided to do some work in the garden this year. I’m a few weeks behind writing up my progress so I’ll try and summarise after the break.

Categories
Oracle Windows Work

Tell Me When The DB Is Back

database 2
Creative Commons License photo credit: Tim Morgan
Today at work the development DB went down.
My days of fixing databases are long gone, but the guys that are are not so good at letting everyone know that the database is back up.
I created this windows batch script to let me know.

Categories
Business Objects Dimensional Modelling Work XI 3.0

Blogging Whilst Employed – Beware!

october05.0103
Creative Commons License photo credit: eshm
I was having a flick through my employment contract and I found the following clause:

13.2
You agree that during the course of this contract and after the termination of the contract for whatever reason without limit in point in time you will keep in confidence and shall not disclose to any person unless authorised to do so with the prior written consent of the Company the following:-
13.2.1 Any consultancy know-how, methods, tools, techniques or intellectual capital.

I realised that some of my blog entries or tweets could fall foul of this clause so I asked for written permission to continue blogging generic “work related” content such as Business Intelligence, Data Warehousing, Data Modelling and Business Objects.
Rather than granting this and leveraging the fairly good google rankings that my posts seem to get I was asked to remove all work related posts.
Business Objects Best Practice (higher ranking than BusinessObjects.com)
Business Objects New Features (Page One)
Dimensional Modelling (Ralph Kimball ?)
As such I have password protected all of my work related posts.
If you are struggling to find content there are a variety of searches that could turn up interesting content.
Alternatively you can go to my company site, contact details can be found here or here.

Categories
Events Fundraising MND Motor Neuron Disease

Edinburgh Charity Fashion Show

I have just seen this link on the MND Scotland web site.
ecfs_logo-red

Categories
Work

A Song For Business Intelligence ?

What song do you think best sums up Business Intelligence?
.... Middle...
Creative Commons License photo credit: mistress_f

Categories
Business Objects Maxima Information Group Work

Business Objects – Best Practice – Report Design

Business Objects – Best Practice – Report Design

The purpose of this document is to provide a description of what I consider to be best practice when designing a business intelligence report. I will also try to describe the reasoning behind the suggestion.
Close up shot of pen
Creative Commons License photo credit: ArtemFinland