What is Microsoft SQL Server?

Microsoft SQL Server is a Microsoft product that has the features of relational database management system (RDBMS) Microsoft products. Primary query language is Transact-SQL is an implementation of the SQL standard ANSI / ISO are used by Microsoft and Sybase. SQL Server is generally used in the business world that has a data base of small to medium scale, but then developed with the use of SQL Server on a large database.

Microsoft SQL Server and Sybase / ASE can communicate via the network using the TDS protocol (Tabular Data Stream). Apart from that, Microsoft SQL Server also supports ODBC (Open Database Connectivity), and has a JDBC driver for Java programming language. Other features of SQL Server is its ability to create a database mirroring and clustering. In previous versions, MS SQL Server 2000 affected by the SQL Slammer computer worm that caused a delay access to the Internet on January 25, 2003.