session2: MICROSOFT SQL SERVER

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query languages are MS-SQL and T-SQL. MS-SQL is nothing but Microsoft's database computer language designed for the retrieval and management of data in RDBMS, database schema creation and modification, and database object access control management and T-SQL is Microsoft's and Sybase's proprietary extension to SQL.When it comes to performance, MS SQL’s strength of being packed with more features than other systems is its biggest disadvantage. it comes with adequate security mechanisms by default, bearing you follow the directions and keep the software updated with security patches.The good thing about MS SQL is that it allows you to change ports in case the default becomes too vulnerable. another advantage with MS-SQL server is that the data corruption is more unlikely. The data travels through various checkpoints while passing from your keyboard to the hard disk and through the monitor. apart from that the MS-SQL Server keeps track of the process, even if the system unexpectedly shuts down.
history:
-1987 Sybase releases SQL Server for UNIX.
- 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)
- 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 Microsoft and Sybase release version 4.2 of SQL Server for Windows NT.
(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.
- 2002 Microsoft releases SQLXML 2.0 (renamed from XML for SQL Server).
- 2002 Microsoft releases SQLXML 3.0.
- 2005 Microsoft releases SQL Server 2005
- 2008 Microsoft releases SQL Server 2008