Software

Microsoft SQL Server 2012 deploys a full data warehouse or data mart solution on your own hardware and custom configuration of choice.

  • Fast Track for SQL Server 2012

    Ideal for small to large data warehouses or for data marts, Microsoft SQL Server 2012 is a software solution allowing you to deploy on your own hardware configuration. SQL Server 2012 includes the capabilities to run your data from cleansing and loading to analysis and reporting.

    What's New in SQL Server 2012

    • xVelocity memory optimized ColumnStore index improves data warehouse query performance 10x-100x over traditional rowstore query performance.
    • Up to 15x data compression on tables with a ColumnStore index reduces data storage and improves in-memory performance.
    • Support for up to 15K partitions per table provides plenty of partitions to simplify data loading and maintenance operations.
    • Support for up to 256 logical cores enables high-performance for mixed workloads with multiple queries running concurrently.

    Key Capabilities

    • Use Industry Standard Data Warehouse Design Principles

      SQL Server 2012 supports industry standard data warehousing design principles. For example, you can implement:

      • A Kimball data warehouse with star schema optimizations to speed up queries against fact and dimension tables.
      • An Inmon normalized data warehouse.

    • Ships With Integrated ETL Tools that Extract, Transform, Load, Cleanse, and Manage Data

      SQL Server 2012’s integrated tools perform sophisticated data warehouse ETL operations such as merging, time/date stamping, de-duplication, data type conversion, normalization, surrogate key insertion, and other cleansing operations necessary for managing data in a typical data warehouse. For example, in SQL Server 2012:

      • Integration Services will extract, transform, and load virtually any type of data.
      • Master Data Services provides an authoritative data source so that your data has integrity and consistency when accessed by multiple applications.
      • Data Quality Services will cleanse, match, standardize, and enrich your data so that you can trust the quality of the data in your data warehouse.

    • Optimizes Query Performance and Resource Management

      SQL Server 2012 optimizes performance and resource management according to your organizational priorities. For example, administrators can use:

      • The xVelocity memory-optimized columnstore index to achieve a quantum speed up for data warehouse queries.
      • Resource governance to reserve resources for data loading and to prevent runaway queries.
      • Data compression to reduce data volume and to speed up data warehouse queries.
      • Partitioning to apply maintenance operations on a partition-by-partition basis rather than on the entire table.

    • Empower End Users to Make Business Decisions From Their Data

      Microsoft uniquely ships major components of an integrated BI solution with our data warehousing offerings out-of-the-box. Overcoming the traditional BI challenges of low user adoption due to the complexity and costs, Microsoft SQL Server Data Warehousing also leverages Office and SharePoint to empower business users with familiar interfaces opening up complex data analysis to everyone.

      • SQL Server Reporting Services provides operational production reporting.
      • SQL Server Analysis Services provides the most popular and robust OLAP cube to do complex analysis.
      • Microsoft Office gives end users the ability to create their own dashboards and analysis in the familiar user interface they already use daily.
      • Microsoft SharePoint allows end users to centrally manage their BI content and gives IT the ability to retain oversight.

    Related Solutions

    "Changing the database structure to support xVelocity (memory optimized ColumnStore index) only took us about 30 minutes. (Now) the large report that used to take 17 minutes to render now takes only three seconds."

    Wolfgang Kutschera
    bwin.party

    xVelocity Speeds Up Data Warehousing

    xVelocity memory optimized ColumnStore index enables you to achieve break-through speed ups for common data warehouse queries.

    Resources