Data Warehousing

Microsoft, the leader in Data Warehousing (by number of customers) offers a family of solutions to manage your decision support data of all requirements, at any scale, with breakthrough performance and at a cost that is right for you.

  • Microsoft Data Warehousing lineup

    Whether your requirements include a traditional relational database management system or integration with non-relational sources like Hadoop or whether you need to gather insights from within familiar tools, Microsoft has a complete solution for you. Microsoft has been recognized by industry analysts like Gartner as being a leader for both Business Intelligence and in Data Warehousing.

    Data Warehousing solutions from Microsoft can handle your smallest to your largest data storage requirements while handling queries up to 100x faster than performance than your legacy data platform through massively parallel processing and in-memory technologies.

    Ideal for small to medium data warehouses, Microsoft SQL Server 2012 is a software solution allowing you to deploy on your own hardware configuration. Deployed by more customers than any other data warehouse technologies, customers trust Microsoft to run their most important workloads. SQL Server 2012 supports all data warehouse life cycle phases from cleansing and loading to analysis and reporting.

    Learn More

    Custom Tune Your Own Configuration

    • Deploy SQL Server 2012 software on your own hardware configuration.
    • Lowest cost option with nothing further to purchase.
    • Good for departmental solutions up to large deployments.
    • Unlock the widest pool of third party expertise and partners with SQL Server training.

    Microsoft was recently positioned as a Leader in the Magic Quadrant for Data Warehouse Database Management Systems that was published on January 31, 2013.

    Gartner Research
    2013 Magic Quadrant for Data Warehouse Database Management Systems

    “By migrating from Oracle to Microsoft, we reduced the number of different solutions and achieved a cleaner, simpler IT environment. Now, we have almost the same IT budget as in the early nineties, but with about 10 times as many users. And because the Microsoft environment is so intuitive and familiar to our employees, installation, development, and management are much faster and easier than before—and we have very satisfied users.”

    Staffan Zackrisson
    President and CEO, Volvo Aero

    Optimal for small to medium-sized data warehouses, SQL Server 2012 Fast Track is a reference architecture (RA) solution that gives you a step-by-step guide to build a data warehouse on hardware that has been pre-configured to support your data requirements. Due to the certification process, customers will receive a scale-up data warehouse tuned for optimal performance at a low entry cost.

    Learn More

    Eliminate deep expertise needed to optimally tune software and hardware

    • Utilize pre-tested best practices to build hardware.
    • Validated on industry standard hardware: HP, Dell, EMC, Cisco, IBM, XIO, Bull, Violin, Nimbus, Huawei and HDS.
    • Options include all-flash memory arrays for optimal performance.

    Microsoft was recently positioned as a Leader in the Magic Quadrant for Data Warehouse Database Management Systems that was published on January 31, 2013.

    Gartner Research
    2013 Magic Quadrant for Data Warehouse Database Management Systems

    “Universal Music Group (UMG) sought a database that could scale with growth, cut costs, and speed performance. In 2010, UMG replaced an IBM DB2 data warehouse with one based on the Microsoft platform. As a result, UMG saved more than U.S.$1 million, sped reporting up to 92 percent, and has experienced 100 percent uptime. It expects to save more money by moving a global data warehouse from Oracle to Microsoft.”

    Rajesh Babu
    Senior Director Global Business Intelligence, UMG

    First in class for medium to the largest data warehouses, Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW) is a massively parallel processing appliance that has evolved to handle the world of “Big Data” addressing both requirements of any data volume (from the smallest to the largest) as well as variety and velocity by providing seamless integration with Hadoop. Simple to deploy, SQL Server PDW is delivered as a pre-built, pre-optimized, and pre-installed system from HP and Dell.

    Learn more about PDW


    Microsoft also offers the Dell Quickstart appliances for small to medium size businesses that require data warehouses with smaller workloads.

    "During the proof of concept, basic queries that previously took 20 minutes only took seconds using the SQL Server 2008 R2 Parallel Data Warehouse. This solution dramatically improves our query performance and nightly processing times."

    Tom Settle
    Assistant Vice President Data Warehousing, Hy-Vee

    See case studies of our other PDW customers:

    Microsoft was recently positioned as a Leader in the Magic Quadrant for Data Warehouse Database Management Systems that was published on January 31, 2013.

    Gartner Research
    2013 Magic Quadrant for Data Warehouse
    Database Management Systems