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 mirroringMaster 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.
