1.
Data Glass: Logical Data Modeling: An Introduction
Mar 11, 2006 ... Logical Data Modeling: An Introduction. Data Modeling In General ... business entities and relationships between them in a detailed model. ...
2.
Data Glass: Free Code: Stored Procedure Code Generator
Nov 5, 2007 ... You will find that 80% of all stored procedures in a transaction database are all very predictable and can be auto generated. Using a code ...
3.
Data Glass: Free Code: Audit Tables and Change Control
Free Code: Audit Tables and Change Control ... Audit tables and sprocs are all in the same database as the tables being audited. ...
4.
Data Glass: How To: Delete Duplicate Data (DeDup)
Then when you bulk copy or insert data into the table, SQL quickly ingores the ... very good post! most elegant dedup solution i've ever seen. thank you. ...
5.
Data Glass: How To: Delete Duplicate Data (DeDup)
How To: Delete Duplicate Data (DeDup). ETL processes typically will run across the need to delete duplicate records. The fastest and simplist way I know of ...
6.
Data Glass: Logical Data Modeling: An Introduction
Mar 11, 2006 ... I found it worthy to note that the purpose of creating a normalized logical data model is to accurately document the business entities and ...
7.
Data Glass: Meta Data VS. Meta Model VS. Data Repository
I have several comments about Meta Data Models in previous postings. And its to this particular definition of which I speak of. Definition: Data Repository ...
8.
Data Glass: Free Code: Audit Tables and Change Control
Each table has a corrisponding history table and trigger to audit a table. Feature List: ... Auto Generates the "Audit Table" for tables being audited. ...
9.
Data Glass: Logical Data Modeling: An Introduction
Mar 11, 2006 ... I found it worthy to note that the purpose of creating a normalized logical data model is to accurately document the business entities and ...
10.
Data Glass: Model Design Patterns For: Document Management System
The design pattern below will cover a simplified contract management model that will track the work flow status of a contract and provide simple change ...