Microsoft SQL Server Features

Database Features (7)

Storage: 1284 reviewers of Microsoft SQL Server have provided feedback on this feature.
Availability: This feature was mentioned in 1289 Microsoft SQL Server reviews.
Stability: This feature was mentioned in 1296 Microsoft SQL Server reviews.
Scalability: As reported in 1263 Microsoft SQL Server reviews.
Security: 1265 reviewers of Microsoft SQL Server have provided feedback on this feature.
Data Manipulation: 1271 reviewers of Microsoft SQL Server have provided feedback on this feature.
Query Language: As reported in 1291 Microsoft SQL Server reviews.

Database (3)

Real-Time Data Collection: Collects, stores, and organizes massive, unstructured data in real time 56 reviewers of Microsoft SQL Server have provided feedback on this feature.
Data Distribution: As reported in 57 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. This feature was mentioned in 54 Microsoft SQL Server reviews.

Integrations (2)

Platform (3)

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

Processing (2)

Maintenance (3)

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

Management (5)

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

Security (6)

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

Support (4)

Text Search: As reported in 145 Microsoft SQL Server reviews. Provides support for international character sets and full text search.
Data Types: As reported in 149 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. 144 reviewers of Microsoft SQL Server have provided feedback on this feature.
Operating Systems: Based on 148 Microsoft SQL Server reviews. Available on multiple operating systems like Linux, Windows, MacOS etc.

Performance (5)

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

Management (4)

Data Schema: Based on 149 Microsoft SQL Server reviews. Data is organized as a set of tables with columns and rows like a table structure.
Query Language: As reported in 150 Microsoft SQL Server reviews. Allows users to create, update and retrieve data in a database.
ACID - Complaint: As reported in 136 Microsoft SQL Server reviews. Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties.
Data Replication: As reported in 142 Microsoft SQL Server reviews. Provides log-based or/and trigger-based replication.

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