Microsoft announced on Wednesday that the MSDN subscribers will have SQL Server 2008 R2’s finalized version on 3 May and the general download starts on 13 May. It
comes with a set of BI (business intelligence) capabilities. Previously it is known as Kilimanjaro and it will be released in the 1st half of this year.
Ted Kummert, vice-president said that the customers can create more data and they continue to receive data due to the impact of the information in their social lives and
business. Our main aim is to help the customers extract business insight and value from that information. The information may be stored in the cloud, datacenter or in their PC.
Microsoft’s report says, community technology review has been downloaded for more than 300,000 times and it was released to the developers in the month of August.
The RTM (release-to-manufacturing) version of this database product includes many new features that are designed to reduce the costs of running this database product in
enterprise environments. For instance, the database administrators can manage multiple SQL server databases with the help of the new centralized administration.
There is much support in this software for running it in Microsoft’s Hyper-V 2008 R2. The company says that there is full support for the Live Migration.
The significant change in this product is the addition of the self-service BI engine. The end-users can create and run reports without calling the database support staff.
Tom Casey, Microsoft BI’s general manager said that the new storage mode that is added in this product supports the in-memory analytics. Large amount of data can be fitted
into the RAM by applying the compaction and smart compression algorithms and also by working the in-memory.
Casey said that the data compression allows the queries to run at the speed of its bus.
To benefit from BI engine the users should have Office 2010 in every desktop for creating BI reports in Excel 2010. The users can get the solution quickly by the combination of
flexibility and responsiveness. It lets you to iterate quickly and work without constraint.