A leading international company ever
ASP Knowledge Center cliniquementchill.com
ASP SQL Server Database Overview
Microsoft ASP SQL Server - relational database management system (RDBMS), developed by the corporation Microsoft. The main query language used - Transact-SQL, jointly developed by Microsoft and Sybase. Transact-SQL is an implementation standard ANSI / ISO for structured query language (SQL) with extensions. Used for small and medium-sized databases, and in the last 5 years - for large-scale enterprise databases, competes with other DBMS in this market segment.
History
The source code for MS SQL Server database (version 7.0) code based on Sybase SQL Server, and Microsoft is allowed to enter the market databases for enterprises where competed Oracle, IBM, and, later, the Sybase. Microsoft, Sybase and Ashton-Tate originally united to create and release to the market first version of the program, called SQL Server 1.0 for OS / 2 (about 1989), which actually was the equivalent of Sybase SQL Server 3.0 for Unix, VMS and other Microsoft SQL Server 4.2 was released in 1992 and a member of the operating system Microsoft OS / 2 version 1.3. The official release of Microsoft SQL Server version 4.21 for Windows NT operating system was held simultaneously with the release of Windows NT (version 3.1). Microsoft SQL Server 6.0 was the first version of SQL Server, created exclusively for the architecture of NT and without the participation in the development of Sybase.
By that time, both entered the market OS Windows NT, Sybase and Microsoft dispersed and followed their own models and software product marketing schemes. Microsoft sought exclusive rights to all versions of SQL Server for Windows. Later, Sybase changed the name of your product for Adaptive Server Enterprise to avoid confusion with Microsoft SQL Server. Until 1994, Microsoft won three of Sybase copyrights hint as to the origin of Microsoft SQL Server.
After the division of the company made a number of independent releases programs. SQL Server 7.0 was the first database server with this graphical user interface administration. To address claims by Sybase in copyright infringement, the entire inherited in the seventh version of the code was rewritten.
The current version - Microsoft SQL Server 2005 - was presented in November 2005. The launch took place in parallel version of Visual Studio 2005 launch. There is also a "cut down" version of Microsoft SQL Server - Microsoft SQL Server Express; it available for download and freely distributed with using its software.
Since the previous release SQL Server (SQL Server 2000) was carried out by the development of an integrated development environment and a number of additional subsystems that make up SQL Server 2005. The changes affected the implementation of technology ETL (extraction, transformation and loading data), a component of the SQL Server Integration Services (SSIS), the server warning means multidimensional models analytical processing (OLAP) and gather relevant information (both services are part of the Microsoft Analysis Services), as well as several communications services, namely Service Broker and Notification Services. In addition, improvements were made in productivity.
Functionality
Microsoft SQL Server as a query language uses a version of SQL, called Transact-SQL (abbreviated T-SQL), is an implementation of SQL-92 (ISO standard for SQL) with multiple extensions. T-SQL allows additional syntax to use stored procedures and provides support transactions (interaction with a database management application). Microsoft SQL Server and Sybase ASE for interaction with the network using application layer protocol called Tabular Data Stream (TDS, tabular data transfer protocol). TDS protocol was also realized in the draft FreeTDS to ensure the interoperability of different applications with databases Microsoft SQL Server and Sybase.
Microsoft SQL Server also supports the Open Database Connectivity (ODBC) - interface interaction with the database applications. The latest version (SQL Server 2005) provides an opportunity to connect users through web services, using a protocol SOAP. This allows the client programs are not designed for Windows, platform to connect to SQL Server. Microsoft also issued a certified driver JDBC, allowing applications under the administration of Java (such as BEA and IBM WebSphere) to connect to Microsoft SQL Server 2000 and 2005.
SQL Server supports mirroring and clustering databases. Cluster Server SQL - a set of equally configured servers, and this scheme helps distribute the workload among several servers. All the servers have a virtual one name, and data distributed by IP addresses cluster machines during the working cycle. Also in case of refusal or failure in one of the cluster servers available automatic transfer to another server load.
SQL Server supports excessive duplication of data on three scenarios:
* Snapshot: A "snapshot" of a database server which sends recipients.
* History: All changes of the database is continuously transmitted to users.
* Synchronizing with other servers: Databases multiple servers are synchronized with each other. Change all databases occur independently of each other at each server, as happens with the synchronization of data matching. This type of duplication provides an opportunity to resolve the contradictions between BD.
In SQL Server 2005 is built support. NET Framework. Thanks to this, DB stored procedures can be written in any language platform. NET, using the full set of libraries available for. NET Framework, including Common Type System (system of data types in Microsoft. NET Framework). However, unlike other processes,. NET Framework, as a basic system for SQL Server 2005, provides additional memory and build a management tool SQL Server instead of using the built-in Windows. This increases productivity in comparison with the general algorithms Windows, because of resource allocation algorithms specially configured for use in the structures of SQL Server.