Mark Eckeard (9/16/2012)
** 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.
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.
is pronounced ree-bar and is a Modenism for R
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs