Jack Douglas

12,795 reputation

22357

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

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

	12,795 reputation	bio	website	douglastechnology.co.uk	visits	member for	2 years, 1 month
22357 badges		location	Maidenhead, United Kingdom		seen	9 hours ago

summary answers questions tags badges favorites bounties reputation activity

33 Favorites

added views newest activity votes

votes

answers

kviews

Is it possible to use SQLite as a client-server database?

sqlite

may 7 at 17:48 jptros 1

votes

answer

407

views

database design issue

dec 21 at 13:18 Dave Hilditch 146

votes

answers

kviews

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

oracle windows enterprise-manager

nov 19 at 14:20 jamespo 141

votes

answers

282

views

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

oracle checkpoint

nov 7 at 14:04 Gaius 7,167

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

vote

answers

297

views

database sharding on mysql

mysql scalability

oct 12 at 21:44 Andy Grove 21

votes

answers

620

views

Placing Transaction Log on Separate Volume [solid state]?

performance

sep 14 at 1:48 yo hal 149

votes

answer

105

views

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

postgresql full-text-search

sep 3 at 10:56 Chris Travers 5,406

vote

answers

303

views

Limiting Generated Sequence Values in Multi-table Insert

oracle insert sequence

aug 25 at 16:35 Chris Saxon 1,387

votes

answers

100

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,877

votes

answers

kviews

How database size affects performance: Theory vs reality

mysql performance

aug 23 at 4:48 Mahesh Patil 985

votes

answers

683

views

Dynamic access to record column in plpgsql function

sql postgresql plsql plpgsql

aug 23 at 3:20 Erwin Brandstetter 8,697

votes

answers

610

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

193

views

optimizing a compare query

oracle query optimization query-performance

aug 22 at 13:48 Jack Douglas♦ 12.8k

votes

answer

384

views

How to copy bytea from Postgres to Oracle

oracle postgresql oracle-10g blob

aug 15 at 19:09 Jack Douglas♦ 12.8k

votes

answers

454

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 8,697

votes

answers

543

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,219

votes

answers

175

views

Can I rely on functions being executed first in SQL

oracle

jul 30 at 13:33 Stephen Kendall 321

votes

answers

kviews

Streaming replication and failover on PostgreSQL

postgresql replication slony pgpool repmgr

jul 29 at 15:05 Erwin Brandstetter 8,697

votes

answer

271

views

Design for file based with many events

database-design sqlite c#

jun 26 at 13:35 Community♦ 1

votes

answers

kviews

Too many columns in MySQL

mysql limits

jun 16 '12 at 23:44 Nick Chammas 5,910

votes

answer

356

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♦ 12.8k

votes

answers

240

views

Oracle build_plan_xml visualizer

oracle oracle-11g-r2 execution-plan

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

votes

answers

126

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 13.7k

votes

answers

616

views

Sort by match of LIKE

sql-server sql order-by pattern-matching

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

votes

answers

kviews

Working of indexes in PostgreSQL

postgresql index primary-key

dec 28 '11 at 1:05 Erwin Brandstetter 8,697

votes

answer

165

views

Accessing ORA_ROWSCN in the triggers body

oracle triggers

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

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

kviews

SQL to read XML from file into PostgreSQL database

postgresql xml

nov 21 '11 at 23:23 bignose 253

votes

answers

kviews

Best way to design tournament database

mysql sql database-design

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