SQL Server is a relational database management system (RDBMS) developed by Microsoft, initially, it was known as Sybase SQL Server. It has several programming interfaces, including SQL (Structured Query Language), ADO.NET, OLE DB and Java Database Connectivity (JDBC).
SQL Server is not only a database management system but also a software that includes: Database Engine (storage and retrieval of data), Analysis Services (for creating reports, multidimensional analysis), Reporting Service (creation of reports, Integration Services (mainly used for ETL jobs), Data Quality Services (for data cleansing and data deduplication), Master Data Services (mainly used for master data management), Analysis Services (for creating reports, multidimensional analysis) and Management Tools (SQL Server Management Studio)
Why SQL Server?
- It has the possibility of high availability thanks to its two-phase commit transactions. They ensure that all data is consistent in different databases.
- Transactions that are executed in parallel due to its multithreading mechanism.
- High data compression because of the use of page-level storage (sometimes data is divided into pages)
- Full recovery model that lets you automatically create backups of all your databases, which are easy to restore in case of damage.
- Capacity to do reads and writes simultaneously because it uses a multi-version concurrency control mechanism. This basically consists of the use of several versions to perform work. Each version is a read-write transaction.
- Management of levels of security thanks to its granular permissions.