15,775 reputation
33880
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 6 months
seen 10 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.


Aug
12
comment Can anyone recommend a beginner DBA course in London
This question appears to be off-topic because it is about career advice
Aug
12
reviewed Approve suggested edit on Can anyone recommend a beginner DBA course in London
Aug
11
comment SQL insert into … values (…, select(…))
I don't think you mean to, but it sounds like you are saying this doesn't work?
Aug
7
comment Last few rows from a non-indexed table in Oracle
@cha ROWID doesn't tell you anything about when the row was inserted: community.oracle.com/thread/880161?tstart=0
Aug
4
revised materialized-view wiki description
trying to make this make sense post synonym switch
Aug
4
revised materialized-view wiki excerpt
trying to make this make sense post synonym switch
Aug
4
revised How can I organize my tables?
bring in line with edited question
Aug
4
revised How can I organize my tables?
edited tags
Aug
2
revised MySQL: Use Sysbench on Windows
edited in comments
Jul
31
comment Why does dropping a MVIEW trigger a full refresh?
@a_horse_with_no_name you aren't running noscript or anything like that are you? Have you tried a different browser to see if it is account specific?
Jul
31
revised SQL Server - contents of transaction log file in more detail
removed 'thanks guys'
Jul
31
revised SQL Server - contents of transaction log file in more detail
removed reference to deleted comment
Jul
30
comment Formal name for functions that use the OVER clause
@a_horse yes, they chose that term in SQL2003 over the Oracle term that pre-dates it. Fwiw I think it was the right choice, it's far more descriptive.
Jul
30
comment Formal name for functions that use the OVER clause
They were called 'analytic' functions on Oracle for many years, but 'window(ing) functions' is the more generic term.
Jul
30
revised Formal name for functions that use the OVER clause
edited tags
Jul
28
comment Database Design for classifieds site
I think the minimum you need to do to make this less broad is provide a SQLFiddle.
Jul
28
comment Why are some aggregates treated differently in the RHS of a rule in the model clause?
I forgot about this and hit it again today. At least it reminded me to accept your answer, thanks :)
Jul
28
accepted Why are some aggregates treated differently in the RHS of a rule in the model clause?
Jul
26
revised How do I select 1st row of each table and insert that data to a new table
added 177 characters in body
Jul
23
revised Conditionally sum a column based on a mod result
added 1 character in body