Microsoft SQL Server is a relational DBMS from Microsoft. In early versions were used for medium-sized databases, but from the 2000 version was also used to manage large data bases.
The entry of Microsoft into the world of database-end "enterprise" dates back to 1989 when he began the competition with Oracle, IBM and Sybase, who were the rulers of the market. The first version was SQL Server for OS / 2 and was almost the same as Sybase SQL Server 4.0 on Unix.
Until 1994, Microsoft SQL Server reported Sybase three of copyright as an indication of its origin, and later Sybase changed the name of its product in "Adaptive Server Enterprise" to avoid confusion with "Microsoft SQL Server".
SQL Server 7.0 was the first database server based graphical interface. The current version of Microsoft SQL Server 2005 (9.0), was released in November 2005.
Microsoft SQL Server uses a variant of the SQL language standard (the ISO certificate in 1992) called T-SQL Transact-SQL. Both Microsoft SQL Server and Sybase Adaptive Server Enterprise communicate over the network using an application-level protocol called Tabular Data Stream (TDS). SQL Server also supports Open Database Connectivity (ODBC).
For those approaching the management of professional db, definitely a good "fitness" to practice is a small version of Microsoft SQL Server 2000 called MSDE (Microsoft SQL Server Desktop Engine), was distributed with products such as Visual Studio, Microsoft Access and others. MSDE has some restrictions: only supports databases with a maximum size of 2GB, no tools and is scheduled to be administered to poor performance when it exceeds the 8 concurrent accesses.
Today Microsoft released the successor to MSDE: SQL Server 2005 Express (which is already available SP1) Similar to MSDE, SQL Server 2005 Express includes all the main features SQL Server 2005, but has some restrictions on the scalability of the database and can use only one CPU, 1GB of RAM and supports database with maximum size up to 4GB. SQL Server 2005 Express also includes enterprise products as "Analysis Services", "Reporting Services", "Data Transformation Services" and "Notification Services". Unlike MSDE, SQL Server Express includes an administration console called "SQL Server Management Studio Express".
We see in detail the pair of applications:
1) Microsoft SQL Server 2005 Express Edition (SQL Server Express) is a powerful and reliable data management, providing functionality advanced data protection and performance for embedded application clients, light Web applications, and local data stores. Designed for easy deployment and rapid prototyping, SQL Server Express is free and can be freely redistributed with applications. SQL Server Express is designed to integrate fully with all other investments that make up the server infrastructure.
2) Microsoft SQL Server Management Studio Express (SSMSE) is a graphical tool free and easy to use for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. SSMSE can also manage instances of SQL Server Database Engine created by any edition of SQL Server 2005.
For more information, please visit the site dedicated to Microsoft SQL Server: http://www.microsoft.com/italy/server/sql/
0 comments:
Post a Comment