Introduction to SQL Server

SQL Server

SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments.

SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL.

Why SQL Server?

Microsoft SQL Server is a comprehensive database server and information platform offering a complete set of enterprise-ready technologies and tools that help people derive the most value from information at the lowest total-cost-of-ownership. Enjoy high levels of performance, availability, and security; employ more productive management and development tools; and deliver pervasive insight with self-service business intelligence (BI).

A complete and integrated platform, Microsoft SQL Server brings it all together to get more value out of existing IT skills and assets, increase the productivity and agility of IT departments, and quickly build flexible, innovative applications.

SQL Server works exclusively on Windows environment for more than 20 years. In 2016, Microsoft made it available on Linux. SQL Server 2017 became generally available in October 2016 that ran on both Windows and Linux.

SQL Server Architecture

SQL Server Architecture
SQL Server Architecture
SQL Server Architecture Components
SQL Server Architecture Components

The diagram above gives you an overview of what the SQL Server architecture looks like. There are 3 important items here:

Database Engine

Performs the storage and query processing tasks.

SQL Operating System

Works on I/O and other higher level management tasks.

Interfaces

The External Protocols and SQL Operating System API connect the dots.

The Database engine is the heart of Microsoft SQL Server. Think of it as the engine of a motorcycle, it is the part where the real stuff happens. It contains 2 major components:

Query processor

Parses, optimizes and executes the query.

Storage engine

Manages buffer and access methods.

 

Published by Abdul Samad

Having 17+ years of extensive experience in IT industry, enabled to enhance the team performance and maximize customer satisfaction by strategically managing calls and implementing process improvements. Demonstrated ability to solve problems, meets challenging goals, and expedites delivery. Skilled MSSQL administrator guide team during the crisis situation. Apply Creative thoughts process in re-designing the workflow system to eliminate duplication of effort and increase productivity.

Leave a Reply