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


14h
comment On reboot listeners don't start but restarting the service after will start them
Can you mark this 'accepted'?
2d
revised Conditionally sum a column based on a mod result
added 1 character in body
2d
comment ORA-00922 encountered in Oracle 11gR2 installer
Can you edit that info into the answer? It's better there than in the comments and it looks like useful info.
2d
comment Repair Corrupt Access Database File
You aren't affiliated with MDB Repair Kit in any way are you?
2d
revised Long running simple query SQL Server 2008 R2
deleted 106 characters in body
Jul
21
comment Plural vs Singular Table Name
Another point along the same lines.
Jul
19
revised Difference between database dump (export) and database backup?
added 11 characters in body; edited tags
Jul
19
reviewed Reject suggested edit on SQL Server Management Studio does not load
Jul
16
comment As a DBA, how would I go about transitioning from Oracle to SQL Server?
Is it worth adding a bit about lock escalation here? I think it'd come as a surprise to may Oracle folk used to unlimited row level locks
Jul
16
comment MySQL is running but not working
@RolandoMySQLDBA I've closed this as "Too Localized" per this comment: dba.stackexchange.com/questions/42096/… - out of interest did you VtC?
Jul
16
comment Update Only Rows With Shared/Similar Value
Please don't cross-post identical questions.
Jul
14
revised Get the first and last names of all employee who entered the project at the same time as at least one other employee
added 98 characters in body
Jul
12
comment Partitioning MySQL vs PostgreSQL
I think you are barking up the wrong tree here: why do you think you need partitioning at that volume?
Jul
12
comment Partitioning MySQL vs PostgreSQL
@Alexandros I think you are misunderstand what Chris is saying - read the comments above.
Jul
2
awarded  Inquisitive
Jul
2
awarded  Curious
Jun
27
comment How do you think in NoSQL?
@Lie that depends whether "Not only SQL" refers to procedural languages built into the database (it does not, not for the ones you mention or T-SQL or PL/SQL either) or to the language that is the API into the data storage layer itself. You can't access postgres data without SQL. Same on SQL Server, same on Oracle. I think I agree with your last sentence though - nevertheless that is what is occurring in the NoSQL world.
Jun
27
accepted Is this temp table behaviour documented?
Jun
27
revised Is this temp table behaviour documented?
added 246 characters in body
Jun
27
comment How do you think in NoSQL?
@LieRyan "All that is required for a database system to be a NoSQL is to not implement SQL" not true: NoSQL stands for "Not Only SQL".