Microsoft Deploys Innovative Solution That Reports Near-Real-Time Data. A SQL Server Business Case Study

Microsoft IT Showcase is pleased to announce the publication of Microsoft Deploys Innovative Solution That Reports Near-Real-Time Data.

Always looking for ways to improve efficiency, Microsoft wanted its executives and finance managers to be able to create near-real-time operating reports. The company also sought to increase system availability and cut costs. In 2011, Microsoft deployed a mission-critical reporting solution that uses high-availability features in Microsoft SQL Server 2008 R2 to move data between online transaction processing systems, data marts, and a reporting server—instead of using the traditional extract, transform, and load operations. The highly scalable solution also splits each 250-gigabyte data mart based on the age of information. As a result, data marts are updated every 7 minutes so that users can create accurate reports around the clock. The company has also increased data availability, reduced server footprint by 72 percent, sped system performance, and improved agility.
Business Case Study

Products & Technologies

· Microsoft SQL Server 2008 R2 Enterprise

· Windows Server 2008 R2 Enterprise