Database tools overview
Database tools overview
MS SQL Server
Microsoft SQL Server is chosen for business needs due to its scalability, high performance, robust security features, and support for high availability and disaster recovery.
It offers a comprehensive Business Intelligence (BI) platform, seamless integration with Microsoft products, powerful development tools, and advanced analytics capabilities. SQL Server supports multiple data types, integrates with the cloud, and provides flexibility in licensing options, making it a versatile and reliable choice for organizations seeking a database management system to meet their data storage, processing, and analysis requirements.
MS SQL Server History
Product Version | Release Date | Product name |
1989 | SQL Server 1.0 (16-bit) | |
1990 | SQL Server 1.1 (16-bit) | |
1992 | SQL Server 4.2A | |
1993 | SQL Server 4.2B (16-bit) | |
1993 | SQL Server 4.21a | |
6.0 | 1995 | SQL Server 6.0 |
6.5 | 1996 | SQL Server 6.5 |
7.0 | 1998 | SQL Server 7.0 |
— | 1999 | SQL Server 7.0 OLAP Tools |
8.0 | 2000 | SQL Server 2000 |
8.0 | 2003 | SQL Server 2000 64-bit Edition |
9.0 | January 14, 2006 | SQL Server 2005 |
10.0 | November 6, 2008 | SQL Server 2008 |
10.25 | 2010 | Azure SQL database (initial release) |
10.50 | July 20, 2010 | SQL Server 2008 R2 |
11.0 | May 20, 2012 | SQL Server 2012 |
12.0 | 2014 | Azure SQL database |
12.0 | June 5, 2014 | SQL Server 2014 |
13.0 | June 1, 2016 | SQL Server 2016 |
14.0 | September 29, 2017 | SQL Server 2017 |
15.0 | November 4, 2019 | SQL Server 2019 |
16.0 | November 16, 2022 | SQL Server 2022 |
MS SQL Server Installation options
MS SQL Server (full) (service based)
MS SQL Server (express) (service based)
LocalDB (downsized Version of MS SQL Server) (file based)
UI options for SQL Server:
SSMS
SQL Server Data Tools (integrated in Visual Studio)
Command line interface (CLI)
Last updated