14,683 reputation
33471
bio website douglastechnology.co.uk
location Maidenhead, United Kingdom
age 39
visits member for 3 years
seen 19 hours ago

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


Apr
12
reviewed Approve suggested edit on What steps should I perform to prepare a MDF for distribution as a (mostly) read-only database?
Apr
12
comment Row_Number() not working with OVER PARTITION BY
@Robert you can always comment on your own posts, and now you can comment anywhere :) good to have you on board...
Apr
9
comment Querying for reputation of the commenter and its addressee using SEDE
As you have a response on the SO version of this question I'll close this here rather than migrate again.
Apr
9
revised Filter Stored Procedure Result (Informix)
re-worded as an answer
Apr
8
reviewed Approve suggested edit on SQL Server 2008 R2 - Limit viewing on database list
Apr
7
comment Most idiomatic way to implement UPSERT in Postgresql nowadays
@FrançoisBeausoleil see here and here for why. Basically without a re-try loop, you either have to serialize or you have the possibility of failures due to the inherent race condition.
Apr
4
awarded  Yearling
Mar
26
reviewed Approve suggested edit on The total number of locks exceeds the lock table size, even after increasing buffer pool size
Mar
26
comment Cannot connect to database remotely (not even locally when using ip address)
this question already has an accepted answer and it was not firewall related
Mar
26
revised Need advice on abnormal login auditing
edited in summary of llink
Mar
22
comment Query array of arrays in MongoDB
I rejected the migration: SF might now send it to SO and you may want to re-post your answer there if they do?
Mar
22
comment Query array of arrays in MongoDB
This question appears to be off-topic because it is about programming in Perl
Mar
22
comment RAID 0 InnoDB speed - Comparing 8 x 7,200 RPM drives or 4 x 15,000 RPM drives
8x7200 will have roughly the same average rotational latancy as 4x15k. However rotational latency isn't the only variable in seek time, plus there's a whole bunch of other factors affecting overall performance.
Mar
18
comment sqlfiddle: leading blanks are gone
Well, you tried, thank you for that. I doubt it will ever get fixed on SQLFiddle, but I don't think this question will disappear either, so 'on hold' or not it serves it's purpose :)
Mar
17
revised Is this temp table behaviour documented?
added 791 characters in body
Mar
17
answered Is this temp table behaviour documented?
Mar
17
comment how to autoincrement varchar datatype depending upon the product details name using trigger
Use two tables?
Mar
17
comment sqlfiddle: leading blanks are gone
Yes, I'm not sure it's really off-topic: why not ask in The Heap? It might make a difference if you edit the question to make it clear you are after a workaround rather than just reporting a bug?
Mar
16
comment How can I prevent gaps in a MySQL table AUTO_INCREMENT field?
superche I hope you took @Daniel's excellent advice.
Mar
16
comment sqlfiddle: leading blanks are gone
I thought chr(160) might be better but it doesn't seem to make any difference. How about SELECT replace(' x',' ',' ') FROM dual?