During Oracle unveils plans based on MySQL for counter offers from Microsft in the management of databases, the latter announced a new version of its own solution: Microsoft SQL Server 2008 R2.
And the Redmond group looks forward to mark the spirits animating this output not less than 85 events in the world and launching a dedicated website , found after 300 000 downloads for pre-releases.
Among the new features of SQL Server 2008 R2 is the "concept of self-service business intelligence control" which is highlighted with a new tool PowerPivot, that aggregates data from multiple sources and manipulate large sets of data from outilsde Microsoft: Excel 2010 or SharePoint Server 2010.
Ready for the cloud and virtualisation
The new version is also more adapted to mounted loads in data centers, with support for systems with up to 256 logical processors and management of virtualized data centers Hyper-V ainsiq the management of migration dynamics ( Live Migration).
The SQL Server 2008 R2 Master Data Services to manage the consistency of data flow between disparate systems while SQL Server 2008 StreamInsight manages the flow of large events.
The appliance SQL Server 2008 R2 Parallel Data Warehouse, available soon, will also manage data warehouses "several hundreds of terabytes. This leads to the third major component of this new version: the integration of data center to the cloud, through Microsoft SQL Azure.
Again, technology will be central to PowerPivot data analysis and exploitation, while the various proposed by Microsoft bricks fit together with each other to form a coherent solution.