🗃️Microsoft SQL Server
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
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
Example code
sql
SELECT TOP 5 name, total
FROM orders
ORDER BY total DESC;Common mistake
Key takeaways
- 1From Microsoft. It fits with Windows and Azure tools.
- 2Speaks T-SQL. Mostly standard SQL, with its own extras.
- 3Windows or Linux. It also runs in containers.