Microsoft SQL (Structured Query Language) Server is a relational database management system developed by Microsoft. As a database server, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Its primary query languages are T-SQL and ANSI SQL.
Different Version of SQL server.
SQL Server 2005
SQL Server 2005 (formerly codenamed "Yukon") released in October 2005. It included native support for managing XML data, in addition to relational data. For this purpose, it defined an xml data type that could be used either as a data type in database columns or as literals in queries. XML columns can be associated with XSD schemas; XML data being stored is verified against the schema. XML is converted to an internal binary data type before being stored in the database.
SQL Server 2008
SQL Server 2008 (formerly codenamed "Katmai") was released on August 6, 2008and aims to make data management self-tuning, self organizing, and self maintaining with the development of SQL Server Always On technologies, to provide near-zero downtime. SQL Server 2008 also includes support for structured and semi-structured data, including digital media formats for pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as BLOBs (binary large objects), but they are generic bitstreams. Intrinsic awareness of multimedia data will allow specialized functions to be performed on them.
SQL Server 2012
At the 2011 Professional Association for SQL Server (PASS) summit on October 11, Microsoft announced that the next major version of SQL Server (codenamed "Denali"), would be SQL Server 2012. It was released to manufacturing on March 6, 2012. SQL Server 2012 Service Pack 1 was released to manufacturing on November 9, 2012, and Service Pack 2 was released to manufacturing on June 10, 2014.
It was announced to be the last version to natively support OLE DB and instead to prefer ODBC for native connectivity. SQL Server 2012's new features and enhancements include AlwaysOn SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new spatial features, metadata discovery, sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and partition level operations and security enhancements including provisioning during setup, new permissions, improved role management, and default schema assignment for groups.
SQL Server 2014
SQL Server 2014 was released to manufacturing on March 18, 2014, and released to the general public on April 1, 2014. Until November 2013 there were two CTP revisions, CTP1 and CTP2.SQL Server 2014 provides a new in-memory capability for tables that can fit entirely in memory (also known as Hekaton). Whilst small tables may be entirely resident in memory in all versions of SQL Server, they also may reside on disk, so work is involved in reserving RAM, writing evicted pages to disk, loading new pages from disk, locking the pages in RAM while they are being operated on, and many other tasks. By treating a table as guaranteed to be entirely resident in memory much of the 'plumbing' of disk-based databases can be avoided. For disk-based SQL Server applications, it also provides the SSD Buffer Pool Extension, which can improve performance by cache between DRAM and spinning media.
SQL Server 2014 also enhances the AlwaysOn (HADR) solution by increasing the readable secondaries count and sustaining read operations upon secondary-primary disconnections, and it provides new hybrid disaster recovery and backup solutions with Windows Azure, enabling customers to use existing skills with the on-premises version of SQL Server to take advantage of Microsoft's global datacenters.
Different Edition of SQL Server.
SQL Server CE
As you'd expect, SQL Server 2000 Windows CE Edition uses a different code base than other SQL Server editions do. SQL Server CE has about a 1MB footprint and doesn't include Analysis Services or Data Transformation Services (DTS). SQL Server CE supports data exchange with other SQL Server editions through anonymous merge replication.
Enterprise Evaluation Edition
The Enterprise Evaluation Edition is essentially the same as the Enterprise Edition; however, the Evaluation Edition has a built-in 120-day time limit. You can upgrade from the Evaluation Edition to either the standard or enterprise edition.
Developer Edition
Supplied as a part of Visual Studio Enterprise Edition, the Developer Edition supports the same feature set as SQL Server Enterprise Edition does. However, licensing for the Developer Edition allows only development work; you can't use this edition as a production database.
Personal Edition
The Personal Edition comes with the SQL Server Standard Edition or Enterprise Edition—you can't purchase it separately. The Personal Edition runs on Windows 2000, Windows NT, or Windows 9x and supports one to two processors on Win2K Professional. However, this edition supports only five concurrent connections. Each Personal Edition requires a Client Access License (CAL).
MSDE
Microsoft SQL Server Desktop Engine (MSDE) is a standalone runtime engine for database applications and can be freely distributed. MSDE's core database engine is essentially the same as that of the Personal Edition. However, MSDE provides no management tools and doesn't require a CAL.
Standard Edition
The Standard Edition is the most popular version of SQL Server 2000. This edition requires a minimum of Win2K Server or NT Server 4.0 and supports one to four processors. The Standard Edition includes Analysis Services, DTS, XML integration, and English Query, as well as the Personal Edition and MSDE. Each client that connects to the Standard Edition needs a CAL.
Enterprise Edition
The Enterprise Edition includes all the Standard Edition features plus built-in Storage Area Network (SAN) support, federated databases, log shipping, and partitioned OLAP cubes. The Enterprise Edition runs on Win2K Server or NT Server 4.0 or later; when running on Win2K Advanced Server or NT Server, Enterprise Edition (NTS/E), this edition supports more than four processors and four-node failover clustering. Each client must have a CAL.
Different Version of SQL server.
SQL Server 2005
SQL Server 2005 (formerly codenamed "Yukon") released in October 2005. It included native support for managing XML data, in addition to relational data. For this purpose, it defined an xml data type that could be used either as a data type in database columns or as literals in queries. XML columns can be associated with XSD schemas; XML data being stored is verified against the schema. XML is converted to an internal binary data type before being stored in the database.
SQL Server 2008
SQL Server 2008 (formerly codenamed "Katmai") was released on August 6, 2008and aims to make data management self-tuning, self organizing, and self maintaining with the development of SQL Server Always On technologies, to provide near-zero downtime. SQL Server 2008 also includes support for structured and semi-structured data, including digital media formats for pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as BLOBs (binary large objects), but they are generic bitstreams. Intrinsic awareness of multimedia data will allow specialized functions to be performed on them.
SQL Server 2012
At the 2011 Professional Association for SQL Server (PASS) summit on October 11, Microsoft announced that the next major version of SQL Server (codenamed "Denali"), would be SQL Server 2012. It was released to manufacturing on March 6, 2012. SQL Server 2012 Service Pack 1 was released to manufacturing on November 9, 2012, and Service Pack 2 was released to manufacturing on June 10, 2014.
It was announced to be the last version to natively support OLE DB and instead to prefer ODBC for native connectivity. SQL Server 2012's new features and enhancements include AlwaysOn SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new spatial features, metadata discovery, sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and partition level operations and security enhancements including provisioning during setup, new permissions, improved role management, and default schema assignment for groups.
SQL Server 2014
SQL Server 2014 was released to manufacturing on March 18, 2014, and released to the general public on April 1, 2014. Until November 2013 there were two CTP revisions, CTP1 and CTP2.SQL Server 2014 provides a new in-memory capability for tables that can fit entirely in memory (also known as Hekaton). Whilst small tables may be entirely resident in memory in all versions of SQL Server, they also may reside on disk, so work is involved in reserving RAM, writing evicted pages to disk, loading new pages from disk, locking the pages in RAM while they are being operated on, and many other tasks. By treating a table as guaranteed to be entirely resident in memory much of the 'plumbing' of disk-based databases can be avoided. For disk-based SQL Server applications, it also provides the SSD Buffer Pool Extension, which can improve performance by cache between DRAM and spinning media.
SQL Server 2014 also enhances the AlwaysOn (HADR) solution by increasing the readable secondaries count and sustaining read operations upon secondary-primary disconnections, and it provides new hybrid disaster recovery and backup solutions with Windows Azure, enabling customers to use existing skills with the on-premises version of SQL Server to take advantage of Microsoft's global datacenters.
Different Edition of SQL Server.
SQL Server CE
As you'd expect, SQL Server 2000 Windows CE Edition uses a different code base than other SQL Server editions do. SQL Server CE has about a 1MB footprint and doesn't include Analysis Services or Data Transformation Services (DTS). SQL Server CE supports data exchange with other SQL Server editions through anonymous merge replication.
Enterprise Evaluation Edition
The Enterprise Evaluation Edition is essentially the same as the Enterprise Edition; however, the Evaluation Edition has a built-in 120-day time limit. You can upgrade from the Evaluation Edition to either the standard or enterprise edition.
Developer Edition
Supplied as a part of Visual Studio Enterprise Edition, the Developer Edition supports the same feature set as SQL Server Enterprise Edition does. However, licensing for the Developer Edition allows only development work; you can't use this edition as a production database.
Personal Edition
The Personal Edition comes with the SQL Server Standard Edition or Enterprise Edition—you can't purchase it separately. The Personal Edition runs on Windows 2000, Windows NT, or Windows 9x and supports one to two processors on Win2K Professional. However, this edition supports only five concurrent connections. Each Personal Edition requires a Client Access License (CAL).
MSDE
Microsoft SQL Server Desktop Engine (MSDE) is a standalone runtime engine for database applications and can be freely distributed. MSDE's core database engine is essentially the same as that of the Personal Edition. However, MSDE provides no management tools and doesn't require a CAL.
Standard Edition
The Standard Edition is the most popular version of SQL Server 2000. This edition requires a minimum of Win2K Server or NT Server 4.0 and supports one to four processors. The Standard Edition includes Analysis Services, DTS, XML integration, and English Query, as well as the Personal Edition and MSDE. Each client that connects to the Standard Edition needs a CAL.
Enterprise Edition
The Enterprise Edition includes all the Standard Edition features plus built-in Storage Area Network (SAN) support, federated databases, log shipping, and partitioned OLAP cubes. The Enterprise Edition runs on Win2K Server or NT Server 4.0 or later; when running on Win2K Advanced Server or NT Server, Enterprise Edition (NTS/E), this edition supports more than four processors and four-node failover clustering. Each client must have a CAL.
No comments:
Post a Comment