SQL Server 2012 notes Sharing -1:sql Server version evolution

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!