BT

What’s Next for SQL Server?

by Jonathan Allen on Aug 11, 2009 |

As we reported last year, SQL Server 2008 R2 will support 256 logical processors. Other features include better multi-server management tools and geospatial visualization in Reporting Services 3. A preview of the new version is available to MSDN and TechNet subscribers. The general public will have access later this month.

R2 offers several features targeted specifically at independent system vendors (ISVs):

ISVs will be able to pre-define templates for project Gemini. Gemini, which is being offered as part of Office 2010, appears to be an analytics engine for Excel. Microsoft claims that it can be used for “manipulating millions of rows of data into a single Excel workbook”.

They will also be able to pre-define SQL Server Reporting Services components. Details are currently light in both these areas; there are not any explanations as to how this differs from simply shipping these components separately.

Microsoft is also touting support for ATOM-based feeds. Given their repeated attempts to turn SQL Server into a web server, and the number of times they abandoned said features, developers should be leery of this offering.

On the consumer side, the feature list is far more promising. SQL Server will be able to use 256 logical processors, a big win for companies looking to scale up instead of out. For those who are scaling out, R2 promises to offer better management tools for working with multiple-servers.

For reporting, Report Builder 3.0 will come with support for geospatial visualization. Geospatial visualization allows map-based charts to be created from data. You can see a sample of geospatial visualization on SQL Server new blog.

Hello stranger!

You need to Register an InfoQ account or to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

More info by Robert MacLean

"Gemini, which is being offered as part of Office 2010, appears to be an analytics engine for Excel." - From what was displayed at Tech Ed Africa last week Gemini is a new front end for SQL Server Analysis Services built into everyones favorite CRM/Account/ERP/ToDo/Chart tool, Excel.

"They will also be able to pre-define SQL Server Reporting Services components. Details are currently light in both these areas" - Loads of info on the SRS side at: blogs.msdn.com/sqlrsteamblog/archive/2009/08/11...

"Microsoft is also touting support for ATOM-based feeds." - This appears to be for SRS, not for SQL Server proper (see link above). That makes a lot of sense and isn't something to be worried about. Agree, that if they are offering it for all of SQL Server it could be an issue.

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

1 Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2013 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT