12,825 reputation
22657
bio website douglastechnology.co.uk
location Maidenhead, United Kingdom
age 38
visits member for 2 years, 1 month
seen 1 hour ago
stats profile views 1,136

I'm an Oracle certified Database Administrator

I've worked extensively with both Oracle and Postgres, in various roles from DBA to developer. I have a basic working experience with SQL Server and MySQL.

I'm happy to consider offers of part-time or short-term work either in the London/M4 area or working remotely.

You can view my CV online


1h
awarded  Necromancer
1d
awarded  Constituent
1d
awarded  Good Answer
1d
revised SQL Server 2008 R2 corrupted after changing MAXDOP
no need to address the OP by name
2d
comment Query for Oracle database
Hi Arun, this is too basic for dba.se. You might like to ask basic SQL questions on Stack Overflow?
2d
comment
you're a good man Phil :)
May
18
revised Workaround to importing data
deleted 24 characters in body
May
17
comment Copy tables from a stand-by database
-1 Why would the OP need this? As StanlyJohns commented, "You can read from the secondary server if it is setup in STANDBY mode".
May
17
comment How to connection PostgreSQL 9.2.1 with Hibernate
…and I'm closing this pending a response…
May
15
comment
@Matt sorry to hijack your comments :)
May
15
comment Cannot connect to SQL Server after setting sa password to blank
Hi vaheeds, please take a look at this link
May
15
comment Are all matching indexes (indices) searched for a query?
+1 though there are edge cases where lookups of foo on an index (foo) will be much faster than lookups on (foo,bar).
May
14
comment
great point about basic DB questions, we really don't want to start drowning in that stuff. Now pivot questions on the other hand…
May
14
comment
I think your diagnosis of SO is spot on, we need to keep dba.se 'upmarket', and that includes being strict(er?) with questions.
May
14
comment Representing N:N relation as a functional dependency in a database design
Hi Nick, I'm not at all sure you'd be interested in standing again, or indeed that you have any time to spare, but I do want to say you'd have my wholehearted support again if you do!
May
14
awarded  Caucus
May
12
awarded  Notable Question
May
9
revised PostgreSQL test validators needed!
deleted 29 characters in body
May
7
comment how to avoid the maximum--execution time error
I'm going to close this pending some feedback…
May
7
comment Range query from month and year
Hi Uchsun, although you got an answer, basic SQL is off-topic on dba.se. I'm moving it to SO as I think it is on-topic there.