Microsoft SQL Server

SQL is a database developed by Microsoft client / server (instead of Access). It actually allows more simultaneous connections and greater stability. The controls are similar to MySQL even if the options of most instructions are not compatible for the use of tables. Unlike Access, Requests are made at the programming language, not directly integrated.

The applications are based are two solutions to manage the database:

The first solution is free and based on MSDE and SQL Server Express Edition. Both versions

• MSDE no longer followed by Microsoft since 2007 and does not supported by Vista and Seven: Its limitations are in the size of the database (2 GB maximum), level of simultaneous access (5 maximum not to reduce performance) and does not include user interface. It accepts version 2000 all operating systems from 98 to 2003.
• SQL Server 2005 Express Edition Vista accepts and Seven since Service Pack 2, but also Windows 2000 SP4, XP SP2 and 2003 Server SP1 and higher. In addition to a GUI (albeit small), the Express Edition version no longer limits the number of simultaneous users, accte databases up to 4 GB. Its limitations are the number of processor (1 maximum) but accepts the multi-core. This version is downloadable for free on the Microsoft site.

The second option (but not free) is based SQL Server (2005 and 2008). These versions are running on XP SP2, Vista Business (for the 2008 version) and the various server versions 2003 and 2008 (SBS Premium versions integrates directly). Different versions are available depending on the number of processors supported on the server and the maximum size of memory. As for 2003 or 2008, these versions are assosciated with a maximum number of users who may need to be increased by purchasing additional CALs. The server versions are directly managed as components Active Directory Service.

Related terms: Virtual server - HPC (supercomputers) - Database - MySQL - Exchange