5 things we love about SQL Server 2008 R2

New features bring business intelligence to the end user


Microsoft's SQL Server 2008 R2 is tightly integrated with other Microsoft applications like SharePoint and Office to allow users to access database applications via familiar interfaces like Excel.

Master Data Services

Master Data Services is a new and powerful feature designed to help an organization create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized and aligned. This ensures that different databases are interoperable.


PowerPivot allows end users to import, manipulate, analyze and export data, as well as create reports, all using the familiar Excel interface and language.

Management Studio

Management Studio is the primary management interface for configuring, managing, and administering all components within Microsoft SQL Server. It includes both script editors and graphical tools.

Report Builder

Report Builder 3.0 offers beefed up features that allow power users to create reports that combine business information with maps.

start menu

The start menu allows administrators to control a variety of Microsoft applications from one screen – including SharePoint, SQL Server, Office and Visual Studio.

Related stories:

Review: Microsoft SQL Server R2

Why SQL Server 2008 R2 matters to small business

Microsoft unleashes long-awaited SQL 2008 update