Category Archives: Enterprise Software

Some Thoughts on Software Design and Maintenance

There is a definite Art in Computer Programming [pragprog.com] shaped by the Structure and Interpretation of Computer Programs [mit.edu]. From a technical pespective, Refactoring [refactoring.com] is the essential technique to incrementally remove harmful code patterns such as the Go To Statement [c2.com] and other AntiPatterns [antipatterns.com] such as the Big Ball of Mud [laputan.org]. Following […]

Sharepoint 2010 Error Page Customization

Planning for Monitoring SharePoint 2010 is a key component of any enterprise installation. Micorosoft’s free (but unsupported and no longer available as an official download 🙂 ULS Viewer is an amazing tool to provide insights into the inner workings of the platform. However it can be difficult to distinguish which errors are actually show stoppers […]

Time After Time: Sql Server Audit Triggers and Query Syntax

In the last post Time After Time: Creating a Valid Time Sql Audit Table, we created the basic data structures required for the audit tables. To complete the solution, we are now ready to create an audit trigger that will populate the audit_Orders history table every time the main Orders table is modified and discuss […]

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

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