We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
80,259 News Articles

Microsoft unveils SQL Server preview code

Community preview coming tomorrow

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 post. DBAs will gain a range of capabilities 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.

A limited preview of 'Project Gemini', which allows users to perform data analysis from within an Excel environment, will be available this year, Microsoft said Monday.

The company is also preparing to release a private technology preview of "Madison," its upcoming data warehousing platform, which incorporates technology Microsoft gained from its acquisition of DATAllegro last year.


IDG UK Sites

Best Christmas 2014 UK tech deals, Boxing Day 2014 UK tech deals & January sales 2015 UK tech...

IDG UK Sites

Apple's 2014 highlights: the most significant Apple news of 2014

IDG UK Sites

Watch this heartwarming Christmas short by Trunk for composer John Rutter

IDG UK Sites

Ultimate iOS 8 Tips: 35 awesome and advanced tips for using iOS 8 on iPhone and iPad