Skip to content
BENIBIX Learn

Microsoft SQL Server

Development🗃️ DatabasesRelational Databases

Also known as SQL Server, MSSQL, MS SQL, Transact-SQL, T-SQL

The database Microsoft makes. Apps talk to it in a kind of SQL called 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.

Example

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

Why it matters

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

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 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.
Here SQL Server stands next to three other well known databases.

Common mistake

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

Key takeaways

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