Jack Douglas

13,029 reputation

22760

bio	website	douglastechnology.co.uk
	location	Maidenhead, United Kingdom
	age	38
visits	member for	2 years, 2 months
	seen	14 hours ago
stats	profile views	1,178

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

	13,029 reputation	bio	website	douglastechnology.co.uk	visits	member for	2 years, 2 months
22760 badges		location	Maidenhead, United Kingdom		seen	14 hours ago

summary answers questions tags badges favorites bounties reputation activity

34 Favorites

added views newest activity votes

-4

votes

answers

views

Find the salary difference between two months [closed]

oracle

jun 10 at 21:01 a_horse_with_no_name 8,316

votes

answers

kviews

Oracle Enterprise Manager 11g dbconsole “Internet Explorer cannot display the webpage”

nov 19 at 14:20 jamespo 151

vote

answers

321

views

database sharding on mysql

mysql scalability

oct 12 at 21:44 Andy Grove 21

votes

answers

682

views

Placing Transaction Log on Separate Volume [solid state]?

performance

sep 14 at 1:48 yo hal 149

votes

answers

620

views

What should I consider when deciding between passing a comma-delimited string to a stored procedure instead of calling it individually per record?

sql-server-2005 performance stored-procedures entity-framework

aug 22 at 21:52 Delux 124

votes

answers

kviews

How database size affects performance: Theory vs reality

mysql performance

aug 23 at 4:48 Mahesh Patil 985

votes

answers

200

views

optimizing a compare query

oracle query optimization query-performance

aug 22 at 13:48 Jack Douglas♦ 13k

vote

answers

307

views

Limiting Generated Sequence Values in Multi-table Insert

oracle insert sequence

aug 25 at 16:35 Chris Saxon 1,387

votes

answers

105

views

What are sensible/rational character limits in a database e.g. for a persons name

limits database-administration

aug 23 at 20:05 Chris Aldrich 1,977

votes

answer

106

views

Can I get the union of the a Postgres fulltext index?

postgresql full-text-search

sep 3 at 10:56 Chris Travers 5,646

votes

answer

419

views

How to copy bytea from Postgres to Oracle

oracle postgresql oracle-10g blob

aug 15 at 19:09 Jack Douglas♦ 13k

votes

answers

566

views

Why are queries parsed in such a way that disallows the use of column aliases in most clauses?

sql-server alias

aug 15 at 1:38 ErikE 1,254

votes

answers

179

views

Can I rely on functions being executed first in SQL

oracle

jul 30 at 13:33 Stephen Kendall 331

votes

answers

kviews

Scaling Percona datacenters: setup and replication

mysql replication mysql-5.5 percona xtradb-cluster

oct 22 at 20:23 Lena Weber 51

votes

answers

740

views

Dynamic access to record column in plpgsql function

sql postgresql plsql plpgsql

aug 23 at 3:20 Erwin Brandstetter 9,356

votes

answers

481

views

Can spatial index help a “range - order by - limit” query

database-design postgresql index query-performance spatial

aug 15 at 11:08 Erwin Brandstetter 9,356

votes

answers

247

views

Oracle build_plan_xml visualizer

oracle oracle-11g-r2 execution-plan

mar 21 '12 at 14:26 Jack Douglas♦ 13k

votes

answers

129

views

Getting the value of 'foo' for the closest previous row with higher 'bar'

oracle oracle-10g-r2

mar 13 '12 at 15:54 Leigh Riffel 14.1k

votes

answer

411

views

database design issue

sql-server sql-server-2008 sql relational

dec 21 at 13:18 Dave Hilditch 146

votes

answers

kviews

Streaming replication and failover on PostgreSQL

postgresql replication slony pgpool repmgr

jul 29 at 15:05 Erwin Brandstetter 9,356

votes

answers

293

views

What does “thread” mean in “thread checkpoints” context?

oracle checkpoint

nov 7 at 14:04 Gaius 7,241

votes

answer

170

views

Accessing ORA_ROWSCN in the triggers body

oracle triggers

dec 22 '11 at 20:46 Jack Douglas♦ 13k

votes

answers

692

views

Sort by match of LIKE

sql-server sql order-by pattern-matching

jan 18 '12 at 13:07 db2 3,674

votes

answers

kviews

SQL to read XML from file into PostgreSQL database

postgresql xml

jun 5 at 2:45 bignose 263

votes

answers

kviews

Best way to design tournament database

mysql sql database-design

nov 15 '11 at 11:34 Jack Douglas♦ 13k

votes

answer

365

views

In a two-server dataguard setup, can I store the recovery catalog in the same database?

oracle oracle-11g-r2 rman

apr 19 '12 at 8:29 Jack Douglas♦ 13k

votes

answers

views

Is it much more expensive to use procedures that get lists and deriving a count in the application vs. a separate stored procedure for the count?

sql-server-2008 performance

dec 1 '11 at 9:54 Anders Gregersen 1

votes

answers

343

views

Modifying table structure within a transaction?

oracle schema alter-table flashback

sep 30 '11 at 15:45 Todd Pierce 111

votes

answer

263

views

How can I alter the output for the sql desc command?

sql sqlplus

sep 29 '11 at 2:55 Leigh Riffel 14.1k

votes

answer

277

views

Design for file based with many events

database-design sqlite c#

jun 26 '12 at 13:35 Community♦ 1