What is SQL Server? Why we use SQL Server? SQL Server Components? Versions of SQL Server

What is SQL Server?

SQL Server is software, developed by Microsoft for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications. Sql server is platform dependent and it is both GUI and command based software.

It is also a business intelligence platform for data integration, analysis, and reporting solutions.

Why we use SQL Server?

• For the purpose to create and maintain databases.
• To generate reports through SQL Server Reporting Services (SSRS)
• You can use Sql to analyse the data through SQL Server Analysis Services.

SQL Server Components

The diagram shows the relationships among SQL Server 2005 components and identifies interoperability between components.

• Database Engine: - It is the core service to storing, processing, and securing data.
• Reporting Services (SSRS): - It is a server-based reporting platform that provides comprehensive data reporting from relational and multidimensional data sources.
• Analysis Services: - It supporting rapid analysis of business data, delivering online analytical processing and data mining functionality in business intelligence applications
• Notification Services: - Notification Services is a platform for developing applications that generate and send notifications, and it is also an engine that runs those applications
• Integration Services: - Integration Services (SSIS) is the extract, transform, and load (ETL) component of SQL Server
• Full-Text Search: - SQL Server contains the functionality you need to issue full-text queries against plain character-based data in SQL Server tables
• Replication: - Replication is a set of technologies for copying and distributing data and database objects from one database to another, and then synchronizing between databases to maintain consistency.
• Service Broker: - Service Broker provides the SQL Server Database Engine native support for messaging and queuing applications

Versions of SQL Server

Version	Year	Release Name	Codename
1 (OS/2)	1989	SQL Server 1.0 (16 bit)	–
1.1 (OS/2)	1991	SQL Server 1.1 (16 bit)	–
4.21 (WinNT)	1993	SQL Server 4.21	SQLNT
6	1995	SQL Server 6.0	SQL95
6.5	1996	SQL Server 6.5	Hydra
7	1998	SQL Server 7.0	Sphinx
8	2000	SQL Server 2000	Shiloh
9	2005	SQL Server 2005	Yukon
10	2008	SQL Server 2008	Katmai
10.25	2010	SQL Azure DB	CloudDatabase
10.5	2010	SQL Server 2008 R2	Kilimanjaro (aka KJ)
11	2012	SQL Server 2012	Denali
12	2014	SQL Server 2014	Hekaton
13	2016	SQL Server 2016	Helsinki

Advantages of Sql Server

• Provide Easy Installation
• Improved Performance
• Support multiple Editions and Price Variations.
• Provide excellent Security
• Data Restoration and Recovery Mechanism