What Does an SQL Server Database Administrator Do?

SQL is the abbreviation of Structured Query Language, which means structured query language. The main function of the SQL language is to establish contact and communicate with various databases. According to ANSI (American National Standards Institute), SQL is used as the standard language for relational database management systems. SQL Server is a relational database management system (RDBMS) developed and promoted by Microsoft.

SqlServer

SQL is the abbreviation of English Structured Query Language, which means

SQL Server is developed and promoted by Microsoft

1. Real client / server

Hardware requirements for installing and running SQL Server 2000

1. computer

Intel and its compatible computers, Pentium 166Mz or higher processor or DEC Alpha and its compatible systems.

2. Memory (RAM)

The enterprise version requires at least 64M of memory, and other versions require at least 32M of memory. It is recommended to use more memory.

3 hard disk space

Full installation requires 180M space, typical installation requires 170M space, and minimum installation requires 65M space.

SQL statements can be used to perform various operations, such as updating data in a database, extracting data from a database, and so on. At present, most popular relational database management systems, such as Oracle, Sybase, Microsoft SQL Server, and Access, all adopt the SQL language standard. Although many databases have re-developed and extended SQL statements, standard SQL commands including Select, Insert, Update, Delete, Create, and Drop can still be used to complete almost all database operations.

SQL Server

SQL Server is a relational database management system. It was originally developed by three companies, Microsoft Sybase and Ashton-Tate, and introduced the first OS / 2 version in 1988. After the introduction of Windows NT, Microsoft and Sybase parted ways in the development of SQL Server. Microsoft migrated SQL Server to Windows NT and focused on developing and promoting the Windows NT version of SQL Server. Sybase is more focused on the application of SQL Server on UNIX operating systems.

SQL Server 2000 is a SQL Server database management system introduced by Microsoft. This version inherits the advantages of SQL Server 7.0 and adds many more advanced features than it. It is easy to use, scalable, and highly integrated with related software. It can be used on a variety of platforms, from laptops running Microsoft Windows 98 to large multiprocessor servers running Microsoft Windows 2000.

Sqlserver version

SQL Server 2000: It is a SQL Server database management system introduced by Microsoft. This version inherits the advantages of SQL Server 7.0 and adds many more advanced features than it. It has the advantages of easy to use, good scalability, and high degree of integration with related software. It can be used on a variety of platforms from small computers running Microsoft Windows 98 to large multiprocessor servers running Microsoft Windows 2000.

SQL Server 2005 is a comprehensive database platform that provides enterprise-class data management using integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure and reliable storage for relational and structured data, enabling you to build and manage highly available and high-performance data applications for your business.

SQL Server 2005: The SQL Server 2005 data engine is the core of this enterprise data management solution. In addition, SQL Server 2005 combines analysis, reporting, integration, and notification capabilities. This enables your business to build and deploy cost-effective BI solutions, helping your team push data applications to all areas of the business through scorecards, dashboards, web services, and mobile devices.

Tight integration with Microsoft Visual Studio, Microsoft Office System, and new development kits, including Business Intelligence Development Studio, sets SQL Server 2005 apart. Whether you are a developer, database administrator, information worker, or decision maker, SQL Server 2005 can provide you with innovative solutions to help you benefit more from your data.

SQL Server 2008: SQL Server 2008 is a major product release that introduces many new features and key improvements, making it the most powerful and comprehensive SQL Server release to date. This article details the new features, benefits and capabilities in Microsoft SQL Server 2008 ...

This data platform from Microsoft meets the needs of these data explosions and next-generation data-driven applications, supporting the data platform vision: mission-critical enterprise data platforms, dynamic development, relational data, and business intelligence.

Many factors have led to the explosion of information storage. With new types of information, such as the digitization of pictures and videos, and sensor information obtained from RFID tags, the amount of digital information for companies is growing dramatically. The development of compliance and globalization requires the security and availability of information storage at all times. At the same time, the cost of disk storage has been significantly reduced, enabling the company to store more data for every dollar invested. Users must quickly find relevant information in a large amount of data. In addition, they want to use this information on any device and plan to use it daily, such as Microsoft Office system applications. Managing the explosion of data and increasing user expectations creates many challenges for the company.

The Microsoft & reg; Data Platform Vision provides a solution to meet these needs. The solution is that companies can use to store and manage many types of data, including XML, e-mail, time / calendar, files, documents, geography, and more. A rich collection of services to interact with data: search, query, data analysis, reporting, data integration, and powerful synchronization capabilities. Users can access information from creation to archiving on any device, from desktop to mobile.

SQL Server 2008 new features

This platform has the following characteristics:

TrustedEnables companies to run their most mission-critical applications with high levels of security, reliability, and scalability.

Efficient-Enables companies to reduce the time and cost of developing and managing their data infrastructure.

Intelligent-Provides a comprehensive platform to send your users observations and information when they need it.

One trusted

(1) Protect your information

Based on the previous SQL Server 2005, SQL Server 2008 has made the following enhancements to extend its security:

* Simple data encryption

