Welcome My Blog

Sunday, September 30, 2012

Microsoft SQL Server

Logo Ms. SQL Server

Microsoft SQL Server is a relational database management system (RDBMS) products Microsoft. Primary query language is Transact-SQL is an implementation of the SQL standard ANSI / ISO are used by both Microsoft and Sybase. SQL Server is generally used in the business world that have small data base to middle, but then developed with the use of SQL Server in a large database.
Microsoft SQL Server and Sybase / ASE can communicate over the network by using a protocol TDS (Tabular Data Stream). Apart from that, Microsoft SQL Server also supports ODBC (Open Database Connectivity) and JDBC drivers have for the Java programming language. Another feature of SQL Server is its ability to create a database mirroring and clustering. In the previous version, MS SQL Server 2000 affected by the SQL Slammer computer worm which resulted in delays access to the Internet on January 25, 2003.

No comments:

Post a Comment