Sql Server information and facts

                                   Written By Julius Brown

 

 

    SQL Server 2000 is the latest addition to the SQL Server family. SQL Server was created to provide interoperability, scalability and better functionality to previous version of windows and earlier versions of SQL Server. In this report I will briefly describe the different client that can be connected to a SQL Server, how named pipes and TCP/IP sockets differ and I will give my thoughts on how benefit and drawbacks of ODBC to configure your server.

   SQL Server versatility and adaptability are just some of the reasons that SQL Server has the ability to be functional for so many types of users. SQL Server 2000 has seven different versions of it program that is marketed to many different types of users. All of the different versions of SQL Server have different abilities, uses and requirements. I will now describe each version give brief description of its requirements and describe some of the users that would purchase that version of SQL Server.

 

  SQL Server 2000 Enterprise Edition

 

Features:

 

• Has the ability to use 32 processors (must purchase a license for each processor)
• Has the ability to use up 2 GB of ram
• Has the ability to use multiplexing
• Can only be used on server versions of windows 2000
• Can divide its tasks between other SQL Servers
• Can store backups so if the servers fail it can be promoted and the database will continue its uptime
• Has the ability to replicate change to other SQL Servers (only in windows 2000)
• Has the ability to access information from previous versions of it self and also Microsoft access.
• One of the only two SQL Server programs that have permission to be used in a client server architecture
• Much more

 

Intended Users:

 

  Large-scale corporations use SQL Server 2000 Enterprise Edition because SQL Server has the ability to be integrated into previous versions SQL Server and also because SQL Server has the ability to migrated easily. Enterprise Edition’s security and fault tolerance are also reasons large-scale corporations use Enterprise Edition.

 

 

Examples:

 

• Data warehouse companies-
• Companies that have a lot of client accessing the data base and they need more than four processors
• E-commerce companies

 

 SQL Server 2000 Standard Edition

 

Features:

 

• Has the ability to use 4 processors (must purchase a license for each processor)
• Has the ability to use up 2 GB of ram
• Can only be used on server versions of windows 2000
• Has the ability to use HTML and XML
• Can store backups so if the servers fail it can be promoted and the database will continue its uptime
• Has the ability to replicate change to other SQL Servers (only in windows 2000)
• Has the ability to access information from previous versions of it self and also Microsoft access.
• One of the only two SQL Server programs that have permission to be used in a client server architecture
• Much More

 

Intended Users:

 

Small and medium sized companies use SQL Server 2000 Standard edition because it is cause effective and the total cost of ownership is low. SQL Server 2000 Standard edition has many of the features of Enterprise addition but is not as scalable.

 

Examples:

 

• Local chain stores
• Web based database services for employees
• Intranet database for internal client information (client addresses, phone numbers, account numbers etc)
• Small accounting companies

 

SQL Server 2000 Personal Edition

 

Features:

• Has the ability to use 2 processors (only one if your windows 98 or windows me)
• Has the ability to use up 2 GB of ram
• If you run more than 5 Transact batches at one time it becomes slower and less productive
• Has the ability to use HTML and XML
• Can store backups so if the servers fail it can be promoted and the database will continue its uptime
• Has the ability to replicate change to other SQL Servers (only in windows 2000)
• Has the ability to access information from previous versions of it self and also Microsoft access.
• Can only subscribe to server it cannot publish indexes
• Much More

 

Intended Users:

 

 Mobil users use SQL Server 2000 Personal edition to access the database from their laptops because SQL Server 2000 Personal edition cannot be used as a server. SQL Server 2000 Personal edition has the ability to create database and can be share with other SQL Server 2000 Personal edition without license as long as it is not is a client server environment.

 

Example:

 

• Office laptop users

 

SQL Server 2000 Developers Edition

 

Features:

 

• Has the ability to use 32 processors (must purchase a license for each processor)
• Has the ability to use up 2 GB of ram
• Has the ability to use multiplexing
• Can only be used on server versions of windows 2000
• Can divide its tasks between other SQL Servers
• Can store backups so if the servers fail it can be promoted and the database will continue its uptime
• Has the ability to replicate change to other SQL Servers (only in windows 2000)
• Has the ability to access information from previous versions of it self and also Microsoft access.
• Has end-user license agreement the restricts it for being used as a server
• Much more

 

