Choosing Microsoft SQL Server 2008 for Data Warehousing

The warehousing of corporate data into an architecture from which it can all be accessed is no longer an option for midmarket and large companies that want to be successful. Consolidating the information so that it is readily accessible, and to give the team visibility for reporting, analytics, spot queries, and predictive capabilities is now necessary. Fortunately, pioneers established this long ago and this requirement is met in the field of data warehousing (DW) and business intelligence (BI).
There is a lot more to achieving information access than simply copying data from one system to another. Data warehouses are now the major use of database management systems.
The data warehouse is not a new idea. Companies in every industry already use data warehouses to improve customer service, guide product development, reduce prices, shorten cycle times, and improve quality. Companies not yet using data warehousing to make better decisions are already behind. The more quickly they can implement a data warehouse, the more quickly they can overcome a competitive disadvantage.
Microsoft-based data warehouse can be implemented quickly and supports the analysis of data from many operational systems. The marketplace is aligning into complete frameworks and Microsoft brings all the necessary components to build, manage, and deliver data warehousing. In SQL Server, Microsoft has the fastest-growing data warehouse platform, with a comprehensive data movement platform, a manageable/scalable DBMS, and close integration with the Microsoft Office System.