This articles explains about many new features in SQL Server 2005 covering the topics like Choosing between Transact-SQL and managed code, Web services, ADO.NET and ADO.NET notification support, Multiple active result sets, Snapshot isolation support, SQL Management Objects, XML Technologies, New Application Frameworks, Language Enhancements, Security enhancements,

SQL Server 2005 Developer tools:  The driving force behind Micorsoft SQL Servr 2005 is the process of integration. With MSSQL 2005 the database developer experiences a paradigm shift. He can now locate his code with refrence to its functionality, he can access data in its native formats or build complex systems that are server driven. The integration with the .NET framework gives him the power of the class library and modern programming languages to implement functionalities within the server.

Click here to read the complete article