Microsoft SQL Server, a Relational Database Management System
Microsoft SQL Server is a relational database management system that supports transaction processing, business intelligence, and analytics applications within IT environments. It's one of the three market-leading database technologies, along with Oracle Database and IBM's DB2.
Microsoft SQL Server has many different editions developed for workloads that range from single-machine applications to huge internet applications that have substantial number of users.
Microsoft SQL Server is developed on top of a database programming language SQL used by many database administrators and other IT specialists to:
- compile databases
- support and maintain databases
- interpret the data through SQL Server Analysis Services
- generate reports through SQL Server Reporting Services
- perform ETL procedures through SQL Server Integration Services
SQL Server 2016 has new advanced features for operational analytics performed in real time, reporting on a variety of mobile devices, and data visualization. It also features hybrid cloud support that makes it possible for DBAs to run databases on different cloud services and reduce IT costs. Besides, SQL Server 2016 is the first version of database management systems that runs exclusively on x64 microprocessors.
Microsoft SQL Server2016 is available in four primary editions that offer different levels of bundled services. A full-featured Developer edition and an Express edition for small databases up to 10 GB are free. For larger databases, Microsoft offers an Enterprise edition that has all SQL Server’s features and a Standard one that provides a feature set.
Microsoft SQL Server 2016 has advanced security features that include three technologies: Always Encrypted, dynamic data masking, and row-level security.