Data Warehousing

Technical Article

Kimball University: Five Alternatives for Better Employee Dimension Modeling

  • Article

The employee dimension presents one of the trickier challenges in data warehouse modeling. These five approaches ease the complication of designing and maintaining a 'Reports To' hierarchy for ever-changing reporting relationships and organizational structures.

You rated this post out of 5. Change rating

2009-08-26

3,651 reads

Technical Article

Introduction to Fast Track Data Warehouse Architectures

  • Article

This paper provides an overview and guide to SQL Server® Fast Track Data Warehouse, a new set of reference architectures created for scale-up (SMP) SQL Server based data warehouse solutions. It includes a summary of the resources available in the reference configuration, the distinguishing features of the approach, and the steps necessary to take full advantage of the new architectures.

2009-06-26

4,002 reads

Blogs

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Humble Bundle of Java Books

By

I try to keep an eye on the Humble Bundle bundles for books. The...

Read the latest Blogs

Forums

Restore

By mtz676

DECLARE @FilesCmdshell TABLE ( outputCmd NVARCHAR (255) ) DECLARE @FilesCmdshellCursor CURSOR DECLARE @FilesCmdshellOutputCmd AS...

Query Execution Modes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Query Execution Modes

The Art of the Code Review

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Art of the Code...

Visit the forum

Question of the Day

Query Execution Modes

What are the two distinct processing modes that the SQL Server Database Engine can use to process T-SQL statements?

See possible answers