Microsoft SQL Server Features
What are the features of Microsoft SQL Server?
Database Features
- Storage
- Availability
- Stability
- Scalability
- Security
- Data Manipulation
- Query Language
Maintenance
- Data Migration
- Backup and Recovery
- Multi-User Environment
Management
- Data dictionary
- Query Language
- Data Modeling
- Performance Analysis
Security
- User Access Control
Top Rated Microsoft SQL Server Alternatives
(0)
0.0 out of 5
Visit Website
Sponsored
Technology Glossary Features
View definitions of the features and discover new technology terms.
MS SQL Categories on G2
Filter for Features
Database Features
Storage | As reported in 1247 Microsoft SQL Server reviews. | 89% (Based on 1,247 reviews) | |
Availability | Based on 1252 Microsoft SQL Server reviews. | 90% (Based on 1,252 reviews) | |
Stability | 1260 reviewers of Microsoft SQL Server have provided feedback on this feature. | 89% (Based on 1,260 reviews) | |
Scalability | As reported in 1226 Microsoft SQL Server reviews. | 87% (Based on 1,226 reviews) | |
Security | 1228 reviewers of Microsoft SQL Server have provided feedback on this feature. | 88% (Based on 1,228 reviews) | |
Data Manipulation | See feature definition | This feature was mentioned in 1235 Microsoft SQL Server reviews. | 88% (Based on 1,235 reviews) |
Query Language | Based on 1255 Microsoft SQL Server reviews. | 91% (Based on 1,255 reviews) |
Database
Real-Time Data Collection | As reported in 49 Microsoft SQL Server reviews. Collects, stores, and organizes massive, unstructured data in real time | 87% (Based on 49 reviews) | |
Data Distribution | Based on 50 Microsoft SQL Server reviews. Facilitates the disseminating of collected big data throughout parallel computing clusters | 89% (Based on 50 reviews) | |
Data Lake | As reported in 47 Microsoft SQL Server reviews. Creates a repository to collect and store raw data from sensors, devices, machines, files, etc. | 84% (Based on 47 reviews) |
Integrations
Hadoop Integration | Based on 38 Microsoft SQL Server reviews. Aligns processing and distribution workflows on top of Apache Hadoop | 79% (Based on 38 reviews) | |
Spark Integration | Aligns processing and distribution workflows on top of Apache Hadoop This feature was mentioned in 38 Microsoft SQL Server reviews. | 83% (Based on 38 reviews) |
Platform
Machine Scaling | As reported in 43 Microsoft SQL Server reviews. Facilitates solution to run on and scale to a large number of machines and systems | 83% (Based on 43 reviews) | |
Data Preparation | As reported in 46 Microsoft SQL Server reviews. Curates collected data for big data analytics solutions to analyze, manipulate, and model | 86% (Based on 46 reviews) | |
Spark Integration | Aligns processing and distribution workflows on top of Apache Hadoop 38 reviewers of Microsoft SQL Server have provided feedback on this feature. | 83% (Based on 38 reviews) |
Processing
Cloud Processing | Moves big data collection and processing to the cloud This feature was mentioned in 45 Microsoft SQL Server reviews. | 85% (Based on 45 reviews) | |
Workload Processing | Processes batch, real-time, and streaming data workloads in singular, multi-tenant, or cloud systems 48 reviewers of Microsoft SQL Server have provided feedback on this feature. | 84% (Based on 48 reviews) |
Maintenance
Data Migration | Based on 128 Microsoft SQL Server reviews. Allows data movement from one database to another. | 90% (Based on 128 reviews) | |
Backup and Recovery | Provides data backup and recovery functionality to protect and restore a database. This feature was mentioned in 133 Microsoft SQL Server reviews. | 90% (Based on 133 reviews) | |
Multi-User Environment | Based on 129 Microsoft SQL Server reviews. Allows users to access and work on data concurrently, supporting several views of the data. | 90% (Based on 129 reviews) |
Management
Data dictionary | Based on 128 Microsoft SQL Server reviews. Stores the database metadata, that is the definitions of data elements, types, relationships etc. | 89% (Based on 128 reviews) | |
Data Replication | Creates a copy of the database to maintain consistency and integrity. This feature was mentioned in 127 Microsoft SQL Server reviews. | 88% (Based on 127 reviews) | |
Query Language | As reported in 133 Microsoft SQL Server reviews. Allows users to create, update and retrieve data in a database. | 92% (Based on 133 reviews) | |
Data Modeling | See feature definition | As reported in 128 Microsoft SQL Server reviews. Defines the logical design of the data before building the schemas. | 89% (Based on 128 reviews) |
Performance Analysis | Monitors and analyzes critical database attributes like query performance, user sessions, dead lock detail, system errors etc and visualize them on a custom dashboard. 130 reviewers of Microsoft SQL Server have provided feedback on this feature. | 89% (Based on 130 reviews) |
Security
Data Encryption | As reported in 127 Microsoft SQL Server reviews. Encrypts and transforms data at the database from a readable state into a ciphertext of unreadable characters. | 89% (Based on 127 reviews) | |
User Access Control | Based on 129 Microsoft SQL Server reviews. Allows restricted user acess to modify depending on the access level. | 91% (Based on 129 reviews) | |
Database Locking | Based on 112 Microsoft SQL Server reviews. Prevents other users and applications from accessing data while it is being updated to avoid data loss or update. | 89% (Based on 112 reviews) | |
Access Control | Allows permissions to be granted or revoked in the database, schema or table levels. This feature was mentioned in 112 Microsoft SQL Server reviews. | 91% (Based on 112 reviews) | |
Encryption | Built-in native encryption with enterprise key management. This feature was mentioned in 109 Microsoft SQL Server reviews. | 88% (Based on 109 reviews) | |
Authentication | Based on 112 Microsoft SQL Server reviews. Provides multi-factor authentication with certificates. | 90% (Based on 112 reviews) |
Support
Text Search | Provides support for international character sets and full text search. 109 reviewers of Microsoft SQL Server have provided feedback on this feature. | 86% (Based on 109 reviews) | |
Data Types | As reported in 113 Microsoft SQL Server reviews. Supports multiple data types like primitive, structured, document etc. | 91% (Based on 113 reviews) | |
Languages | Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc. This feature was mentioned in 108 Microsoft SQL Server reviews. | 87% (Based on 108 reviews) | |
Operating Systems | Available on multiple operating systems like Linux, Windows, MacOS etc. This feature was mentioned in 112 Microsoft SQL Server reviews. | 86% (Based on 112 reviews) |
Performance
Disaster Recovery | Provides data recovery functionality to protect and restore data in a database. 109 reviewers of Microsoft SQL Server have provided feedback on this feature. | 87% (Based on 109 reviews) | |
Data Concurrency | Allows multi-version concurrency control. 107 reviewers of Microsoft SQL Server have provided feedback on this feature. | 88% (Based on 107 reviews) | |
Workload Management | As reported in 112 Microsoft SQL Server reviews. Handles workloads, from single machines to data warehouses or web services with many concurrent users. | 87% (Based on 112 reviews) | |
Advanced Indexing | As reported in 110 Microsoft SQL Server reviews. Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc. | 86% (Based on 110 reviews) | |
Query Optimizer | Helps interpret SQL queries and determine the fastest method of execution. 111 reviewers of Microsoft SQL Server have provided feedback on this feature. | 88% (Based on 111 reviews) |
Management
Data Schema | Data is organized as a set of tables with columns and rows like a table structure. 114 reviewers of Microsoft SQL Server have provided feedback on this feature. | 91% (Based on 114 reviews) | |
Query Language | Based on 115 Microsoft SQL Server reviews. Allows users to create, update and retrieve data in a database. | 92% (Based on 115 reviews) | |
ACID - Complaint | Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties. This feature was mentioned in 101 Microsoft SQL Server reviews. | 88% (Based on 101 reviews) | |
Data Replication | Based on 107 Microsoft SQL Server reviews. Provides log-based or/and trigger-based replication. | 88% (Based on 107 reviews) |
