Microsoft unveils preview code for next SQL Server

10.08.2009
Microsoft this week is giving developers an early peek at SQL Server 2008 R2, the next generation of its flagship database.

MSDN and TechNet subscribers got first dibs on Monday; the community technology preview (CTP) will be generally available Wednesday, Microsoft said.

SQL Server 2008 R2 will help DBAs manage large-scale deployments and promote self-service BI (business intelligence), wherein end-users generate their own queries and reports with less involvement needed from IT staff, according to Microsoft.

"New wizards enable administrators to quickly set up a multi-server management environment in minutes -- no professional services required," Microsoft promised in an official blog . DBAs will gain a range of for tracking their systems' resource usage and handling upgrades.

Meanwhile, a new version of Report Builder incorporates support for mapping data and "benefits power users that are looking for a more sophisticated authoring environment," the blog adds.

Overall, Microsoft is trying to push BI capabilities -- long the province of only some users due to the software's high cost -- to the masses, by tying them to its widely used SharePoint collaboration platform and venerable Excel spreadsheet.