Latest Post

Friday, 22 September 2017

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

Government Jobs