MS SQL Server

MS SQL Server is a Relational Database Management System developed by Microsoft Corp. MS SQL Server is an enterprise level database competing with products like Oracle and DB2. MS SQL Server cost much less than its comparable competitors products, hence its popularity.

As many of the Microsoft products this database has its origins in other company’s product namely Sybase SQL Server.

MS SQL Server is a paid database server, but it has a free limited version called MSDE (Microsoft SQL Server Desktop Engine). MSDE version of MS SQL Server is free for re-distribution with desktop applications. As we mentioned MSDE has certain restrictions, like:

· The maximum size of a database is 2 GB
· MSDE comes with no administration tools.
· MSDE has has a governor which will slower the db server response once you exceed 5 concurrent connections to it.

MS SQL Server uses SQL as its standard database language. The SQL dialect used by MS SQL Server is called T-SQL.

MS SQL Server fully supports ODBC.

The latest MS SQL Server version available on the market is MS SQL Server 2005.

SQL Tutorial

Database Directory

Databases
DB2
Informix
Microsoft Access
MS SQL Server
MySQL
Oracle
PostgreSQL
SQLite
ThinkSQL

Database Articles
Business Intelligence
Data Backup
Data Mining
Data Protection
Data Recovery
Data Warehousing
Database Design
Databases and Web Hosting
OLAP
RAID - Redundant Array of Independent Disks
MS SQL Server 2005 Released
SQL Training
What is a database?
What is RDBMS?
What is SQL?
© Art Branch Inc.

Database Directory > MS SQL Server