Microsoft SQL Server Introduction

Microsoft SQL Server Introduction

In this tutorial, we will learn about Microsoft SQL Server Introduction, SQL Server is a Relational Database Management System developed by Microsoft. SQL Server primary function is storing and retrieving data through applications.

Microsoft SQL Server comes in different editions: Enterprise, Buisness Intelligence, Standard, Web, Developer, Express

Microsoft SQL Server Components are following:

Server components Description
SQL Server Database Engine SQL Server Database Engine main functionality is storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, and the Data Quality Services (DQS) server.
Analysis Services Analysis Services is used for creating and managing online analytical processing (OLAP) and data mining applications.
Reporting Services Reporting Services includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports.
Integration Services Integration Services is a set of graphical tools and programmable objects for moving, copying, and transforming data.
Master Data Services Master Data Services (MDS) is the SQL Server solution for master data management. MDS can be configured to manage any domain (products, customers, accounts) and includes hierarchies, granular security, transactions, data versioning, and business rules.

Microsoft SQL Server history:

SQL Server version history: Reference: https://en.wikipedia.org/wiki/Microsoft_SQL_Server

Version Year Release name Code name Internal version
1.0 (OS/2) 1989 SQL Server 1.0 (16 bit) Ashton-Tate / Microsoft SQL Server
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 515
1999 SQL Server 7.0 OLAP Tools Palato mania
8 2000 SQL Server 2000 Shiloh 539
8 2003 SQL Server 2000 64-bit Edition Liberty 539
9 2005 SQL Server 2005 Yukon 611/612
10 2008 SQL Server 2008 Katmai 661
10.25 2010 Azure SQL DB Cloud Database or CloudDB
10.5 2010 SQL Server 2008 R2 Kilimanjaro (aka KJ) 665
11 2012 SQL Server 2012 Denali 706
12 2014 SQL Server 2014 SQL14 782
13 TBD SQL Server 2016