DB-tools.com - Microsoft SQLServer System Properties and Rank as per its popurality

Editorial information provided by DB-Tools

System

Db-Tools Ranking

Trend Rank

Name

Microsoft SQL Server

Version

Sqlserver 2017

Drawbacks

high license costs. Applicable for transaction systems in large enterprises

Advantages

ACID compliant. Easy to use User Interface

Languages Supported

C# C++ Delphi Go Java JavaScript (Node.js) PHP Python R (Microsoft R) Ruby Visual Basic

Website

www.microsoft.com/en-us/sql-server

XML Support

yes

JSON Support

yes

Brief description

As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications�which may run either on the same computer or on another computer across a network (including the Internet).

Database Model

Primarily a relational database

Technical Documentation

docs.microsoft.com/�en-ie/�sql/�sql-server/�sql-server-technical-documentation

License

Commercial

Cloud-based / SaaS

Available in AWS, Azure Clouds. Available as a SaaS option in Microsoft Cloud

Implementation Language

C,C++

Operating System Supported

Linux Windows

Options for Integration / Access API

OLE DB, Tabular Data Stream (TDS), ADO.NET, JDBC, ODBC

Consistency

Highly Consistent

Foreign Keys

Yes

Streaming Support

Analytics Support

Need to buy SQLServer Analytics Pack (SSAS)

Data Storage Schema

Relational Database

Notable Users

Most of the Fortune 500 Companies

Key Differentiator

Highly reliable as a transactional database

Concurrency

Yes

Partitioning

Replication

Yes

Secondary Indexes

Yes

SchemaLess

SQL Query

Yes

Home > System Comparision

Microsoft SQLServer System Properties

As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications�which may run either on the same computer or on another computer across a network (including the Internet).