Microsoft sets SQL Server 2008 R2 preview
Microsoft Tuesday said it will make a preview of SQL Server 2008 R2 available this month that is features complete, including new business intelligence integration tools and master data management features.
15 amazing Web apps built in 48 hours
In addition, Microsoft said it will deliver two highly scalable editions of SQL Server 2008 R2 (formerly code-named Kilimanjaro) in the first half of 2010 when it ships the next version of the database server.
The announcements came at the annual Professional Association for SQL Server (PASS) Summit. The PASS group is an independent, not-for-profit association.
Microsoft is pushing SQL Server 2008 R2 as the opening salvo in its strategy to turn the database into an "information platform." The company says the platform will integrate structured and unstructured data from a variety of sources, including SharePoint Server.
"The R2 release is a down payment on the information platform," said Fausto Ibarra, director of product management, SQL Server.
The review will include SQL Server PowerPivot for Excel 2010 (formerly Gemini), an in-memory analytics tools that will link Excel, SharePoint Server and SQL Server.
Power Pivot is the heart of what Microsoft calls managed self-service business intelligence, which lets users build BI programs for the desktop in Excel that combine data from diverse sources, process it using in-memory analytics tools and publish the results to SharePoint Server so users can collaborate around the results. In addition, IT can manage and control the BI programs users create by ensuring the proper infrastructure is available along with services such as data refresh.
"They are using and reading the meta-data from at least one other enterprise class information provider, which is SharePoint, and that is a big deal," says Mark Beyer, an analyst with Gartner. "Trying to put together text and content with the more structured stuff has been one of the challenges to getting real information management in an organization; to getting real data integration at the meta-data level."
What Microsoft is doing is significant in the aggregate because it elegantly combines data from two different sources, Beyer says.
Sign up for ITworld's Daily newsletter
Follow ITworld on Twitter @IT_world
On Twitter now
Network World
Powered by Twitter
Esther Schindler
If the comments are ugly, the code is ugly
claird
SVG a graphics format for 21st century
pasmith
Take Chrome OS for a test spin
Sandra Henry-Stocker
Solaris Tip: Have Your Files Changed Since Installation?
jfruh
Android fragments vs. the iPhone monolith
mikelgan
What Gizmodo missed about the Pro WX Wireless USB disk drive
Where Google Chrome security fails: the password
I heard mention that the Chrome OS will have some sort of encryption available a la bitlocker. If it's possible to encrypt personal data using another password or key, then it may have potential for very secure data.... And Ubuntu has an 'encrypt home directory' option, perhaps google should follow suit.
- Dann
Join the conversation here
Quick, practical advice for IT pros. Made fresh daily.
Want to cash in on your IT savvy? Send your tip to tips@itworld.com. If we post it, we'll send you a $25 Amazon e-gift card.
