SQL Server 2005 integrates the .NET Framework’s Common Language Runtime (CLR) and offers native support for XML and Web services. Integrating the .NET Framework could improve the stability of business systems that depend heavily on custom server-side database code (as many financial and billing systems do) and increase the productivity of developers building such systems by letting them create database-resident logic with Visual Studio, using Visual Basic .NET (VB.NET) or C#. However, development organizations must carefully consider where to use Transact-SQL (T-SQL) versus .NET languages.

.NET Framework integration and better support for XML and Web services in SQL Server 2005 could drive use of Microsoft’s .NET Framework for enterprise application development, and drive the adoption of XML and Web services for business-to-business data exchange. With Visual Studio’s sophisticated development environment and tool set, SQL Server 2005 could also offer a better alternative to database developers using Java to program competing databases, such as IBM’s DB2 and Oracle.

The next version of SQL Server, code-named Yukon, will integrate the .NET Framework’s Common Language Runtime (CLR) and offer native support for XML and Web services. .NET Framework integration could improve stability of business systems that depend heavily on custom server-side database code (as many financial and billing systems do) and increase productivity of developers building such systems by letting them create database-resident logic with Visual Studio, using Visual Basic (VB) .NET or C#. However, database developers will still need to understand Transact-SQL (T-SQL), SQL Server’s native programming language, and development organizations must carefully consider where to use T-SQL versus .NET languages.

.NET Framework integration and better support for XML and Web services in Yukon could help Microsoft use the success of SQL Server to further drive use of the .NET Framework for enterprise application development, and the adoption of XML and Web services for business-to-business data exchange. With Visual Studio’s sophisticated development environment and tool set, Yukon could also offer a better alternative to database developers using Java to program competing databases, such as IBM’s DB2 and Oracle.