meta user
network profile
| bio | website | douglastechnology.co.uk |
|---|---|---|
| location | Maidenhead, United Kingdom | |
| age | 38 | |
| visits | member for | 2 years, 1 month |
| seen | 7 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
|
May 2 |
awarded | Pundit |
|
May 1 |
comment |
Foreign Key to Multicolumn Primary Key? the FKs need to be on category_product. I'd suggest using eg product_id instead of just id from the PK too to reduce confusion. |
|
Apr 30 |
asked | Identical subquery optimisation in an update |
|
Apr 30 |
answered | Identical subquery optimisation in an update |
|
Apr 28 |
accepted | Is there better way to 'touch' a row than performing a dummy update? |
|
Apr 26 |
comment |
Is there better way to 'touch' a row than performing a dummy update? What would you do instead, use a 'version' column and a sequence? |
|
Apr 24 |
asked | Is there better way to 'touch' a row than performing a dummy update? |
|
Apr 20 |
awarded | Enlightened |
|
Apr 20 |
comment |
Creating sequence for longer numeric values or check (id between 10000000000000000001 and 19223372036854775808)? |
|
Apr 20 |
awarded | Nice Answer |
|
Apr 19 |
comment |
How to fetch min value for different node ids in a same row? This is 'basic' SQL which is off-topic here |
|
Apr 19 |
comment |
how to insert data from one table to another I think this is too basic for dba.se |
|
Apr 19 |
comment |
Oracle SQL, how to filter on a set by a rank? @haki ah yes, bugs are more common when combining features I've found: I'm still finding them regularly using union and hierarchical queries. Usually easy to work around though: what version are you working with btw? |
|
Apr 19 |
revised |
Steps to upgrade MySQL from version 5.0 to version 5.5 appended answer 40427 as supplemental |
|
Apr 18 |
revised |
PostgreSQL: Cannot change directory to /root added cut'n'paste from the linked source |
|
Apr 18 |
comment |
Oracle SQL, how to filter on a set by a rank? @haki, good to have you on the site, we need some more Oracle DBAs :) care to drop into The Heap to chat? I'd like to hear more about bugs in ANSI joins, and I've got some more examples where you need them :) |
|
Apr 17 |
comment |
How to check if Oracle DB process is running in Unix and where Oracle DB is installed @Yasir the OP created both on SO: this one was migreted from there too. |
|
Apr 16 |
comment |
SQL Server Alert - Description (None) Thanks a lot for posting your solution Brandon. It looks pretty specific to your setup, so I think it'd be best to close the post 'Too Localized' but don't take that as a sleight! |
|
Apr 16 |
revised |
How can I convert an Oracle dump file into SQL Server? appended answer 40088 as supplemental |
|
Apr 15 |
comment |
Approach for a 2,000 table migration Auto CW isn't the best feature of SE! Now I've removed it, it shouldn't come back no matter how many time you edit :) |