SQL Server 2008 can encrypt entire databases, data files, and log files without requiring application changes. Encryption enables companies to meet compliance requirements and their concerns about data privacy. The benefits of simple data encryption include searching encrypted data using any range or fuzzy query, strengthening data security to prevent access by unauthorized users, and data encryption. This can be done without changing existing applications.

* Foreign key management

SQL Server 2008 provides a comprehensive solution for encryption and key management. In order to meet the ever-increasing demand for stronger security of information in data centers, the company invests in vendors to manage security keys within the company. SQL Server 2008 supports this need by supporting third-party key management and hardware security module (HSM) products.

* Enhanced review

SQL Server 2008 enables you to audit the operation of your data, thereby improving compliance and security. The review includes not only all information about the modification of the data, but also information about when the data was read. SQL Server 2008 has features such as enhanced audit configuration and management in the server, which enables companies to meet a variety of regulatory requirements. SQL Server 2008 can also define audit specifications for each database, so the audit configuration can be made separately for each database. Performing audit configuration for a specified object makes the audit execution performance better and configuration flexibility more.

(2) Ensure business sustainability

* Improved database mirroring

SQL Server 2008 is based on SQL Server 2005 and provides a more reliable platform for enhancing database mirroring. New features include:

· Automatic page repair. SQL Server 2008 requests a recopy of the error page obtained from the mirror partner machine, so that the primary and mirror computers can transparently repair the 823 and 824 errors on the data page.

Improved performance. SQL Server 2008 compresses the output log stream to minimize the network bandwidth required for database mirroring.

Anatomy of a SQL Server server installation

Versions before SQL Server 2000, such as 7.0, generally do not exist. There are only standard and desktop versions. If you do not know what version to install, you can install it according to the installation prerequisite instructions on the installation. Generally, it is installed on WIN2000 Standard version, other systems can be installed on the desktop version; while SQL Server 2000 installation problems are relatively large, common problems are as follows:

(1) Interrupted while configuring the server.

(2) Interruption while registering ActiveX.

(3) The display is interrupted until 100%.

(4) Prompt: command line option syntax error, type command /? For help, continue the installation, and finally appeared when configuring the server: Could not find the dynamic link SQLUNIRL.DLL in the specified path ...

(5) The previous program created a pending file operation, and must be restarted before running the installer

(1) (2) (3) Solutions:

Reminder: In order to avoid misoperation, first back up the registry and database can not access SQL Server 2000, you can back up the files in the Program Files \ Microsoft SQL Server \ MSSQL \ Data folder.

1. Uninstall SQL Server first (it doesn't matter if it cannot be uninstalled, continue with the following operations)

2. Delete the entire Microsoft SQL Server folder.

3 Run the registry and delete the following entries:

HKEY_CURRENT_USER \ Software \ Microsoft \ Microsoft SQL Server

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer

4 Restart the system if needed

5. re-install

Alternatively, you can try to install SQL Server 2000 in a single step:

1: Insert the SQL Server 2000 CD.

2: Type "F: \ x86 \ setup.exe k = dbg" in "Start"-"Run" (F is the CD)

note:

1. SQL Server 2000 versions supported by different operating systems and hardware requirements.

Windows 2000 Server can install any version of SQL Server 2000.

Windows 2000 Professional can only install SQL Server 2000 Personal, Development, Evaluation, MCDE

two,

SQL Server 2000 versions and hardware requirements.

(4) Solution

Because the path to the installation file (full path) has Chinese.

For example, c: \ SQLSERVER Chinese Enterprise Edition \

Changed to c: \ SQLSERVER \

(5) Solution

a. Restart the machine and then install it. If you still find the error, please follow the steps below.

b. Enter regedit in Start-> Run

c. Go to HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager

d. Select File-> Export and save

e. Right-click PendingFileRenameOperations in the right window, select Delete, and then confirm

f. Restart the installation and solve the problem

-------------------------------------------------- -----

If the problem persists, try to repair the operating system first

Execute at the command prompt:

sfc / scannow

The last method: change the Windows 2000 installation disk and SQL Server2000 installation disk

Sometimes the cause of the problem is weird, and someone has replaced a power supply to solve the problem.

1. Uninstall your SQL Server 2000 first and delete the Program Files \ Microsoft SQL Server folder if necessary

2. Open registry

Type "regedit" in "start"-"run"

3 Click to open in the following order

+ HKEY_LOCAL_MACHINE

+ SOFTWART

+ Microsoft

+ Windows

+ CurrentVersion

+ Setup

+ ExceptionComponents

4 Delete all folders under ExceptionComponents!

Such as {60BFF50D-FB2C-4498-A577-C9548C390BB9}

{60BFF50D-FB2C-4498-A577-C9548C390BB9}

{60BFF50D-FB2C-4498-A577-C9548C390BB9}

{60BFF50D-FB2C-4498-A577-C9548C390BB9}

6. Restart:

7. Reinstall SQL Server 2000

Problems with XP + SP2

1. Winxp + sp2 system needs to install SQL Server SP3 (Service Pack Patch 3). If it has been installed before, it must be installed again.

SP3 can be downloaded for free from the Microsoft website. The address of the Chinese version is as follows:

SQL Server 2000 Service Pack 3a