Mission-Critical Operations

With four options to choose from, build enterprise-class data warehouses faster and scale up to hundreds of terabytes with SQL Server 2008 R2.

Choose from four offerings to meet any need

• Scale a data warehouse to 100s of terabytes with high performance through an integrated appliance with Parallel Data Warehouse.

• Take advantage of a highly scalable, software-only solution for data marts or midsized enterprise data warehouses on any hardware with Datacenter.

• Design a cost-effective, balanced system for data warehouse workloads with Fast Track Data Warehouse.

• Gain a comprehensive software-only platform that provides built-in security, availability, and scale coupled with robust BI offerings by choosing Enterprise.

Scale your data warehouse on SQL Server 2008 R2

• Grow your data warehouse from 1 gigabyte to 100s of terabytes with Enterprise, Datacenter, Fast Track Data Warehouse, or Parallel Data Warehouse, an MPP appliance that scales to 100s of terabytes.

• Choose the right solution for your needs, from software-only options, reference architectures, or fully integrated data warehouse appliances.

Build enterprise-class data warehouses faster

• Get a scalable pipeline architecture that provides a multithreaded, 64-bit platform to transform growing data volumes in narrower batch windows.

• Connect to non-SQL Server, RDBMS, mainframe, and ERP systems.

• Use built-in transformations to consolidate data from numerous systems, reduce duplication, and cleanse dirty data.

Get breakthrough performance and scalability on one integrated platform, with low total-cost-of-ownership.

Get more for your money, with integrated tools at no additional charge

• Take advantage of integrated BI, ETL, and data warehouse tools that ship out-of-the-box with SQL Server 2008 R2 at no additional cost.

• Maintain for data consistency across heterogeneous systems with Master Data Services.

• Develop and deploy CEP applications with StreamInsight, a high-throughput, stream-processing architecture and Microsoft .NET-based development platform.

• Enable users to transform data into meaningful information using PowerPivot for Excel and share with PowerPivot for SharePoint.

Cut storage costs

• Reduce the size of tables and indexes by using data compression.

• Use less device input/output and increase backup speed significantly with backup compression.

• Reduce storage costs through balanced configurations for Fast Track Data Warehouse that use fewer disks than traditional data warehouses.

Lower acquisition cost

• Spend less to buy a database solution by choosing the only major database vendor that does not price per core for multicore processors.

• Improve performance at a lower price per terabyte.

Lower hardware costs

• Scale from small to very large data warehouses, running on hardware with up to and including large SMPs with up to 64 cores.

• Add more hardware to scale very large workloads.

• Take advantage of industry-standard hardware in Fast Track Data Warehouse and Parallel Data Warehouse.

Run the most demanding mission-critical applications, reduce time and cost of development and management of applications, and deliver actionable insight to your entire organization.

Support for traditional EDW and distributed architectures

• Relieve traditional barriers to hub-and-spoke with the new, fast publishing capability in Parallel Data Warehouse.

• Integrate with existing SQL Server 2008 data warehouses.

• Take advantage of hardware choice with Fast Track Data Warehouse and Parallel Data Warehouse configurations from HP, Dell, IBM, and Bull. Enterprise and Datacenter editions run on any hardware.

Reduce risk

• Use redundant, industry-standard hardware of your choice.

• Enjoy predictable performance delivery through balanced reference architectures for Fast Track Data Warehouse and Parallel Data Warehouse.

Lower administrative burden

• Select the industry-standard hardware that you want, and avoid the need for training on proprietary systems.

Choose from reliable options

• Simplify medium-to-large workloads, with preconfigured Fast Track Data Warehouse reference architectures.

• Maximize hardware utilization with balanced architectures on Fast Track Data Warehouse and Parallel Data Warehouse.

• Scale your infrastructure for large application workloads, virtualization, and consolidation with Datacenter.

Get an information platform that provides a complete set of enterprise-ready technologies to help you realize more value from your information, spanning across desktops, data marts, and databases.

Make actionable intelligence accessible to all employees

• Empower employees to do powerful analytics in Microsoft Excel using PowerPivot.

• Integrate seamlessly with other Microsoft BI products by using Microsoft Office PerformancePoint Server.

• Immediately start building reports of any size or complexity with Reporting Services.

• Take advantage of advanced complex event processing with StreamInsight.

• Expose reports to information workers through Microsoft SharePoint Server 2010.

• Provide ad-hoc reporting capabilities for power users through Report Builder.

• Create, edit, and update master data, including members and hierarchies with Master Data Services.

Get the most compelling desktop tools

• Quickly transform huge quantities of data into meaningful information by using familiar Excel software with PowerPivot.

• Use workbooks as data sources for reports with Analysis Services for SharePoint Server 2010.