Besides its traditional relational database features, SQL
server 2005 extends its services to build data warehouse applications. This
article explains data modeling features provided by SQL Server 2005 by
exploring basic concepts like facts, dimensions, Surrogate Keys, etc.