Introduction of MS SQL Server Last Updated : 15 Jul, 2025 Comments Improve Suggest changes Like Article Like Report Data is a collection of facts and figures and we have humungous data available to the users via the internet and other sources. To manipulate the data, Structured Query Language (SQL) in short has been introduced years ago. There are different versions of SQL available in the market provided by different organizations. In this article, we shall see the version of SQL provided by Microsoft. Introduction : Microsoft SQL Server or MS SQL Server for short is the query language provided for data definition and manipulation. SQL Server is a Relational Database Management Systems which was developed and marketed by the Microsoft company. SQL and SQL servers are built as two layers where the SQL server is on the top for interacting with the relational databases. MS SQL Server also has T-SQL or Transact-SQL and the main focus of T-SQL is to handle the transactions. As it is a Microsoft's developed system, it worked only on Microsoft's environment until it was made available on Linux platforms in the year 2016. SQL Server is composed of: Database engine, and Relational engine, and Storage engine. These are explained as following below. 1. Database Engine - Database is a collection of various data items on which the user can perform any kind of manipulations. The database engine has a relational engine on which a user can perform queries and it also comes with a storage engine which manages the data files, indexes and procedures. The database engine also creates and executes objects like triggers, views, procedures etc. 2. Relational Engine - Relations are the connections between the two different databases or within the same database. It is stored in the form of a row and column intersection named tables. It manages query processing, memory management, buffer management, threads, and much more. It has another layer named storage engine. 3. Storage Engine - It looks upon the storage of data. It is done using systems like disks and Storage Area Network or SAN. Comment More info M mangalgiaishwarya2 Follow Improve Article Tags : SQL DBMS-SQL SQL-Server Explore SQL Tutorial 7 min read BasicsWhat is SQL? 6 min read SQL Data Types 3 min read SQL Operators 5 min read SQL Commands | DDL, DQL, DML, DCL and TCL Commands 5 min read SQL Database Operations 3 min read SQL CREATE TABLE 3 min read Queries & OperationsSQL SELECT Query 2 min read SQL INSERT INTO Statement 4 min read SQL UPDATE Statement 3 min read SQL DELETE Statement 3 min read SQL - WHERE Clause 3 min read SQL | Aliases 3 min read SQL Joins & FunctionsSQL Joins (Inner, Left, Right and Full Join) 4 min read SQL CROSS JOIN 2 min read SQL | Date Functions 4 min read SQL | String functions 6 min read Data Constraints & Aggregate FunctionsSQL NOT NULL Constraint 2 min read SQL PRIMARY KEY Constraint 5 min read SQL Count() Function 7 min read SQL SUM() Function 5 min read SQL MAX() Function 4 min read AVG() Function in SQL 4 min read Advanced SQL TopicsSQL Subquery 4 min read Window Functions in SQL 6 min read SQL Stored Procedures 7 min read SQL Triggers 5 min read SQL Performance Tuning 6 min read SQL TRANSACTIONS 6 min read Database Design & SecurityIntroduction of ER Model 10 min read Introduction to Database Normalization 6 min read SQL Injection 11 min read SQL Data Encryption 5 min read SQL Backup 4 min read What is Object-Relational Mapping (ORM) in DBMS? 7 min read Like