Microsoft sets SQL Server 2008 R2 preview

Microsoft said it will make a preview of SQL Server 2008 R2 available this month

Microsoft said it will make a preview of SQL Server 2008 R2 available this month that is features complete, including new business intelligence integration tools and master data management features.

In addition, Microsoft said it will deliver two highly scalable editions of SQL Server 2008 R2 (formerly code-named Kilimanjaro) in the first half of 2010 when it ships the next version of the database server.

The announcements came at the annual Professional Association for SQL Server (PASS) Summit. The PASS group is an independent, not-for-profit association.

Microsoft is pushing SQL Server 2008 R2 as the opening salvo in its strategy to turn the database into an "information platform." The company says the platform will integrate structured and unstructured data from a variety of sources, including SharePoint Server.

"The R2 release is a down payment on the information platform," said Fausto Ibarra, director of product management, SQL Server.

The review will include SQL Server PowerPivot for Excel 2010 (formerly Gemini), an in-memory analytics tools that will link Excel, SharePoint Server and SQL Server.

Power Pivot is the heart of what Microsoft calls managed self-service business intelligence, which lets users build BI programs for the desktop in Excel that combine data from diverse sources, process it using in-memory analytics tools and publish the results to SharePoint Server so users can collaborate around the results. In addition, IT can manage and control the BI programs users create by ensuring the proper infrastructure is available along with services such as data refresh.

"They are using and reading the meta-data from at least one other enterprise class information provider, which is SharePoint, and that is a big deal," says Mark Beyer, an analyst with Gartner. "Trying to put together text and content with the more structured stuff has been one of the challenges to getting real information management in an organization; to getting real data integration at the meta-data level."

What Microsoft is doing is significant in the aggregate because it elegantly combines data from two different sources, Beyer says.

"One of the constants I've had in my research is the pending earthquake of actually leveraging meta-data without having to import and export it from one place to another. That is where Microsoft is headed with its information management; reading through a service the meta-data in different enterprise applications that they have."

Beyer says the concept is one of data integration rather than interoperability. He says if Microsoft can create such an environment then the vendor will be one of the first to deliver such capabilities.

Also in the CTP are two new components, a master data management (MDM) platform that enables companies to integrate information from across multiple data sources in the network and create a single view of data such as customers, products or suppliers. Previously MDM was only available as a third-party add-on. The second component is StreamInsight, a complex event processing platform that lets companies or independent software vendors build applications that can process large numbers of events in real-time.

Also part of the review is Application and Multi-Server Management, which enables central IT control of database infrastructure that includes applying policy, managing performance, moving workloads and pinpointing problems. In addition, there is support for Windows Server 2008 R2 and Hyper-V.

The two highly scalable versions being offered alongside SQL Server 2008 R2 are Microsoft SQL Server 2008 R2 Datacenter and Microsoft SQL Server 2008 R2 Parallel Data Warehouse (formerly code-named Madison).

Parallel Data Warehouse is a massively parallel processing technology for high-end data warehousing and is designed to scale to petabytes and support high-speed queries.

Microsoft is riding Parallel Data Warehouse into a highly competitive data warehousing battle that includes Teradata, Netezza, Oracle, HP, Sybase, Greenplum, IBM and others.

The Parallel Data Warehouse version will be offered as an appliance on hardware from Bull, Dell, HP and IBM.

The Datacenter version aligns with the Datacenter version of Windows Server 2008 R2 and is designed to support large-scale applications. The platform provides support for up to 256 logical processors and unlimited virtualization.

Microsoft also is introducing version 2.0 of its SQL Server Fast Track Data Warehouse that includes 12 new reference architectures that feature updated configurations from Bull, Dell and HP based on Intel and AMD processors. The architectures support up to 48 cores per server and up to 48 terabytes of data capacity.

IBM, which signed onto the program in February, will offer three reference configurations based on IBM's X series and Intel processors. Also, EMC will introduce Data Warehouse and BI services for Fast Track.

Join the Good Gear Guide newsletter!

Error: Please check your email address.

Tags Microsoftsql server 2008

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

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

John Fontana

Network World
Show Comments

Essentials

Lexar® JumpDrive® S57 USB 3.0 flash drive

Learn more >

Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop

Learn more >

Mobile

Lexar® JumpDrive® S45 USB 3.0 flash drive 

Learn more >

Exec

HD Pan/Tilt Wi-Fi Camera with Night Vision NC450

Learn more >

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

Learn more >

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards 

Learn more >

Budget

Back To Business Guide

Click for more ›

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?