This feature will help database administrator to gain insight into growing applications and databases thereby helping them to ensure better management of database servers.Įnhance Collaboration Across Development and ITĭatabase Application development will be more closely integrated with Visual Studio 2010 which will help to ensure higher quality during the application development along with easier deployments and better handling of changes over time.Ī Master Data Service (MDS) is a kind of data service that is responsible for: managing, in a single place, the uniqueness, integrity, quality, and interrelationships between the data that matters the most. This feature will help organizations to strictly apply organization wide policies across servers thereby helping them maintain a healthy system. This is a great new feature for database administrators as it will provide a real time insight into Server Utilization, Policy Violations etc. This will help improve performance and scalability for very large data warehousing applications. In SQL Server 2008 R2 the number of logical processors supported has been increased from 64 to 256 and it will take advantage of the multi-core technology. There was always a demand from customers to increase the number of logical processors supported in SQL Server.
This article gives you an overview of some of the new features in SQL Server 2008 R2. Microsoft SQL Server 2008 R2 introduces lot many new features for Business Intelligence users, Developers and Database Administrators. Overview of New Features in Microsoft SQL Server 2008 R2