Looking for good books/resources for SQL 2k8 data warehouse

Question

Looking for good books/resources for SQL 2k8 data warehouse

Mark Eckeard

Hall of Fame

Points: 3462
More actions
September 16, 2012 at 9:37 am

#267773

All,
** I think this is the appropriate forum but please let me know if not and I'll move it **
My company is beginning to discuss setting up a data warehouse so we can do reporting from our numerous sources. Since I'd like to get a head start, I figured I'd ask if anyone had a good book or resource for this.
We'll be using SQL 2k8 R2 pulling data from the production databases to the BI/DW/whatever-its-called server where the reports will run.
Thanks,
Mark

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLmountain SSCommitted Points: 1505 More actions · Answer 1

If you are not already aware of it, a good read on the subject of ETL can be found in the "Stairway" section on this website. Look for "Stairway to SSIS" and so forth.

And don't forget to check Books Online.

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 2

Mark Eckeard (9/16/2012)
All,
** I think this is the appropriate forum but please let me know if not and I'll move it **
My company is beginning to discuss setting up a data warehouse so we can do reporting from our numerous sources. Since I'd like to get a head start, I figured I'd ask if anyone had a good book or resource for this.
We'll be using SQL 2k8 R2 pulling data from the production databases to the BI/DW/whatever-its-called server where the reports will run.
Thanks,
Mark

Depending on the condition of the database, you might not need to go through the rigors of setting up a a data warehouse. Just write some good reporting code.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jason-299789 SSC-Insane Points: 21601 More actions · Answer 3

If you're new to data warehousing then books by Ralph Kimball (Data Warehousing Toolkit series by Wiley) and Bill inmon are good reads, though a little dry, but good for general design principles, as well as planning the implementation

One of the best books I've read was : "Building a Data Warehouse With Examples In SQL Server" by Vincent Rainardi (Apress Publication) is worth picking up, its not as dry as the Kimball/Inmon books, and delves more in to the architecture side of DW's.

For the ETL (extract Transform and Load) side of Joy Mundy does a good book which is part of the Data warehouse toolkit series.

Hope this helps.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

nick.mcdermaid Hall of Fame Points: 3809 More actions · Answer 4

so we can do reporting from our numerous sources

Consider whether you just want a more convenient place to perform system specific operational reporting, or whether you want to match and conform data across different systems, and thereby derive more enlightening KPI's (i.e. Department Cost from your Finance System / headcount from your HR system)

This might flush out some more specific requirements, and your data warehouse should be driven primarily by business requirements.