Hi all!
I need a bit of advise on what is generally best practice for building SQL BI environments. I have been tasked to do the architecture design for our new SQL 2012 BI environment but my manager and I seem to be having a difference of opinion on what will work best. I have suggested that we have a two server configuration in PROD, 1 SQL server hosts the staging and production DWs and the other server hosts SSAS and SSRS. He however suggests that we should host all on one server.
I would like to get your thoughts on what would be the better approach and also any links you could share that provides best practice for planning SQL BI environments.
Thanks