A high-performance client/server relational database–management system (RDBMS) for the Microsoft Windows NT and Windows 2000 operating systems. Microsoft SQL Server is part of the Microsoft BackOffice family of server products. RDBMS’s are used in high-volume transaction-processing environments such as online order entry systems, data warehousing, decision-support applications, and e-commerce.
SQL Server includes the following features:
SQL Server is a client/server database system. The server runs the SQL Server database software, which processes requests submitted by the database client software and sends the results back to the client. The SQL Executive and the SQL Server Database Engine service are examples of database services performed by SQL Server.
The SQL Server software is arranged in multiple layers. The Net-Library layer, which accepts connections from clients, hides the network connectivity details when a client communicates with a server running SQL Server. Net-Libraries use interprocess communication (IPC) mechanisms such as named pipes, remote procedure calls (RPCs), and Windows Sockets. Several Net-Libraries are included with SQL Server for both the server and the client. Net-Libraries on the server listen for client connection attempts.
A client computer runs the database client software, which is used to connect to the server running SQL Server, make requests, receive results, and display the results on the user’s screen. Examples of database client software that can connect to SQL Server include SQL Server Enterprise Manager, ISQL/w, and Microsoft Access. The database client software is also made up of multiple layers. Users interact directly with the client application, which might present a form such as an order entry form. When the user submits the form, the client software interacts with the server running SQL Server using open database connectivity (ODBC) or DB-Library application programming interfaces (APIs). The server processes the request and returns information to the client.