It is a Relational Database Management System (RDBMS) developed by Microsoft. It is a highly scalable product that can be run on any machine eg. laptop,network of high-powered cloud servers etc.
Database Management Tools
SQL Server contains many tools to help you with your database administration and programming tasks.
Some typical database administration and programming tasks could include:
- Create & maintain databases
- Create & maintain tables
- Create & maintain other database objects such as stored procedures, views, etc
- Create & maintain and schedule data backups
- Replication (eg, create a copy of the database)
- Create & maintain users, roles, etc
- Optimization tasks
SQL Server 2016 Editions
SQL Server 2016 comes in five editions: