Microsoft SQL Server 2008

What's New in SQL Server 2008 R2 Editions

Built on SQL Server 2008, SQL Server 2008 R2 delivers higher mission-critical scale, more efficient IT, and expanded reporting and analytics through self-service business intelligence. SQL Server 2008 R2 introduces two new premium editions to meet the needs of large scale datacenters and data warehouses. SQL Server 2008 R2 Datacenter Edition and SQL Server 2008 R2 Parallel Data Warehouse Edition

New Premium Editions

Datacenter

Built on SQL Server 2008 R2 Enterprise, SQL Server 2008 R2 Datacenter is designed to deliver a high-performing data platform that provides the highest levels of scalability for large application workloads, virtualisation and consolidation, and management for an organisation's database infrastructure. Datacenter helps enable organisations to cost effectively scale their mission-critical environment.

Key features new to Datacenter:

• Application and Multi-Server Management for enrolling, gaining insights and managing over 25 instances
• Highest virtualisation support for maximum ROI on consolidation and virtualisation
• High-scale complex event processing with SQL Server StreamInsight
• Supports more than 8 processors and up to 256 logical processors for highest levels of scale
• Supports memory limits up to OS maximum

Parallel Data Warehouse

SQL Server 2008 R2 Parallel Data Warehouse is a highly scalable data warehouse appliance-based solution. Parallel Data Warehouse delivers performance at low cost through a massively parallel processing (MPP) architecture and compatibility with hardware partners - scale your data warehouse to tens and hundreds of terabytes.

Key features new to Parallel Data Warehouse:

• 10s to 100s TBs enabled by MPP architecture
• Advanced data warehousing capabilities like Star Join Queries and Change Data Capture
• Integration with SSIS, SSRS, and SSAS
• Supports industry standard data warehousing hub and spoke architecture and parallel database copy

Investments in Core Editions

• SQL Server 2008 R2 Enterprise delivers a comprehensive data platform that provides built-in security, availability, and scale coupled with robust business intelligence offerings - helping enable the highest service levels for mission-critical workloads.
• The following capabilities are new to Enterprise:
  • PowerPivot for SharePoint to support the hosting and management of PowerPivot applications in SharePoint
  • Application and Multi-Server Management for enrolling, gaining insights and managing up to 25 instances
  • Master Data Services for data consistency across heterogeneous systems
  • Data Compression now enabled with UCS-2 Unicode support

More information on SQL Server 2008 R2 can be found at http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx

find out more

Contact your Phoenix Account Manager about upgrading on 0845 265 1265 or email info@phoenixs.co.uk