ARN

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.

Nominations for the 2012 ARN IT Industry Awards open on Tuesday, June 12.

More about: Excel, Microsoft
References show all

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Users posting comments agree to the ARN comments policy.
Login or register to link comments to your user profile, or you may also post a comment without being logged in.
Related Coverage
Related Whitepapers
Latest Stories
Community Comments
Tags: Microsoft, sql server 2008
ARN Directory | Distributors relevant to this article
ASI Solutions , Bluechip Infotech , Compucon Computers , Dicker Data , Express Data , Express Online , ICT Distribution , Impact Systems Technology , Leader Computers , NewLease , Synnex Australia , Topstar Computer International , XiT Distribution , Xpress I.T.
rhs_login_lockGet exclusive access to ARN's news, research and invitation only events.
ARN Distributor Directory
Find distributors by name | vendor | location
Channel Deals
/deals/aca-pacific/441_tape-media-and-imation-dataguard-t5r-reseller-
ACA Pacific

Tape Media and Imation DataGuard T5R Reseller Promotion. Ends June 30, 2012

More details »
ARN Vendor Directory
Find vendors by name | category

iAsset is a channel management ecosystem that automates all major aspects of the entire sales,marketing and service process, including data tracking, integrated learning, knowledge management and product lifecycle management.