Merrill Aldrich : dynamic sql

Trick Question – Part Två

merrillaldrich — Sun, 25 Oct 2009 01:58:00 GMT

This post is part two of an effort to examine, in brief, the decisions entailed in designing the interface between database and application. We’re in a strange place at this moment, where both the possibilities and the liabilities of techniques like ORM...(read more)

Worst possible SQL Server object name?

merrillaldrich — Mon, 19 Oct 2009 20:44:00 GMT

I currently test any dynamic sql I have to write against objects called Patt [Y.] O'Furniture It seems to catch the most obvious problems composing SQL on the fly, aside from name length. (Pity the person grappling with a 128 character object name!) What's...(read more)