# Microsoft SQL Server

> The database Microsoft makes. Apps talk to it in a kind of SQL called T-SQL.

**Field:** Software Development  
**Category:** Databases  
**Also known as:** SQL Server, MSSQL, MS SQL, Transact-SQL, T-SQL

## Think of it like

It is like a big locked room full of files. A guard at the desk checks who may come in.

## Definition

Microsoft SQL Server is a database made by Microsoft. Apps talk to it in its own kind of SQL, called Transact-SQL or T-SQL. It runs on Windows and on Linux, and in containers. Many big firms use it, often next to other Microsoft tools. The same engine also runs in Microsoft's cloud, as Azure SQL Database.

## Example

Jack joins a bank whose main app keeps its data in SQL Server. He writes his reports in T-SQL.

## Example code

```sql
SELECT TOP 5 name, total
FROM orders
ORDER BY total DESC;
```

TOP 5 is T-SQL. Many other databases write LIMIT 5 at the end instead.

## Why it matters

It is one of the most used databases in large companies. Many jobs in banks, shops and offices ask for it.

## Common mistake

Copying SQL from a PostgreSQL or MySQL guide as it is. Most of it works, but parts like TOP and LIMIT differ.

## Three principles

- **From Microsoft.** It fits with Windows and Azure tools.
- **Speaks T-SQL.** Mostly standard SQL, with its own extras.
- **Windows or Linux.** It also runs in containers.

## Related terms

- [Relational Database](https://learn.benibix.com/term/development/relational-database)
- [PostgreSQL](https://learn.benibix.com/term/development/postgresql)
- [MySQL](https://learn.benibix.com/term/development/mysql)
- [Structured Query Language (SQL)](https://learn.benibix.com/term/development/sql)
- [Microsoft Azure](https://learn.benibix.com/term/infrastructure/microsoft-azure)

![Four relational databases in a row: PostgreSQL, MySQL, SQLite and Microsoft SQL Server, with a note that SQL Server speaks a version of SQL called T-SQL. Above PostgreSQL sits a larger box for Supabase. It holds a Postgres database and adds login, file storage, live updates and a ready-made API around it.](https://learn.benibix.com/diagrams/dev-db-products.svg)

---

Source: https://learn.benibix.com/term/development/sql-server
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
