SQL is an abbreviation for the English Structured Query language, meaning Structured query language. The main function of the SQL language is to connect with various databases and communicate with each other. According to ANSI (National Standards Association), SQL is used as the standard language of the relational database management system. SQL statements can be used to perform a variety of operations, such as updating data in a database, extracting data from a database, and so on. Currently, the vast majority of popular relational database management systems, such as Oracle, Sybase, Microsoft SQL Server, Access, and so on, have adopted the SQL language standard.
The history of SQL Server version evolution is as follows
1989:sql Server 1.0
originated in Sybase SQL Server (originating from Sybase database)
1993:sql Server 4.21
Run on Windows NT, 32-bit (capable of running on a 32-bit Windows NT system)
1996:sql Server 6.5
Enterprise Ready (for business), ANSI standard (ANSI standards supported), Data Warehouse (DW)
1998:sql Server 7.0
Rewritten from Sybase code (rewriting Sybase codes), new database engine, OLAP online analytical processing (online analytical Processing)
2000:sql Server 2000
Performance (performance boost), 64-bit (supports 64-bit architecture), high availability (highly available), Reporting (report)
2005:sql Server 2005
Database mirroring (DB mirroring), table partitioning (table partitioning), XML,. NET integration (integrated. NET), ETL
2008:sql Server 2008
Manageability (manageability), encryption (encryption), Compression (compression), new data types (the latest type), BI (Business intelligence)
2008:sql Server R2
Master Data Services, multi-server administration (Multi-server management)
2008:sql Server 2012
AlwaysOn availability Groups (AlwaysOn High Availability Group), Extended events (extended event)
This article from "Zeng Hung Xin Technical column" blog, declined to reprint!