Intended Users:

 

  Programmers and developers this version of SQL Server 2000 was created for software developers to create solutions to isolated problems that may result from installing SQL Server into there network or unforeseen problems.

 

Examples:

 

• Consultants
• System Integrators
• Solution providers
• Corporate developers

 

 

SQL Server 2000 Evaluation Edition

 

Features:

 

• Same as enterprise edition but has no license and is only available for 120 days
• Has a special restrictive license that only permits it to be used for testing and evaluation

 

Intended Users:

 

  Developers and Database Administrators use this database to test project before they are implemented into the actual database. Student can use this version to learn database administration and study for certification.

 

  Examples:

 

• Database administrators
• College Students
• Database Developers

 

SQL Server 2000 Windows CE Edition

 

Features:

 

• Optimizing query processor
• Support for transactions
• Remote data access

 

Intended Users:

 

 Clients that use this service own a device that uses a Windows CE.

   

Examples:

 

• PDA users

 

SQL Server 2000 Desktop Engine

 

   SQL Server 2000 application that was created for small to mid-sized company for database access in a peer to peer atmosphere as long as it is not setup as a client /server architecture.

 

Minimum requirement for installing SQL Server 2000

 

SQL Server 2000 Enterprise Edition

 

Memory: 64 MB

 

Storage:

SQL Server database components: 95 to 270 MB, 250 MB typical

Analysis Services: 50 MB minimum, 130 MB typical

English Query: 80 MB

Desktop Engine only: 44 MB

Processor: 166 MHZ or Higher

 

OS:

SQL Server 2000 Enterprise Edition:

Microsoft Windows NT Server 4.0, Microsoft Windows NT Server Enterprise Edition 4.0, Windows 2000 Server, Windows 2000 Advanced Server, and Windows 2000 Data Center Server

 

SQL Server 2000 Standard Edition

Microsoft Windows NT Server 4.0, Microsoft Windows NT Server Enterprise Edition 4.0, Windows 2000 Server, Windows 2000 Advanced Server, and Windows 2000 Data Center Server

 

SQL Server 2000 Developer Edition

Microsoft Windows NT Server 4.0, Microsoft Windows NT Server Enterprise Edition 4.0, Windows 2000 Server, Windows 2000 Advanced Server, and Windows 2000 Data Center Server

 

SQL Server 2000 Evaluation Edition

SQL Server 2000 Personal Edition

SQL Server 2000 Design Engine

Microsoft Windows NT Server 4.0, Microsoft Windows NT Server Enterprise Edition 4.0, Windows 2000 Server, Windows 2000 Advanced Server, and Windows 2000 Data Center Server, Windows 98 and ME

 

 

 

 

Named pipes – Named pipes is the process of exchanging information from two different applications that could or could not be running on two different computers on a network.

 

TCP/IP Sockets- establishes a TCP/IP connection between the client computer and the server computer on a network.

 

 

The difference between TCP/IP Sockets and Named pipes is that TCP/IP Socket only creates a connection between to separate computers it is not concerned with the application that request its service or what service the sending/receiving computer is going to perform. Where as named pipes is only concern with the transfer of information from one application to another and it doesn’t have to be on two separate machines

 

 

References:

 

http://www.linuxjournal.com/article.php?sid=2156

http://www.webopedia.com/TERM/N/Named_Pipes.

http://216.239.39.100/search?q=cache:nqkw7pOALm0J:cs.baylor.edu/~donahoo/practical/CSockets/PracticalSocketC.ppt+what+is+TCP%3FIP+sockets%3F&hl=en&ie=UTF-8

http://www.databasejournal.com/features/mssql/article.php/1442281

http://www.databasejournal.com/features/mssql/article.php/2108361

http://www.mssqlcity.com/Articles/Adm/installation_troubleshooting.htm

http://www.labmice.net/BackOffice/SQL2000/install.htm

 

 

 

 

 

 

Home