Microsoft SQL Server Features

Database Features (7)

Storage: 1282 reviewers of Microsoft SQL Server have provided feedback on this feature.
Availability: 1287 reviewers of Microsoft SQL Server have provided feedback on this feature.
Stability: This feature was mentioned in 1294 Microsoft SQL Server reviews.
Scalability: This feature was mentioned in 1261 Microsoft SQL Server reviews.
Security: 1263 reviewers of Microsoft SQL Server have provided feedback on this feature.
Data Manipulation: Based on 1269 Microsoft SQL Server reviews.
Query Language: This feature was mentioned in 1289 Microsoft SQL Server reviews.

Database (3)

Real-Time Data Collection: Collects, stores, and organizes massive, unstructured data in real time 55 reviewers of Microsoft SQL Server have provided feedback on this feature.
Data Distribution: Based on 56 Microsoft SQL Server reviews. Facilitates the disseminating of collected big data throughout parallel computing clusters
Data Lake: Creates a repository to collect and store raw data from sensors, devices, machines, files, etc. 53 reviewers of Microsoft SQL Server have provided feedback on this feature.

Integrations (2)

Platform (3)

Machine Scaling: Based on 49 Microsoft SQL Server reviews. Facilitates solution to run on and scale to a large number of machines and systems
Data Preparation: As reported in 52 Microsoft SQL Server reviews. Curates collected data for big data analytics solutions to analyze, manipulate, and model
Spark Integration: Based on 44 Microsoft SQL Server reviews. Aligns processing and distribution workflows on top of Apache Hadoop

Processing (2)

Maintenance (3)

Data Migration: Allows data movement from one database to another. This feature was mentioned in 150 Microsoft SQL Server reviews.
Backup and Recovery: As reported in 155 Microsoft SQL Server reviews. Provides data backup and recovery functionality to protect and restore a database.
Multi-User Environment: Allows users to access and work on data concurrently, supporting several views of the data. This feature was mentioned in 151 Microsoft SQL Server reviews.

Management (5)

Data dictionary: Stores the database metadata, that is the definitions of data elements, types, relationships etc. 150 reviewers of Microsoft SQL Server have provided feedback on this feature.
Data Replication: Creates a copy of the database to maintain consistency and integrity. This feature was mentioned in 150 Microsoft SQL Server reviews.
Query Language: As reported in 155 Microsoft SQL Server reviews. Allows users to create, update and retrieve data in a database.
Data Modeling: Defines the logical design of the data before building the schemas. 150 reviewers of Microsoft SQL Server have provided feedback on this feature.
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. This feature was mentioned in 152 Microsoft SQL Server reviews.

Security (6)

Data Encryption: As reported in 149 Microsoft SQL Server reviews. Encrypts and transforms data at the database from a readable state into a ciphertext of unreadable characters.
User Access Control: Allows restricted user acess to modify depending on the access level. This feature was mentioned in 151 Microsoft SQL Server reviews.
Database Locking: Prevents other users and applications from accessing data while it is being updated to avoid data loss or update. This feature was mentioned in 146 Microsoft SQL Server reviews.
Access Control: Based on 146 Microsoft SQL Server reviews. Allows permissions to be granted or revoked in the database, schema or table levels.
Encryption: Built-in native encryption with enterprise key management. 143 reviewers of Microsoft SQL Server have provided feedback on this feature.
Authentication: Provides multi-factor authentication with certificates. 146 reviewers of Microsoft SQL Server have provided feedback on this feature.

Support (4)

Text Search: As reported in 143 Microsoft SQL Server reviews. Provides support for international character sets and full text search.
Data Types: Based on 147 Microsoft SQL Server reviews. Supports multiple data types like primitive, structured, document etc.
Languages: Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc. 142 reviewers of Microsoft SQL Server have provided feedback on this feature.
Operating Systems: Available on multiple operating systems like Linux, Windows, MacOS etc. This feature was mentioned in 146 Microsoft SQL Server reviews.

Performance (5)

Disaster Recovery: Provides data recovery functionality to protect and restore data in a database. This feature was mentioned in 142 Microsoft SQL Server reviews.
Data Concurrency: Allows multi-version concurrency control. 139 reviewers of Microsoft SQL Server have provided feedback on this feature.
Workload Management: Based on 145 Microsoft SQL Server reviews. Handles workloads, from single machines to data warehouses or web services with many concurrent users.
Advanced Indexing: Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc. 143 reviewers of Microsoft SQL Server have provided feedback on this feature.
Query Optimizer: Helps interpret SQL queries and determine the fastest method of execution. 144 reviewers of Microsoft SQL Server have provided feedback on this feature.

Management (4)

Data Schema: Data is organized as a set of tables with columns and rows like a table structure. This feature was mentioned in 147 Microsoft SQL Server reviews.
Query Language: Allows users to create, update and retrieve data in a database. 148 reviewers of Microsoft SQL Server have provided feedback on this feature.
ACID - Complaint: As reported in 134 Microsoft SQL Server reviews. Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties.
Data Replication: Provides log-based or/and trigger-based replication. This feature was mentioned in 140 Microsoft SQL Server reviews.

Top-Rated Alternatives

View All Alternatives

Technology Glossary Features

View definitions of the features and discover new technology terms.

View Glossary

Data Modeling

Data modeling is the process of creating visual representations of information systems to better communicate the connections between data points and structures. Learn more about data modeling in this G2 guide.

Data Manipulation

Data manipulation is changing data to a readable format. This G2 guide provides in-depth information about data manipulation, its types, benefits, and best practices.

Microsoft SQL Server Comparisons