Also in the CTP are two new components, a master data management (MDM) platform that enables companies to integrate information from across multiple data sources in the network and create a single view of data such as customers, products or suppliers. Previously MDM was only available as a third-party add-on. The second component is StreamInsight, a complex event processing platform that lets companies or independent software vendors build applications that can process large numbers of events in real time.
Also part of the review is Application and Multi-Server Management, which enables central IT control of database infrastructure that includes applying policy, managing performance, moving workloads, and pinpointing problems. In addition, there is support for Windows Server 2008 R2 and Hyper-V.
The two highly scalable versions being offered alongside SQL Server 2008 R2 are Microsoft SQL Server 2008 R2 Datacenter and Microsoft SQL Server 2008 R2 Parallel Data Warehouse (formerly code-named Madison).
Parallel Data Warehouse is a massively parallel processing technology for high-end data warehousing and is designed to scale to petabytes and support high-speed queries. Microsoft is riding Parallel Data Warehouse into a highly competitive data warehousing battle that includes Teradata, Netezza, Oracle, HP, Sybase, Greenplum, IBM and others. The Parallel Data Warehouse version will be offered as an appliance on hardware from Bull, Dell, HP and IBM.
The Datacenter version aligns with the Datacenter version of Windows Server 2008 R2 and is designed to support large-scale applications. The platform provides support for up to 256 logical processors and unlimited virtualization.
Microsoft also is introducing version 2.0 of its SQL Server Fast Track Data Warehouse that includes 12 new reference architectures that feature updated configurations from Bull, Dell, and HP based on Intel and AMD processors. The architectures support up to 48 cores per server and up to 48 terabytes of data capacity.
IBM, which signed onto the program in February, will offer three reference configurations based on IBM's X series and Intel processors. Also, EMC will introduce Data Warehouse and BI services for Fast Track.
Follow John on Twitter: twitter.com/johnfontana