Here is another “Back to Basics” post to help establish, explain and document a baseline architecture for web applications. The modern web is filled with phenonmenal opportunities and following a few basic engineering priciples goes a long way to keep things moving forward in a positive direction. By design, a web user agent (e.g. a […]

In my daily work I am often called in as a “terminator” for tough problems that cannot be resolved through normal support channels. Not long ago I was tasked to figure out why a custom SharePoint 2010 Feature was failing to activate on a production farm. Using SharePoint Features [microsoft.com] is an awesome way to […]

I am happy to have finished the migration to a new WordPress platform. It is time for a break w00t!!!! Thanks for all the good words and encouragement so far. Enjoy the summer season!

Out of the box, the SharePoint 2010 includes an awesome Spell Check feature for Publishing sites. But if you have a UserField on your Layout page, it will also spell check hidden XML codes used by the People Picker control and report dozens of invisible errors. As of this posting, I know of no supported […]

Most database designs can also provide a quick answer to questions of the form: “What information do I currently have right now about last week ?” However, historic questions like “What information did I have at the time last week about last week ?” are not often not as easy to answer. Using time as […]

E.F. (“Ted”) Codd conceived of his relational model for databases while working at IBM in 1969. Codd’s approach took a cue from first-order predicate logic, the basis of a large number of other mathematical systems, and was presented in terms of set theory leaving physical representation and access implementer-defined. In June of 1970, Codd laid […]

Here is stripped down T-Sql code that illustrates a “no dynamic sql” approach to the common requirement for SQL Server stored procedures to accept comma delimited ID values while maintaining strong types. SQL Server @TableVariables are more efficient than regular temp tables and enhance the performance and scalability of this technique. However @TableVariables are _NOT_ […]