161 reputation
8
bio website farsightsoftware.com
location United Kingdom
age
visits member for 2 years, 1 month
seen Dec 12 at 19:04

I run Farsight Software, a software consulting firm. Good people, team approach, reasonable rates. Give us a shout on info@farsightsoftware.com.

I'm a software engineer with a particular interest in web technologies (esp. JavaScript). I also do lots of work in C#, Java, and several other languages. I've been doing this professionally for 20 some-odd years, goofing with computers for 10 years before that, but I hope I'm not this guy.

On occasion, I write up snippets of nifty tricks or techniques in my anemic little blog.


Dec
12
revised How to export an image column to files in SQL Server?
Fix markdown, remove erroneous COMMITs
Dec
12
suggested approved edit on How to export an image column to files in SQL Server?
Nov
23
comment Professor told us to store serialized Java objects as blobs instead of defining relational tables
What you should do is ask the professor why he's claiming this is better, listen thoughtfully to the answer, counter with the arguments above, listen to his response, etc. Engage.
Sep
24
awarded  Autobiographer
Nov
20
comment Minimizing possible trigger impact
@db2: Standard edition. Specifically, SQL Server Standard Edition 2008 R2 (v10.50.4285.0) 64-bit.
Nov
19
comment Minimizing possible trigger impact
@JonSeigel: Well, the above is a form of CDC. Not the form I'd prefer, but lacking a means of uniquely identifying a row limits my options. :-) Can you expand on how you'd expect log shipping, database snapshots, or snapshot isolation to apply? Absolutely open to options. I just keep coming back to that unique row problem. The odds of all columns having exactly the same value across two valid rows is small, though. (None of the key columns, even combined, can be relied upon in that way.)
Nov
19
comment Minimizing possible trigger impact
@billinkc: We don't, and we ought to have had. The trigger has been in place a while and things have been fine. (There was an earlier version of it that did all its work in the trigger [no staging, no sproc]. That...wasn't fine. :-) ) We've identified what we think may be an issue with the 3rd party product and I'm trying to rule out the trigger as a potential cause (and just generally keep it as lean as possible).
Nov
19
asked Minimizing possible trigger impact
Jul
2
comment Find highest level of a hierarchical field: with vs without CTEs
@NickChammas: Yeah. I think I'd go for explanation up front, then code/examples at the end.
Jul
1
comment Find highest level of a hierarchical field: with vs without CTEs
@NickChammas: I don't know the standard of practice on dba.stackexchange.com, but doing that is not best practice on the Stack Exchange site I'm most familiar with (SO). The idea being that external links can rot (get modified, get removed -- even gists! -- etc.).
Dec
21
awarded  Citizen Patrol
Dec
21
awarded  Commentator
Dec
6
awarded  Self-Learner
Dec
6
awarded  Editor
Dec
6
comment Is there a major RDBMS that DOESN'T allow column name quoting/escaping?
@a_horse_with_no_name: Thanks, added! If you know of others as well, feel free to edit directly. :-)
Dec
6
revised Is there a major RDBMS that DOESN'T allow column name quoting/escaping?
add the engines a_horse_with_no_name mentioned
Dec
6
awarded  Teacher
Dec
6
answered Is there a major RDBMS that DOESN'T allow column name quoting/escaping?
Dec
5
comment Is there a major RDBMS that DOESN'T allow column name quoting/escaping?
Side note: Whoever migrated this from StackOverflow, they shouldn't have. This isn't a DBA thing. I need to know, for programming purposes, whether I can allow user-defined column names to have values that need to be escaped, and have that be broadly-compatible with various engines.
Dec
4
comment Is there a major RDBMS that DOESN'T allow column name quoting/escaping?
@MartinSmith: Presuming, of course, that engines follow the spec. Which seems quite a large presumption.