Microsoft SQL Server

Microsoft SQL Server

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) used by both Microsoft and Sybase

SQL Server 2000 is the data management and analysis backbone for the coming wave of Microsoft .NET products and services.
Query, analyze, and manipulate data over the Web.
•Simplify the integration of back-end systems and data transfer across firewalls using rich SQL Server 2000 XML functionality and support for other Internet standards, such as XPath, XSL, and XSLT. Web developers can access data using XML without relational database programming, while database administrators can easily manipulate data in XML format using Transact-SQL (T-SQL) and stored procedures.
•Connect to SQL Server 2000 databases and Online Analytical Processing (OLAP) cubes flexibly using the Web with no additional programming. Use secure HTTP database connectivity to ensure that data can be queried, even by novice developers, through a URL and intuitive user interfaces.
•Derive additional value from data using sophisticated data mining tools that allow you to recognize trends and make predictions from the largest data sets.
•Obtain results quickly using Microsoft English Query, which allows users to pose questions in English instead of using Structured Query Language (SQL) or Multidimensional Expressions (MDX). Enhanced full-text search now allows users to search unstructured data such as Microsoft Word documents, Web pages, or Microsoft Excel spreadsheets.
•Create business-to-business (B2B) and business-to-consumer (B2C) Web sites, analyze Web site trends, and implement personalization automatically using Microsoft Commerce Server 2000 and SQL Server 2000.
•Enable online exchanges between trading partners using Microsoft BizTalk® Server 2000 and SQL Server 2000. Web-enable and integrate existing business systems through pervasive XML support.

Modern SQL Servers are built on RDBMS.
________________________________________
DBMS - Database Management System
A Database Management System (DBMS) is a computer program that can access data in a database.
The DBMS program enables you to extract, modify, or store information in a database.
Different DBMS programs provides different functions for querying data, reporting data, and modifying data.
________________________________________
RDBMS - Relational Database Management System
A Relational Database Management System (RDBMS) is a Database Management System (DBMS) where the database is organized and accessed according to the relationships between data.
RDBMS was invented by IBM in the early 1970's.
RDBMS is the basis for SQL, and for all modern database systems like Oracle, SQL Server, IBM DB2, Sybase, MySQL, and Microsoft Access