Servers

    Microsoft Deploys Innovative Solution That Reports Near-Real-Time Data

    Language:
    English
    Content current as of June 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.
    • Version:

      1

      File Name:

      665NearRealTimeSQLReportingBCS.docx

      Date Published:

      11/9/2014

      File Size:

      356 KB

        Content current as of June 2011. The following content may no longer reflect Microsoft’s current position or infrastructure. This content should be viewed as reference documentation only, to inform IT business decisions within your own company or organization.

        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.
    • Supported Operating System

      Windows Server 2008 R2

    Popular downloads

      • 01

        Microsoft® SQL Server® 2012 Express

        Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 03

        Microsoft Power Query for Excel

        Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

      • 04

        Microsoft® SQL Server® 2008 Management Studio Express

        Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

      • 05

        Microsoft® SQL Server® 2014 Express

        Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial