So what is the latest and greatest in the world of SQL Server 2005? How about a decent run thru on the top ten features of interest!

I attended a SQL Server 2005 class the other day that peaked my interest in all the new development features in SQL Server 2005.

According to the product information on the Microsoft website, the following are the top 10 new development features in SQL Server 2005:

TOP 10 New Development Features in SQL Server 2005

* .NET Framework Hosting - With SQL Server 2005 developers will be able to create database objects using familiar languages such as Microsoft Visual C# .NET and Microsoft Visual Basic .NET. Developers will also be able to create two new objects—user-defined types and aggregates.
* XML Technologies - Extensible Markup Language (XML) is an important standard for disseminating data between different applications over local networks and the Internet. SQL Server 2005 will natively support storage and query of XML documents.
* ADO.NET version 2.0 - From new support for SQL Types to Multiple Active Result Sets (MARS), ADO.NET in SQL Server 2005 will evolve dataset access and manipulation to achieve greater scalability and flexibility.
* Security Enhancements - A new security model in SQL Server 2005 will separate users from objects, provide fine-grain access, and enable greater control of data access. Additionally, all system tables will be implemented as views, providing more control over database system objects.
* Transact-SQL Enhancements - SQL Server 2005 provides new language capabilities for developing scalable database applications. These enhancements include error handling, recursive query capabilities, relational operator PIVOT, APPLY, ROW_NUMBER and other row ranking functions, and more… Source: David Hayden

[tags].net,native xml web services,microsoft visual c,local networks,multiple active result sets[/tags]