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
78,821 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

Android One vs Android Silver vs Google Nexus: What is the difference?

IDG UK Sites

Apple updates MacBook Pro line-up: Price cuts & spec boosts for 6 MacBook Pro models

IDG UK Sites

Long live the internet fridge: the Internet of Things is coming

IDG UK Sites

How Prometheus' colourist Juan Ignacio Cabrera gave a tense, edgy feel to Chosen