Friday, March 12, 2010

New Features in SQL Server 2008 R2

Last two day I was in Microsoft SQL Server 2008 R2 HOL Session in Microsoft, India where we came to know the features and enhancements in SQL Server 2008 R2. Following are the feature set at a high level:

1. Data Tier Application Project - Nice way of managing database projects and deployment approach...

2. Master Data Services (Master Data Management) - Initial introduction of MDM within SQL server from MS

3. StreamInsight

4. PowerPivot - Self Analysis Service with in Excel 2010

5. Complex Event Processing (CEP)

6. Visual Studio 2010 feature for T-SQL

7. Reporting Services Enhancements

Hope I will get some time to evaluate these features and to use in our Design and architecture...