Microsoft's SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality. It originated from Sybase SQL Server 4.x codebase and Transact-SQL dialect (T-SQL), but forked significantly since then.

SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. The latest released version is SQL Server 2008 R2.

The SQL Server product range is split broadly into 4 categories:

1. SQL Server main suite of enterprise and developer server products. Primary differences are licencing costs, capacities, and components included in the product, with some minor differences supported language features. Standard components include db language and storage server, developer tools, ETL tools, schedulers, replication. Other components include OLAP, reporting, parallel compute. Components runs as NT Services.

2. SQL Server Express free for use and distribution but reduced engine performance, functionality and capacity than found it's other server siblings. Focused on small deployments. Runs as an NT Service.

3. SQL Server Compact an embeddable subset of SQL Server. Like Express edition is has reduced language, functionality and capacity, but is free to distribute. It's focused on small installations and desktop applications where it's small footprint and no-management-required features are a great advantage.

4. SQL Azure completely managed, hosted, high-availability instance of SQL Server 2005 with some language syntax support federated query, operated in Microsoft Azure datacenters.

References

• MSDN SQL Server 2005 Transact-SQL Reference
• MSDN SQL Server 2008 R2 Transact-SQL Reference
• SQL Server Wikipedia Article
• SQL Azure Stack-Overflow Tag

Popular Questions

• Hidden Features of SQL Server
• What is the difference between VARCHAR and NVARCHAR
• Is there a combination of “LIKE” and “IN” in SQL?
• http://stackoverflow.com/questions/198478/advantages-of-ms-sql-server-2008-over-ms-sql-server-2005

Microsoft's SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality. It originated from Sybase SQL Server 4.x codebase and Transact-SQL dialect (T-SQL), but forked significantly since then.

SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality.

The SQL Server product range is split broadly into 4 categories:

1. SQL Server main suite of enterprise and developer server products. Primary differences are licencing costs, capacities, and components included in the product, with some minor differences supported language features. Standard components include db language and storage server, developer tools, ETL tools, schedulers, replication. Other components include OLAP, reporting, parallel compute. Components runs as NT Services.

2. SQL Server Express free for use and distribution but reduced engine performance, functionality and capacity than found it's other server siblings. Focused on small deployments. Runs as an NT Service.

3. SQL Server Compact an embeddable subset of SQL Server. Like Express edition is has reduced language, functionality and capacity, but is free to distribute. It's focused on small installations and desktop applications where it's small footprint and no-management-required features are a great advantage.

4. SQL Azure completely managed, hosted, high-availability instance of SQL Server 2005 with some language syntax support federated query, operated in Microsoft Azure datacenters.

References

• MSDN SQL Server Transact-SQL Reference
• SQL Server Wikipedia Article
• [sql-azure] Stack Overflow Tag
• [sql-server] Stack Overflow Tag

Microsoft's SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality. It originated from Sybase SQL Server 4.x codebase and Transact-SQL dialect (T-SQL), but forked significantly since then.

SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. The latest released version is SQL Server 2008 R2.

The SQL Server product range is split broadly into 4 categories:

1. SQL Server main suite of enterprise and developer server products. Primary differences are licencing costs, capacities, and components included in the product, with some minor differences supported language features. Standard components include db language and storage server, developer tools, ETL tools, schedulers, replication. Other components include OLAP, reporting, parallel compute. Components runs as NT Services.

2. SQL Server Express free for use and distribution but reduced engine performance, functionality and capacity than found it's other server siblings. Focused on small deployments. Runs as an NT Service.

3. SQL Server Compact an embeddable subset of SQL Server. Like Express edition is has reduced language, functionality and capacity, but is free to distribute. It's focused on small installations and desktop applications where it's small footprint and no-management-required features are a great advantage.

4. SQL Azure completely managed, hosted, high-availability instance of SQL Server 2005 with some language syntax support federated query, operated in Microsoft Azure datacenters.

References

• MSDN SQL Server 2005 Transact-SQL Reference
• MSDN SQL Server 2008 R2 Transact-SQL Reference
• SQL Server Wikipedia Article
• SQL Azure Stack-Overflow Tag

Popular Questions

• Hidden Features of SQL Server
• What is the difference between VARCHAR and NVARCHAR
• Is there a combination of “LIKE” and “IN” in SQL?
• http://stackoverflow.com/questions/198478/advantages-of-ms-sql-server-2008-over-ms-sql-server-2005