SQL Server Performance Forum – Threads Archive
Developing Dataarehouse using SQL Server 2005
Hi Folks I have been asked for initial R&D on creating Data Warehouse using SQL Server 2005. It is BI system at some extend integration of CRM, Finance and Business process sections. It is purely fr reporting purpose. Could any one Please guide and suggest me how I should approach this matter. I mean guideness on data warehouse using SQL Server 2005 Analysis Services and Reporting Services. Please also refer to me subjective articles, literature, books, whitepapers… I would be great help as I want to be right approach and behavior towards this exercise.Thanks in advance
Please post the thread in relevant forums, moving from General DBA section. Refer to the Operations guid for SQL 2000 & 2005 Analysis Services that will give you more idea:http://sqlserver-qa.net/blogs/el/ar…-2005-analysis-services-operations-guide.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Accept my apology, but I was in impression that I shall added in this thread as this topic concern of DBA’task. shall I add under ‘SQL Server 2005 Analysis Services’ heading? Please suggest…
Thanks
Hey, no worries and appreciate your concern.
Welcome. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Check the following link for case study and peformance guide etc…. http://www.microsoft.com/sql/technologies/analysis/default.mspx
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>