Hotel computer room: What is ISA server and what is SQL?

ISA Instruction Set Architecture (ISA, Instruction Set Architecture) is a part of the computer architecture related to programming, including local data types, instructions, registers, address modes, memory architecture, interrupt and exception handling and external I/O. An ISA consists of a specification of a series of opcodes (machine language), native commands implemented by a specific CPU design.

ISA Internet Security Acceleration

The current versions of ISA (Internet Security Acceleration) include ISA2000, ISA2004, ISA2006 and ISA2008. It is a famous routing-level network firewall produced by Microsoft. Its main functions are: 1. Firewall (firewall) The firewall can filter the traffic in and out of the internal network. It can be used to control the communication between the internal network and the Internet to increase the security of the network. It can also be used to securely publish servers within the enterprise so that customers and partners can share internal network resources, such as email servers, websites, etc. In addition to general packet filtering capabilities, ISA also provides a number of application filters, which can filter packets for applications. 2. Virtual Private Network (VPN) Virtual Private Network (VPN) allows a secure channel to be established through the Internet between a remote user and a local area network (LAN), or between LANs in two places. 3. Web cache (web cache) By saving the web pages frequently visited by users to the hard disk and memory of the ISA server, it not only allows users to access web pages faster, but also improves the utilization of network resources and saves network bandwidth.

SQL is a standard - but...

SQL is an ANSI standard computer language used to access and operate database systems. SQL statements are used to retrieve and update data in the database. SQL works with database programs such as MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, and other database systems. SQL statement structure

Unfortunately, there are many different versions of the SQL language, but in order to be compatible with the ANSI standard, they must support some major keywords in a similar way and in the same place ( Such as SELECT, UPDATE, DELETE, INSERT, WHERE, etc.). NOTE: In addition to the SQL standard, most SQL database programs have their own proprietary extensions!