SQL Server 2000毕业论文外文翻译.docx

英文技术资料翻译英文原文： SQL ServerSQL Server is a relational database management system, it first from Microsoft Sybase and Ashton-Tate, the three companies jointly developed, launched in 1988, the first OS / 2 version. The introduction of Windows NT, Microsoft and Sybase SQL Server developers parted ways. Microsoft SQL Server migration to Windows NT systems, focused on the development and promotion of the SQL Server version of Windows NT; Sybase is more focused on the SQL Server on the UNIX operating system. Described in the book Microsoft SQL Server after referred to as SQL Server or MS SQL ServerIntroduction SQL Server 2000 is a version of the SQL Server database management system launched by Microsoft Corporation. This version inherits the advantages of SQL Server 7.0 version at the same time off than it adds many more advanced features with easy to use, scalability, software integration advantages, across from the laptop computer running Microsoft Windows 98 to run Microsoft Windows 2000, large-scale multi-processor server platforms.FeatureInternet Integration SQL Server 2000 database engine provides full XML support. It also has the scalability, availability and security features of the data storage components required to constitute the largest Web site. SQL Server 2000 programming model integrated with the Windows DNA architecture for developing Web applications, and SQL Server 2000 supports English Query and the Microsoft Search service function that contains a user-friendly queries and powerful search capabilities in Web applications.Scalability and availability The same database engine can be used on different platforms, from laptop computers running Microsoft Windows ® 98, to large multiprocessor servers running Microsoft Windows 2000 Data Center Edition. SQL Server 2000 Enterprise Edition supports a joint servers, indexed views, and large memory support and other functions to enable it to upgrade to the required level of performance of the largest Web site.Enterprise-level database functionality SQL Server 2000 relational database engine to support today's demanding data processing environment of the required functionality. Database engine to fully protect data integrity, minimize and manage thousands of concurrent users modify the database overhead. SQL Server 2000 distributed queries allow you to reference data from different data sources, if these data are part of the SQL Server 2000 database, and distributed transaction support full protection of the integrity of distributed data updates. Replication also allows you to maintain multiple copies of data, while ensuring that a separate copy of the data to keep pace. Off then the user can copy a set of data to multiple mobile, so that these users to work independently, and then they made to merge the changes back to the publishing server.Easy to install and deploy and use SQL Server 2000 includes a series of management and development tools, these tools can be improved at multiple sites, installation, deployment, management and use of SQL Server process. SQL Server 2000 also supports standards-based programming model integrated with the Windows DNA, making use of the SQL Server database and data warehouse to become a seamless part of a scalable system to generate a strong These features allow you to rapidly deliver SQL Server applications to customers with minimal installation and administrative overhead to these applications.Data warehouse. Extracting and analyzing summary data for online analytical processing (OLAP) tools in SQL Server 2000. SQL Server also includes a number of tools can be used to visually design a database to analyze data and English Query.Advantage 1, high-performance design, can take advantage of the advantages of WindowsNT. 2, advanced system management, support for the Windows graphical management tools, to support local and remote system management and configuration. 3, strong transaction processing functions, a variety of methods to ensure data integrity. 4, support for symmetric multi-processor architecture, stored procedures, ODBC, and self-SQL language. SQLServer with its built-in data replication capabilities, powerful management tools, the Internet is tightly integrated and open system architecture for the majority of users, developers and system integrators to provide a superior platform for the database.Protection of the ten measures of the SQL ServerIn order to improve SQL Server 1 installed security can be implemented ten measures(1) Install the latest service pack.In order to improve server security, the most effective way is to upgrade to SQL Server 2000 Service Pack 3a (SP3a). In addition, you should also install all security updates released.(2) Use the Microsoft Baseline Security Analyzer (MBSA) to assess the security of the server.MBSA is a scan of the unsafe configuration tools, a variety of Microsoft products including SQL Server and Microsoft SQL Server 2000 Desktop Engine (MSDE 2000). It can be run locally, you can also run through the network. Detection tool for the following problem on the SQL Server installation: 1) too many members of the sysadmin fixed server role. 2) granted to other roles other than sysadmin to create CmdExec job right. 3) The empty or simple passwords. 4) fragile authentication mode. 5) To grant the Administrators group too many rights. 6) SQL Server data directory incorrect access control lists (ACLs). 7) Install the sa password to use plain text file. 8) To grant the guest account too many rights. 9) is also a domain controller system running SQL Server. 10) Everyone (Everyone) group is not properly configured to provide access to specific registry keys. 11) SQL Server service account is not configured correctly. 12) did not install the necessary service packs and security updates.(3) using Windows Authentication Mode.Whenever possible, should requirements in connection to a SQL Server Windows Authentication Mode. From most of the Internet tools against it by limiting the connection to the Microsoft Windows ® user and domain user accounts to protect SQL Server, the server will benefit from Windows security enhancement mechanism, such as stronger authentication protocols and mandatory password complexity and expiration time. In addition, the certificate to delegate (the ability to bridge credentials across multiple servers) can only be used in Windows Authentication Mode. On the client side, Windows Authentication Mode is no longer needed to store the passwords. The stored password is one of the main vulnerabilities of the application using the standard SQL Server login. To install Windows authentication mode in SQL Server Enterprise Manager, follow these steps: 1) Expand the server group. 2) Right-click the server, and then click Properties. 3) in the authentication of the security tab, click the Windows only.Isolate your server and backed up regularly.Physical and logical isolation formed the basis of the SQL Server security. Should the machine the database resides in a place protected from the physical form, preferably a locked computer room, equipped with flood detection and fire detection / fire protection system. The database should be installed in the intranet security zone, do not directly connect to the Internet. Regular backups of all data, and save a copy in a secure off-site location.(5) assign a strong sa password.The sa account should always have a strong password, even in the configuration of the Windows authentication server so. This will ensure that after the server is configured for mixed mode authentication, does not appear blank or weak sa. To assign the sa password, please follow these steps: 1) Expand the server group, and then expand a server. 2) expand Security, then click Login. 3) In the details pane, right-click the SA, and then click Properties. 4) In the Password box, enter a new password.(6) limit the permissions of the SQL Server service.SQL Server 2000 and SQL Server Agent run as Windows services. Each service must be associated with a Windows account security context and derived from this account. SQL Server allows the user sa login (and sometimes also includes other users) to access operating system features. These operating system calls created by the server process account security context. If the server is compromised, then the operating system calls that could be used to attack other resources, have a process (the SQL Server service account) can be accessed. Therefore, is very important for the SQL Server service is only granted the necessary permissions. Recommended the following settings: 1) the SQL Server Engine / the MSSQLServerIf you have an instance is specified, then they should be named MSSQL $ InstanceName. Run as a Windows domain user account with regular user privileges. Do not run as local system, local administrator or domain administrator account. 2) the SQL Server Agent Service / the SQLServerAgentIf your environment is not required, disable the service; Otherwise, as a Windows domain user account to run with regular user privileges. Do not run as local system, local administrator or domain administrator account.Important: If one of the following conditions is true, then the SQL Server Agent will need local Windows administrator privileges:SQL Server Agent uses the standard SQL Server authentication to connect to SQL Server (not recommended).SQL Server Agent to use a multi-server management server (MSX) account, the account using the standard SQL Server authentication to connect.The SQL Server Agent to run non-Microsoft ActiveX ® script or CmdExec jobs owned by members of the sysadmin fixed server role.If you need to change the service account associated with SQL Serve r, use the SQL Server Enterprise Manager. Enterprise Manager to set the appropriate permissions for the files and registry keys used by SQL Server. Do not use the Microsoft Management Console "service" (in the Control Panel) to change these accounts, because it need to manually modulate a large number of registry keys and NTFS file system permissions and enclose tideland for cultivation Windows user permissions.Account information changes will take effect the next time the service starts. If you need to change the SQL Server and SQL Server Agent associated account, then you must use Enterprise Manager to make changes to two services.Disable SQL Server ports on the firewall.The default installation of SQL Server will monitor TCP port 1433 and UDP port 1434. Configure your firewall to filter out data packets reach the port. It should also be on the firewall to block other ports associated with the specified instance.8 using the most secure file system.NTFS file system is most suitable for the installation of SQL Server. Than the FAT file system is more stable and easier to recover. But it also includes a number of security options, such as file and directory ACL and file encryption (EFS). During the installation process, if the detected NTFS, SQL Server will set the appropriate ACLs on registry keys and files. Should not try to change these permissions.By EFS, database files will be encrypted under the identity of account running SQL Server. Only this account can decrypt these files. If you need to change the account running SQL Server, you must first decrypt the files under the old account, then re-encrypted under the new account.Delete or protect the old installation files.SQL Server Setup files may contain plain text or simple encryption of credentials and other sensitive configuration information recorded during the installation process. These log files are saved location depends on the installed version of SQL Server. In SQL Server 2000, the following documents may be affected: when <systemdrive> default installation: Program Files Microsoft SQL Server the MSSQL the Install folder, and specify the instance <systemdrive>: Program Files Microsoft SQL Server the MSSQL $ <Instance Name>, the Install folder of the sqlstp.log sqlsp.log and setup.issIf the current system is upgrading from SQL Server 7.0 installation from, you should also check the following files:% Windir% folder setup.iss in the Windows Temp folder sqlsp.log.Microsoft has released a free utility The Killpwd, it will find and remove these passwords from your system.10 audit points to the connection to SQL Server.SQL Server can log event information for the review of the system administrator. At least you should record the failure of the SQL Server connection attempt, and regularly view this log. Possible, do not save the log and data files on the same drive. Audit failed to connect to the SQL Server Enterprise Manager, follow these steps: 1) Expand the server group. 2) Right-click the server, and then click Properties. 3) The audit level in the Security tab, click on failure. 4) For this setting to take effect, you must stop and restart the server.Visual C+ 6.0Visual C + + 6.0, referred to as VC or VC6.0, Microsoft introduced a C + + compiler, the high-level language translation for "machine language (low-level languages)" program. Visual C + + is a powerful visualization software development tools. 1993 Microsoft introduced the Visual C + +1.0, with its new version come out, the Visual C + + has become a professional programmer software development tool of choice. Microsoft Visual C + + NET (Visual C + +7.0), but its application has many limitations, applies only to Windows 2000, Windows XP and Windows NT 4.0. Practice, are based more on the Visual C + + 6.0 platform.Features and shortcomingsCharacteristicDeveloped by Microsoft Visual C + +6.0, it is not only a C + + compiler, and is based on the visualization of the Windows operating system, integrated development environment (integrated development environment, the IDE). Visual C + +6.0 composed of many components, including editor, debugger, and AppWizard AppWizard, ClassWizard Class Wizard and other development tools. These components are integrated through a component called Developer Studio for the harmonious development environment. Microsoft's main software products. Visual C + + is a powerful visualization software development tools. 1993 Microsoft introduced the Visual C + +1.0, with its new version come out, the Visual C + + has become a professional programmer software development tool of choice. Microsoft Visual C + + NET (Visual C + +7.0), but the limitations of its application, is only applicable to Windows 2000, Windows XP and Windows NT 4.0. Practice, are based more on the Visual C + + 6.0 platform.The Visual C + +6.0 to have syntax highlighting, auto-compile functions and advanced debugging features known. For example, it allows users to remotely debug a single step. As well as allow t