Microsoft SQL Server 2008 R2 Features and Review

This article explains Microsoft SQL Server 2008 R2 which is builds around SQL Server 2008 and focused more on Business Intelligence, Multi-server management and Data Services.

SQL Server 2008 R2

SQL Server 2008 R2 builds on the SQL Server 2008 and it includes all the patch releases on SQL Server 2008 and more new features are also included. SQL Server 2008 R2 more focused on the self service Business Intelligence (BI), Data Services, supports up to 8 processor and 256 logical processors, improved multi-server management and Database mirroring

Master Data Services

Master database records are stored in Master Data Services (MDS), so that it will be accessed by Business intelligence, Reporting services and Data warehousing. Organization may have various departments and each department is having their own master database. If some higher level official of the organization wants to see certain data of all the departments then each department need to run their own reporting service or analyze the data to make a report from each database. In this scenario if all the master data is available in a centralized master database then it will be easy to generate the report using the Master Database. Master Data Services (MDS) will allow to store the entire master database in a Centralized database where Business Intelligence (BI), Reporting services make use of it.

Multi-Server Management

Multi-server Management is one of the new feature available in SQL Server 2008 R2 which is useful for Database Administrators (DBA) to monitor and analyze the resource utilization across its environments.

Data-tier applications (DAC)

DAC is available only in SQL Server 2008 R2 which enables developers and DBA's to package all the server objects that includes Database into a entity called Data-tier application package. Developers can create a DAC package in Visual Studio 2010 and SQL Server management studio can extract the DAC package which is created as a package in Visual Studio.

Related Articles

New features in Windows Server 2008 R2

This article explains the new features and enhancements that are available in Windows Server 2008 R2 and the features that are included in SP 1 which is going to be released in 2011

More articles: SQL Server SQL Server


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: