Ok, by now you have probably heard of at least some of the new features that will be added with the new version of SQL Server. A lot of theses changes allow you to do things on a SQL Server that you could have never done before. Some of the biggest changes that have been added come from CLR intergation. This gives you things like .NET Stored Procedures, .NET User Defined Functions, Extended Triggers, and .NET user defined types. On the ADO.NET side, new things have been added such as Multiple Active ResultSets, asynchronous support, and paging support.
Alright, a lot of buzz words have been mentioned today and I am not going to go into defining them at this time. However, I encourage to go this URL and read some of the sample chapters.
The chapter even has some sample code of a lot of the new features and is worth the read.
Read the complete post at http://www.dotnettipoftheday.com/blog.aspx?id=211