DB-Tools.com - system comparision
23rd September 2020, Wednesday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System AWS Redshift Microsoft SQLServer
 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 -- No
 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 -- No
 Replication -- Yes
 Secondary Indexes -- Yes
 SchemaLess -- No
 SQL Query -- Yes