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 | – | – |