SQL Server 2008 R2 CTP is Feature-Complete -- Redmond Channel Partner

SQL Server 2008 R2 CTP is Feature-Complete

First release of Microsoft's flagship database in two years offers substantial scalability gains.

By Jeffrey Schwartz
November 29, 2009

The feature-complete preview of SQL Server 2008 R2, the first major upgrade of Microsoft's flagship database platform in nearly two years, is now available for partners to test.

It's on pace to ship in the first half of next year, Microsoft officials said at last month's annual Professional Association of SQL Server (PASS) Summit in Seattle.

Dubbed the November CTP of SQL Server 2008 R2, it introduces new self-service business intelligence (BI) capabilities. Microsoft said it's also adding two new SKUs, one edition called Datacenter and one named Parallel Data Warehouse. The two represent the most scalable database servers offered by Microsoft to date.

Viable Alternative
The new releases provide a stronger case for partners looking to offer SQL Server as a viable alternative for enterprise applications over database offerings from Oracle Corp. and IBM Corp. Microsoft remains the No. 3 database supplier in terms of share in the relational database server market, according to figures from analysts at Gartner Inc. for 2008. Although Microsoft's growth remained flat that year, growth for Oracle and IBM slipped a bit, says Gartner analyst Mark Beyer.

"Microsoft seems to be the one that's picking up those crumbs around the edges and growing their market share," Beyer says. "That's because it's low-cost and very simple and [has a] straightforward interface for managing data access."

SQL Server's New SKUs

When SQL Server 2008 R2 ships in the first half of next year, it will come in four editions.

Standard is for small organizations and departmental deployments. Per-processor pricing will be $7,500, or $1,000 per server plus $162 per client access license (CAL).
Enterprise consists of support for application and multi-server management for up to 25 instances. It will be priced at $28,800 per processor or $9,900 per server plus $162 per CAL.
Datacenter will scale to 256 logical processors or cores, a four-fold increase from the limit of the current edition of SQL Server.
Parallel Data Warehouse (formerly known as "Project Madison") will be Microsoft's highest-end implementation to date. Based on the technology it acquired from DATAllegro, the systems will be sold as appliances by partners IBM, HP, Bull and Dell, among others.

Datacenter Edition and Parallel Data Warehouse will cost $57,500 per processor. Those two SKUs will not be offered with a server and CAL combo.

Central Management
The November CTP of SQL Server 2008 R2 offers the first preview of Microsoft's new PowerPivot technology (formerly code-named "Project Gemini") and allows BI data collected from it to be shared to the company's SharePoint Server.

PowerPivot is designed to let business users create their own BI solutions in Excel with a new in-memory analysis engine that Microsoft says will work on millions of rows of data. "Users can manipulate the data in new ways to create BI solutions and then publish them to SharePoint to collaborate with other users," explains Fausto Ibarra, Microsoft's director of SQL Server product management.

Also in the CTP, partners will be able to test a new feature that makes it possible to centrally manage groups of SQL Server databases to monitor performance problems and move databases from one server to another.

The CTP also supports Hyper-V virtualization in Windows Server. "Specifically, we will be supporting live migrations to enable users who have virtual database workloads to seamlessly migrate them to other servers without any perceived downtime for their users," Ibarra says.

About the Author

Jeffrey Schwartz is editor of Redmond magazine and also covers cloud computing for Virtualization Review's Cloud Report. In addition, he writes the Channeling the Cloud column for Redmond Channel Partner. Follow him on Twitter @JeffreySchwartz.

Featured

Microsoft Dismantles RedVDS Cybercrime Marketplace Linked to $40M in Phishing Fraud

In a coordinated action spanning the United States and the United Kingdom, Microsoft’s Digital Crimes Unit (DCU) and international law enforcement collaborators have taken down RedVDS, a subscription based cybercrime platform tied to an estimated $40 million in fraud losses in the U.S. since March 2025.
CrowdStrike's Acquisition of SGNL Aims to Strengthen Identity Security

CrowdStrike signs definitive agreement to purchase SGNL, an identity security specialist, in a deal valued at about $740 million.
Microsoft Acquires Osmos, Automating Data Engineering inside Fabric

In a strategic move to reduce time-consuming manual data preparation, Microsoft has acquired Seattle-based startup Osmos, specializing in agentic AI for data engineering.
Linux Foundation Unites Major Tech Firms to Launch Agentic AI Foundation

The Linux Foundation today announced the creation of a new collaborative initiative — the Agentic AI Foundation (AAIF) — bringing together major AI and cloud players such as Microsoft, OpenAI, Anthropic and other major tech companies.