14,713 reputation
33471
bio website douglastechnology.co.uk
location Maidenhead, United Kingdom
age 39
visits member for 3 years
seen 37 mins 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


1d
comment Postgres: Estimate of server specs required for write-heavy load?
What's the spec of your current machine?
1d
answered Postgres: Estimate of server specs required for write-heavy load?
Apr
19
comment How do I transfer logins from 2008R2 to 2014 with passwords?
@Aaron I ended up using this which is basically the same thing. Thanks for pointing me in the right direction.
Apr
19
comment How do I transfer logins from 2008R2 to 2014 with passwords?
@Aaron that looks very nice at first glance, thanks.
Apr
19
comment How do I transfer logins from 2008R2 to 2014 with passwords?
I've been to that page but I evidently don't understand it. Method 3 says "Create a log in script that has a blank password", so presumably that isn't it?
Apr
19
asked How do I transfer logins from 2008R2 to 2014 with passwords?
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 :)