Microsoft SQL Server XML and Web Application Architecture

Microsoft SQL Server 2000 has has added many new features that SQL Server 7 did not have, among them a series of new XML technologies called SQL Server XML. This technology suite contains many improvements, enhancements, and features that make SQL Server a more Web-friendly application.

SQL Server XML can be used to extend, enhance, or even replace the architecture of a Web application. The new features are comprised of two main components:

1. Database components, that allow the database to read, process, and write XML

2. SQL Server XML Internet Server API (ISAPI) application, which allows access to the database over HTTP

With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By using Internet Explorer 5.0 and XSL to convert the XML to HTML, it is possible to lighten the load on the database ser

Some topics in this essay:
Server XML, Logical Architecture, SQL Server, Service Internet, Path Language, Integration Web, XML XSL, ASP Web, sql server, XML ISAPI, Web Services, sql server xml, server xml, business logic, stored procedures, data access, logical architecture, isapi application, server 2000, physical architecture, sql server 2000, business logic layer, procedures database, stored procedures database, data access layer,