My manager approached me late today and told me that we have roughly 200 k in our budget for hardware and software licenses and upgrades for this year. He was looking for ideas on how to spend it. Whoo Hooo!
I've been brought on board at this company to design, from the ground up, a SQL Server data mart that will be used by our Analytics team. The data is all sourced in Teradata and I'll be using SSIS to pull it down and load the SQL database. The server itself is fairly robust ( I don't have all the specs in front of me but I think it has quad dual-core processors and 16 GB of RAM and 3 TB of SAN space). I am building the environment out in SQL Server 2005 and using SSAS and SSRS to provide the data to the analysts. I have a separate ETL server which hosts my SSIS instance and is used for scheduling and running all of our automated SSIS jobs. Our SSRS/web server is also on a separate box.
We are so much at the beginning of the process of building out this environment, I'm having a hard time thinking what else we could possibly need. I'd like to upgrade to SQL Server 2008, but we may not be able to yet because of corporate standards. We may add another 3 TB of disk space for roughly 40 k, and I'd like to beef up my ETL box a bit.
My question is, what would you do? Given the purpose and intent of this environment, what tools, hardware, or software would you like to have to do the job? What else should we consider for report rendering and delivery, or forecasting, or anything else that I just don't know about?
====================================================== Forum Etiquette: How to post data/code on a forum to get the best help
- by Jeff Moden