Microsoft SQL Server supports XML and can query across the Internet and beyond firewalls. Its programming model is integrated with Windows DNA architecture to allow for developing Web applications.
SQL Server includes many features and services that AppManager can help you monitor:
The SQL database stores event information. Its query structure allows you to pose SQL queries that perform actions on the SQL database, such as issuing an SQL command.
Open Database Connectivity (ODBC) is a standard for applications to access different databases, such as Access, Paradox, dBase, and Excel, regardless of the database management system in place.
ActiveX Data Objects (ADO) is Microsoft’s high-level interface to all kinds of data.
Data Source Name (DSN) is used by ODBC and ADO. It refers to the associated database connection information for a specific database server.
Knowledge Scripts in the SQL-RT category were designed to monitor these SQL Server components.
The SQL database has extensive programming capabilities that are built on Web standards. It supports XML and Internet standards that let you store and retrieve data in XML format with built-in stored procedures. Also, XML allows for easy data updating and deletion. Using any Visual Studio tool, you can design and code database applications.
Centralized database management lets you stay online while moving or copying databases across computers or between instances.
ODBC (Open Database Connectivity) refers to a standard open database access method developed by Microsoft. Its goal is to make any data access possible from any application, regardless of the database management system (DBMS) managing the data. ODBC inserts a middle layer, called a database driver, between an application and the DBMS. This layer translates the application’s data queries into commands that the DBMS understands. For this layer to function, both the application and the DBMS must be ODBC-compliant (the application must be capable of issuing ODBC commands and the DBMS must be able to respond to them). Since version 2.0, the standard supports SAG SQL.
ADO (ActiveX Data Objects) is a high-level data interface from Microsoft. ADO provides consistent, high-performance data access for either front-end database client or middle-tier business objects using an application, tool, language, or even an Internet browser.
DSN (Data Source Name) is a logical name used by the ODBC driver that refers to the drive and other information required to access data. Internet Information Services (IIS) uses the DSN to connect to an ODBC data source, such as the SQL Server database. The DSN contains the database name, directory, driver, user ID, password, and more. After creating a DSN for a database, you can use that DSN in an application to retrieve information from the database.