Monthly Archives: June 2012

SharePoint 2010 Fix for Spell Check of Publishing Site UserField Using JQuery

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 […]

Time After Time: Temporal Modeling for Sql Audits and Historic Views

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 […]

On Relations and Relationships: Sql and the Rise Of Relational Database Technology

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 […]

Dynamic IN without Dynamic T-Sql for Sql Server

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_ […]

Basic Guidelines for Data Integrity in Enterprise Software

The original Relational Model of Data for Large Shared Data Banks [acm.org] was a major milestone in the history of information technology that has undergone changes in understanding over the years. Despite the fact There is No Database Magic [kimballgroup.com], A Review of Relational Concepts [wikipedia.org] is useful to avoid widespread Logical-Physical Confusion [information-management.com]. That […]

1 Click DB: Open Source Web Database Administration Using Active Server Pages

1 Click DB web enables basic Browse-Search-Export-Add-Edit-Delete and Database Administration features for Microsoft Access, Sql Server and Oracle databases. This popular open source software first debuted in 1998 authored by David Kawliche using ASP (Active Server Page) technology. Currently there is no formal technical support for the scripts, they still seem to work fine “out […]

Hello world!

Welcome to the new RestfulDevelopment.net website. This is my place on the net to share knowledge about web, database, and enterprise software. In my day to day work with technology, I have found there is No Silver Bullet [ac.uk] to the essential difficulties of software development. Essential best practices are situational and defined by context. […]