Microsoft unleashes long-awaited SQL 2008 update

Microsoft's SQL 2008 R2, to be released next month, can support larger implementations

Microsoft has released to manufacturing Microsoft SQL Server 2008 R2, the new version of its relational database management system software, the company announced Wednesday.

The software, a major update of the SQL Server 2008 code base, has been in development for almost two years. Thus far, the developer version of the software has been downloaded more than 300,000 times, according to the company.

The R2 version updates the SQL Server 2008 in a number of ways, said Mark Linton, director within Microsoft's application platform group.

One notable feature is the scale. A single SQL Server 2008 instance can now be run on up to 256 logical processors. Previously, a SQL Server instance could only scale up to 64 logical processors. It will also run on as much as two terabytes of working memory. This will pave the way for more large scale, enterprise deployments, Linton said.

The software also has been updated to work better in Microsoft's Hyper-V virtualized environments. For instance, the virtualized instance of the software can be migrated from one server to another while continuing to run.

The software's administration software has been updated as well. A new feature, called Utility Control Point, enables database administrators to manage the policies of entire farms of SQL Servers from a single console. "Through one control point, you can administrator your entire infrastructure through a standardized set of policies and tools," Linton said.

The software also helps other Microsoft products in providing users with "self-service business intelligence," Linton said. The software can provide live data for a new Microsoft Excel data analysis add-on call PowerPivot, which was designed to manipulate "millions of rows of data" quickly.

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags Microsoftsql server 2008

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service
Show Comments

Father’s Day Gift Guide

Brand Post

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Luke Hill

MSI GT75 TITAN

I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Laura Johnston

MSI GS65 Stealth Thin

If you can afford the price tag, it is well worth the money. It out performs any other laptop I have tried for gaming, and the transportable design and incredible display also make it ideal for work.

Andrew Teoh

Brother MFC-L9570CDW Multifunction Printer

Touch screen visibility and operation was great and easy to navigate. Each menu and sub-menu was in an understandable order and category

Louise Coady

Brother MFC-L9570CDW Multifunction Printer

The printer was convenient, produced clear and vibrant images and was very easy to use

Edwina Hargreaves

WD My Cloud Home

I would recommend this device for families and small businesses who want one safe place to store all their important digital content and a way to easily share it with friends, family, business partners, or customers.

Featured Content

Product Launch Showcase

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?