SQL Server 2000

Chapter 1 : Introduction to SQL Server 2000

This is major database server package of Micro Soft flagship. The last version of SQL Server before SQL Server 2000, was SQL Server 7.0. So it can be said to be version 8.0 of SQL Server. Initially Sybase and Microsoft together created SQL Server but they had changed their way long before and now both have their own database packages.

SQL Server 2000 now has a new version named SQL Server 2005. Although, still it has to find its way in market. SQL Server 2000, on other hand, is leader in the market.

With release of Visual Studio .Net, SQL Server has became the most favored database server. This will certainly hurt Oracle, which was the hottest choice of developers before.

SQL Server can run in NT 4.0 (service pack 5 or later), Windows 2000 and Windows 98 or ME. But, to it is recommended to run it in Windows 2000 Server Edition.

SQL Server is based on client Server model. The server provides - security, high availability and fault tolerance while client is used for - use interface, execution of queries and ease of use. Client requests the server and server responds to client's request.

All databases are based on some database concepts like, relational model, OO model, network model etc. SQL Server (both Sybase and MS ) is based on Relational Model with Object Oriented approach. In relational model, data is stored in tables and database follows codd's rule.

posted by Boolean Z @ 1:48 AM