Building a Raw Data Warehouse in SQL Server 2005

I’m working on a project where we have to load over 700GB of raw data into a Data Warehouse to provide querying and analytics to the business unit. The choice was made to build this DW on an SQL Server 2005 3-node cluster with a 6TB network attached SAN. (The excess disk space was purchased in order to support ~1GB of nightly loads and 3 years of growth. I’ll cover more on that later.)

Collection of Professional SQL Server experiences

There are many blogs out there with great information on Microsoft’s SQL Server product.

While some offer small, short posts with great advice like Pinal’s blog:

- http://blog.sqlauthority.com/

others go really deep into the theory and internals of SQL Server like Bob’s and Kalen’s:

- http://www.sqlskills.com/blogs/bobb