Features of SQL SERVER 2008 R2

Below are the almost all the features thats are availble in SQL SERVER 2008 R2

* Multi-Server Administration and Data-Tier Application

* Scalability and Performance

* High Availability (Always On)

* PowerPivot for SharePoint,

* PowerPivot for Excel,

* Virtualization Support

* Replication

* Enterprise Security

* Single Instance RDBMS Management

* Application and Multi-Instance Management

* Management Tools

> * Development Tools

* Programmability

* Spatial and Location Services

* Complex Event Processing (StreamInsight)

* Integration Services

* Integration Services-Advanced Adapters

* Integration Services-Advanced Transforms

* Data Warehouse

* Analysis Services

* Analysis Services-Advanced Analytic Functions

* Data Mining

* Reporting

* Business Intelligence Clients

* Master Data Services

* Integration Services,

* Integration Services-Advanced Adapters,

* Integration Services-Advanced Transforms,

* Connecting to the Database Engine Using Extended Protection,

* Master Data Services,

* StreamInsight,

* ReportBuilder 3.0,

* SQL Server Utility named UC (Utility Control Point)