Application Frameworks in SQL Server 2005

The new application framework of SQL called the Service Broker is a distributed application framework that provides relable asynchronous messaging at the database to database level. It allows internal and external processes to exchange streams of reliable asynchronous messages using extensions of T-SQL DML.

The Reporting services is a major new component for integrated business intelligence. It is a server based platform for creating, managing and delivering traditional and interactive reports.

It has everything required for creating out of the box reports, for hosting the reports, viewing them and embedding them in different solutions. The power of the Smart client and the Web application is brought to the service of the SQL server 2005.

Notification services is a platform for developing and deploying applications that generate and send notices to users as personalized timely messages.
A number of new key features have been introduced into the SQL server mobile edition.

The Mobile edition database can be created on the desktop or directly from SQL Server Management Studio. It can also be coded against the Data Transformation Services(DTS) objects. The SqlCeResult set that is derived from the SQLResult set allows mobile Edition to have true scrollable updateable cursors. It also allows binding to data objects on these devices. One or more applications can also be made to access a single data base on the mobile device.

Notifications can be obtained on the status bar and the small size of the database can be maintained through an aggressive page reclamation policy. Parameteterized query can be developed using SQL syntax.