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
No comments:
Post a comment