10 major features analysis SQL Server 2005 development

This article describes the 10 most important features of SQL Server2005 from the aspect of database development ...

NET Framework Host

Using SQL Server2005, developers use similar languages, such as Microsoft's visualc#. NET and Microsoft's VisualBasic, will be able to create database objects. Developers will also be able to create two new objects-user-defined classes and collections.

XML technology

Extensible Markup Language (XML) is an important criterion for walking data between different applications using the local network and the Internet. SQL SERVER2005 will itself support storing and querying extensible Markup language files.

ado.net2.0 version

From new support for SQL classes to multiple active result sets (MARS), ado.net in SQL Server2005 drives access and manipulation of datasets, enabling greater scalability and flexibility.

Enhanced security

The new security model in SQL Server2005 separates users from objects, provides fine-grainaccess access, and allows greater control over data access. In addition, all system tables will be implemented as views, with a greater degree of control over the database system objects.

Enhanced performance of Transact-SQL

SQL Server2005 provides new language features for developing upgradeable database applications. These enhancements include handling errors, recursive query functionality, relational operator Pivot,apply,row_number, and other data column ranking features, and so on.

SQL Service Broker

The SQL Service Broker will provide a distributed, asynchronous application framework for large, business-wide applications.

Notification Service

The notification service enables the business to establish rich notification applications, providing personalized and timely information to any device, such as stock market alerts, news subscriptions, parcel delivery alerts, airline fares, and so on. In SQL Server2005, the notification service is more tightly integrated with other technologies, including Analysis Services, Sqlservermanagementstudio.

Web Services

With SQL Server2005, developers will be able to develop Web services at the database level, treat SQL Server as a Hypertext Transfer Protocol (HTTP) listener, and provide a new type of data access for Network Service center applications.

Reporting Services

With SQL Server2005, Report Services can provide report control and can be distributed through VisualStudio2005.

Enhancement of Full-text search functionality

SQL Server2005 will support rich Full-text application software. The server's cataloging capabilities will be enhanced to provide greater flexibility for the cataloged objects. Query performance and scalability will be greatly improved, and new management tools will provide a better understanding of how the full text function works.