Page 30 - Open Soource Technologies 304.indd

Unit 2: Working with My SQL

– 1987 Sybase releases SQL Server for UNIX. Notes

– 1988 Microsoft, Sybase and Aston-Tate port SQL Server to OS/2.
– 1989 Microsoft, Sybase and Aston-Tate release SQL Server 1.0 for OS/2.

– 1990 SQL Server 1.1 is released with support for Windows 3.0 clients.
– Aston-Tate drops out of SQL Server development.
– 1991 Microsoft and IBM end joint development of OS/2.

- 1992 Microsoft SQL Server 4.2 for 16-bit OS/2 1.3 is released.
- 1992 Microsoft and Sybase port SQL Server to Windows NT.
- 1993 Windows NT 3.1 is released.

- 1993 Microsoft and Sybase release version 4.2 of SQL Server for Windows NT.
- 1994 Microsoft and Sybase co-development of SQL Server officially ends.
- Microsoft continues to develop the Windows version of SQL Server.

– Sybase continues to develop the UNIX version of SQL Server.
– 1995 Microsoft releases version 6.0 of SQL Server.

– 1996 Microsoft releases version 6.5 of SQL Server.
– 1998 Microsoft releases version 7.0 of SQL Server.
– 2000 Microsoft releases SQL Server 2000.

– 2001 Microsoft releases XML for SQL Server Web Release 1 (download).
– 2002 Microsoft releases SQLXML 2.0 (renamed from XML for SQL Server).

– 2002 Microsoft releases SQLXML 3.0.
– 2005 Microsoft releases SQL Server 2005 on November 7th, 2005.
Questions

1. Explain SQL Server.
2. Give the time line of all SQL server version.

2.3 Summary

• My SQL looks at the host you are connecting from and the username and password pair
that you are using. If your host is allowed to connect, your password is correct for your
username and the username matches one assigned to host, My SQL moves to next step.
• For whichever SQL command you are attempting to use, My SQL verifies that you have
the ability to perform that action for that database, table and field.
• Administering your server through a third party application might afford you a simple
method for adding users, a wizard-like process or a graphical interface.
• The simplest method for adding new users is the GRANT command.

• For removing privileges we have to use REVOKE command.

LOVELY PROFESSIONAL UNIVERSITY 25