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
1.0 (OS/2)	1989	SQL Server 1.0 (16-bit)
1.1 (OS/2)	1990	SQL Server 1.1 (16-bit)
4.2A (OS/2)	1992	SQL Server 4.2A
4.2B (OS/2)	1993	SQL Server 4.2B (16-bit)
4.21a (WinNT)	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

1. MS SQL Server (full) (service based)

2. MS SQL Server (express) (service based)

3. LocalDB (downsized Version of MS SQL Server) (file based)

UI options for SQL Server:

1. SSMS

2. SQL Server Data Tools (integrated in Visual Studio)

3. Command line interface (CLI)