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

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 [zachman.com]. That […]

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

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