Jack Douglas

Moderator ♦ less info
meta site favicon meta user | stack exchange network profile network profile
12,861 reputation
22757
bio website douglastechnology.co.uk
location Maidenhead, United Kingdom
age 38
visits member for 2 years, 1 month
seen 2 hours ago
stats profile views 1,139

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


274 Answers

newest activity votes
25
How to insert values into a table from a select query in PostgreSQL?
15
What storage engines work with Oracle?
14
Why is Database Administration so hard?
14
How to implement a 'default' flag that can only be set on a single row
13
What are the arguments against or for putting application logic in the database layer?
12
Can spatial index help a “range - order by - limit” query
12
How do I get the current unix timestamp from PostgreSQL?
11
Concept of Schema in PostgreSQL
11
What features of Oracle make it an attractive choice for small projects?
10
Oracle Shutdown Method
10
What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?
10
How can I use a default value in a Select query in PostgreSQL?
10
Alternatives to concatenating strings or going procedural to prevent SQL query code repetition?
9
Does the order of fields in SELECT query matter when using composite indexing?
9
If an 'after' DDL trigger causes an error, is the DDL rolled back?
9
Why doesn't INSERT AFTER Trigger add all results?
9
How to implement a 'default' flag that can only be set on a single row
9
What is the difference between select count(*) and select count(any_non_null_column)?
8
Cardinality is so far off from reality
8
Eliminate duplicates in ListAgg (Oracle)
8
How can I time SQL-queries using psql?
8
Is there a reason to use extremely abbreviated table names?
8
Oracle - Any way to view uncommited changes to a particular table?
8
Is there any point in undersizing VARCHAR columns?
8
Index Generation in Postgres
8
What are the benefits of using a different tablespace for a new user schema?
7
Is there a way to access temporary tables of other sessions in postgres?
7
Retrieve Indices of Associative Array as Collection
7
How to implement a 'default' flag that can only be set on a single row
7
Creating a GroupBy query to include a result for when no results match
1 2 3 4 5 … 10