Excel AND SQL Server 2008 have some new tricks coming in the MS SQL Server 2008 R2 release. PowerPivot, a new feature, allows power users to work in DB environments and create sharable, live-connected data views in Excel. An excellent way to create toolsets that are constantly updated and need distribution. Jason Brooks breaks it down for you in his latest article on eWeek.With the
late April release of its SQL Server 2008 R2, Microsoft has extended its
popular database server product with core platform enhancements, new management
capabilities and a raft of features focused on enabling self-service business
intelligence scenarios.
On the self-service BI front, SQL Server 2008 R2 relies heavily on integration
with Office 2010 and SharePoint Server 2010, which eWEEK Labs reviewed in our
June 7 and May 17 issues, respectively. As a result, the new release should pay
the biggest dividends to organizations that have deployed all three products.
On its own, the new SQL Server release still packs some worthwhile
improvements, particularly at sites running the database on large machines that
can take advantage of the new version's support for 256 logical processors.
Organizations running SQL Server on Microsoft's Hyper-V virtalization platform
should appreciate the product's new support for live migration between Hyper-V
hosts.
To read the original eWeek article, click here: SQL Server 2008 R2 Offers Enhancements, New Management Capabilities