Visit Website
Sponsored
Introducing G2.ai, the future of software buying.Try now
Microsoft SQL Server
Claimed
This profile has been claimed by Microsoft SQL Server, but it has limited features.
Do you work at Microsoft SQL Server? Upgrade your plan to update branding and connect with profile visitors!
Do you work at Microsoft SQL Server? Upgrade your plan to update branding and connect with profile visitors!
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
Technology Glossary Features
View definitions of the features and discover new technology terms.
MS SQL Categories on G2
Filter for Features
Database Features
Storage | 1252 reviewers of Microsoft SQL Server have provided feedback on this feature. | 89% (Based on 1,252 reviews) | |
Availability | This feature was mentioned in 1257 Microsoft SQL Server reviews. | 90% (Based on 1,257 reviews) | |
Stability | 1265 reviewers of Microsoft SQL Server have provided feedback on this feature. | 89% (Based on 1,265 reviews) | |
Scalability | This feature was mentioned in 1231 Microsoft SQL Server reviews. | 87% (Based on 1,231 reviews) | |
Security | 1233 reviewers of Microsoft SQL Server have provided feedback on this feature. | 88% (Based on 1,233 reviews) | |
Data Manipulation | See feature definition | 1240 reviewers of Microsoft SQL Server have provided feedback on this feature. | 88% (Based on 1,240 reviews) |
Query Language | This feature was mentioned in 1260 Microsoft SQL Server reviews. | 91% (Based on 1,260 reviews) |
Database
Real-Time Data Collection | Collects, stores, and organizes massive, unstructured data in real time 49 reviewers of Microsoft SQL Server have provided feedback on this feature. | 87% (Based on 49 reviews) | |
Data Distribution | As reported in 50 Microsoft SQL Server reviews. Facilitates the disseminating of collected big data throughout parallel computing clusters | 89% (Based on 50 reviews) | |
Data Lake | Creates a repository to collect and store raw data from sensors, devices, machines, files, etc. 47 reviewers of Microsoft SQL Server have provided feedback on this feature. | 84% (Based on 47 reviews) |
Integrations
Hadoop Integration | As reported in 38 Microsoft SQL Server reviews. Aligns processing and distribution workflows on top of Apache Hadoop | 79% (Based on 38 reviews) | |
Spark Integration | Based on 38 Microsoft SQL Server reviews. Aligns processing and distribution workflows on top of Apache Hadoop | 83% (Based on 38 reviews) |
Platform
Machine Scaling | Facilitates solution to run on and scale to a large number of machines and systems This feature was mentioned in 43 Microsoft SQL Server reviews. | 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 This feature was mentioned in 38 Microsoft SQL Server reviews. | 83% (Based on 38 reviews) |
Processing
Cloud Processing | As reported in 45 Microsoft SQL Server reviews. Moves big data collection and processing to the cloud | 85% (Based on 45 reviews) | |
Workload Processing | Based on 48 Microsoft SQL Server reviews. Processes batch, real-time, and streaming data workloads in singular, multi-tenant, or cloud systems | 84% (Based on 48 reviews) |
Maintenance
Data Migration | Allows data movement from one database to another. This feature was mentioned in 133 Microsoft SQL Server reviews. | 89% (Based on 133 reviews) | |
Backup and Recovery | Based on 138 Microsoft SQL Server reviews. Provides data backup and recovery functionality to protect and restore a database. | 90% (Based on 138 reviews) | |
Multi-User Environment | Based on 134 Microsoft SQL Server reviews. Allows users to access and work on data concurrently, supporting several views of the data. | 90% (Based on 134 reviews) |
Management
Data dictionary | Based on 133 Microsoft SQL Server reviews. Stores the database metadata, that is the definitions of data elements, types, relationships etc. | 89% (Based on 133 reviews) | |
Data Replication | Based on 132 Microsoft SQL Server reviews. Creates a copy of the database to maintain consistency and integrity. | 89% (Based on 132 reviews) | |
Query Language | Allows users to create, update and retrieve data in a database. This feature was mentioned in 138 Microsoft SQL Server reviews. | 93% (Based on 138 reviews) | |
Data Modeling | See feature definition | Based on 133 Microsoft SQL Server reviews. Defines the logical design of the data before building the schemas. | 89% (Based on 133 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. 135 reviewers of Microsoft SQL Server have provided feedback on this feature. | 89% (Based on 135 reviews) |
Security
Data Encryption | Encrypts and transforms data at the database from a readable state into a ciphertext of unreadable characters. This feature was mentioned in 132 Microsoft SQL Server reviews. | 89% (Based on 132 reviews) | |
User Access Control | As reported in 134 Microsoft SQL Server reviews. Allows restricted user acess to modify depending on the access level. | 91% (Based on 134 reviews) | |
Database Locking | Prevents other users and applications from accessing data while it is being updated to avoid data loss or update. 117 reviewers of Microsoft SQL Server have provided feedback on this feature. | 89% (Based on 117 reviews) | |
Access Control | Based on 117 Microsoft SQL Server reviews. Allows permissions to be granted or revoked in the database, schema or table levels. | 91% (Based on 117 reviews) | |
Encryption | As reported in 114 Microsoft SQL Server reviews. Built-in native encryption with enterprise key management. | 88% (Based on 114 reviews) | |
Authentication | As reported in 117 Microsoft SQL Server reviews. Provides multi-factor authentication with certificates. | 90% (Based on 117 reviews) |
Support
Text Search | Provides support for international character sets and full text search. This feature was mentioned in 114 Microsoft SQL Server reviews. | 87% (Based on 114 reviews) | |
Data Types | As reported in 118 Microsoft SQL Server reviews. Supports multiple data types like primitive, structured, document etc. | 91% (Based on 118 reviews) | |
Languages | Based on 113 Microsoft SQL Server reviews. Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc. | 87% (Based on 113 reviews) | |
Operating Systems | Available on multiple operating systems like Linux, Windows, MacOS etc. This feature was mentioned in 117 Microsoft SQL Server reviews. | 86% (Based on 117 reviews) |
Performance
Disaster Recovery | Provides data recovery functionality to protect and restore data in a database. 114 reviewers of Microsoft SQL Server have provided feedback on this feature. | 87% (Based on 114 reviews) | |
Data Concurrency | As reported in 112 Microsoft SQL Server reviews. Allows multi-version concurrency control. | 88% (Based on 112 reviews) | |
Workload Management | Handles workloads, from single machines to data warehouses or web services with many concurrent users. This feature was mentioned in 117 Microsoft SQL Server reviews. | 87% (Based on 117 reviews) | |
Advanced Indexing | As reported in 115 Microsoft SQL Server reviews. Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc. | 86% (Based on 115 reviews) | |
Query Optimizer | Helps interpret SQL queries and determine the fastest method of execution. 116 reviewers of Microsoft SQL Server have provided feedback on this feature. | 88% (Based on 116 reviews) |
Management
Data Schema | Based on 119 Microsoft SQL Server reviews. Data is organized as a set of tables with columns and rows like a table structure. | 91% (Based on 119 reviews) | |
Query Language | Allows users to create, update and retrieve data in a database. This feature was mentioned in 120 Microsoft SQL Server reviews. | 92% (Based on 120 reviews) | |
ACID - Complaint | Based on 106 Microsoft SQL Server reviews. Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties. | 87% (Based on 106 reviews) | |
Data Replication | Provides log-based or/and trigger-based replication. 112 reviewers of Microsoft SQL Server have provided feedback on this feature. | 88% (Based on 112 reviews) |
Microsoft SQL Server Comparisons
Explore More
Hunting for software insights?
With over 2.5 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
