Name: SQL Server
Rating: 4.5 (2555 reviews)

Overview

Product Information on SQL Server

Updated 13th October 2025

What is SQL Server?

SQL Server is a relational database management software developed to support data storage, retrieval, and management for organizations of varying sizes. The software enables users to securely store and access structured data, run queries, create reports, and perform analytics. It supports transaction processing, business intelligence, and analytics applications. The software includes tools for database administration, backup and recovery, security management, and automated maintenance. It offers integration with other applications and supports scalability to accommodate growing data needs. SQL Server aims to address challenges related to managing large volumes of data, ensuring data integrity, and enabling businesses to analyze information for operational and strategic decision-making.

Overall experience with SQL Server

Sdet

30B + USD, Banking

FAVORABLE

“Examining SQL Server Stability, Administration Features, and Scalability Challenges”

5.0

Feb 13, 2026

Our overall experience with Microsoft SQL Server has been consistently positive in enterprise environments that require stability, performance and strong transactional integrity. It has proven to be a reliable relational database platform for both operational systems and reporting workloads. From a development and testing perspective , SQL server provides strong tooling , predictable performance and mature administrative capabilities. It integrates well with enterprise ecosystems and supports structured deployment practices. While newer cloud -native platforms offer additional scalability flexibility , SQL Server continues to deliver dependable performance for structured data systems.

BI Engineer

1B - 3B USD, Healthcare and Biotech

CRITICAL

“Navigating Through Complexities of SQL Server Integration Services”

3.0

Jan 23, 2025

SQL Server Integration Services is an embeded solution for data integration to Ms SQL Server The system is quite powerfull, but the maintain level is in the average. Graphics view of the IIS job let you select each step. After the build phase the Job is visible in SQL Server supervision and can be easily schedule

About Company

Company Description

Microsoft enables digital transformation for the era of an intelligent cloud and an intelligent edge. Its mission is to empower every person and every organization on the planet to achieve more. Microsoft is dedicated to advancing human and organizational achievement. Microsoft Security helps protect people and data against cyberthreats to give peace of mind.

Company Details

Company type

Public

Year Founded

1975

Head office location

Redmond, Washington, United States

Number of employees

10000+

Annual Revenue

30B+ USD

Website

https://microsoft.com

Do You Manage Peer Insights at Microsoft?

Access Vendor Portal to update and manage your profile.

Key Insights

A Snapshot of What Matters - Based on Validated User Reviews

User Sentiment About SQL Server

Reviewer Insights for: SQL Server

Deciding Factors: SQL Server Vs. Market Average

Performance of SQL Server Across Market Features

SQL Server Likes & Dislikes

The most valuable aspect of SQL Sever is its maturity and reliability. The platform provides: String ACID compliance for transactional integrity. Robust indexing and query optimization capabilities. Comprehensive backup, recovery and high -availability features. Integration with SQL Server Management Studio(SSMS) for easy administration. Seamless compatibility with enterprise applications and reporting tools. From a QA and development standpoint, the ability to write stored procedures , triggers and functions allows for structured business logic implementation. Execution plans and performance monitoring tools also make it easier to analyze and optimize queries during testing cycles. Additionally , its security features - including role based access control, encryption options and auditing are well suited for regulated industries.

Sql Server integration : scheduling and job errors supervision is clear and fast

I like most is the abality to efficiently integrate and transform data from multiple sources. it supports automation of ETL processes, which saves time and reduces manual effort. The tools are reliable and work well different data systems. it also improves data consistency and workflow efficiency.

While SQL Server is highly reliable , scaling vertically can become costly compared to some cloud -native distributed databases. Licensing and infrastructure costs can be a consideration for larger implementations . From a testing and development perspective: Managing large volumes of data may require careful indexing and tuning . Schema changes in tightly coupled environments can require careful coordination. Performance tuning can becomes complex in heavily transactional systems. Migrating legacy SQL Server environments to modern architectures can require significant planning.

1 Complexity of parameters : parameters can be set with functions but at diefferents levels wich make the search and debug difficult 2 limited connector number 3 team developpement not included

I dislike is that setting up and configuration data integration workflows can be somewhat complex. it may require technical expertise to handle transformations and troubleshooting. performance tuning for large datasets can also take additional efforts. However, overall, it is a reliable and effective data integration solution.

Top SQL Server Alternatives

Peer Discussions

What Your Peers Are Saying About SQL Server

CIO

What tool(s) are you using for SQL Server Database Monitoring (besides just SSMS)? Specifically, I am wanting the following features: - Alerting with possibility of sending a ticket to Service Now - Deadlock alerts - SSIS Job Failures - Query Optimization Recommendations - SQL Server Optimization Recommendations - Point in time report to see what was being ran during a certain period of time - Other features?

Mission Diplomatic Technology Officer

We have shut down our SQL server and moved to dataverse.

See Full Discussion

25 Jan 20251.1k Views1 Comment

IT Analyst

How are automated database builds handled for SQL Server through a build/release pipeline. What is the failback mechanism if there are failures during database update during both DDL and DML. Any specific tool recommendation would be helpful.

Information Security Manager

Automated database builds for SQL Server through a build/release pipeline are typically managed using tools that integrate with continuous integration (CI) and continuous deployment (CD) systems. Here's an overview of how this process is handled: ### 1. **Automated Database Build Process** - **Source Control:** The database schema (DDL) and scripts (DML) are stored in source control, often using tools like Git. This can include SQL scripts or projects created using Visual Studio (SQL Server Data Tools – SSDT) or other database tools. - **Build Pipeline:** - **Build Definition:** A build pipeline for SQL Server usually triggers automatically upon changes to the source repository. For instance, using tools like Azure DevOps, Jenkins, or TeamCity. - **Database Project/Schema Validation:** The pipeline uses tools like **SSDT** (SQL Server Data Tools), **Redgate SQL Change Automation**, or **Flyway** to validate and compile database projects. This ensures that the DDL is valid and ready for deployment. - **Unit Tests for Database:** You can integrate database unit testing using tSQLt or other frameworks to ensure the new changes do not break the database. ### 2. **Database Release Process** - **Release Pipeline:** - The release process often consists of deploying the new DDL and DML changes to different environments (Dev, QA, Staging, and Production). - Tools like **Redgate SQL Change Automation**, **Liquibase**, **Flyway**, or **DbUp** manage schema changes and migrations by applying incremental changesets, tracking the history of changes, and ensuring consistency across environments. - **Rollback/Fallback Mechanism:** - **Transaction Management:** During deployment, SQL scripts can be wrapped in transactions. If a failure occurs, the transaction is rolled back. - **Backup Mechanism:** - Before deployment, a full or differential database backup is often taken to enable a complete rollback if a critical failure occurs. - **Schema Versioning and Rollbacks:** Tools like Flyway, Redgate SQL Change Automation, or Liquibase maintain a version history of database migrations. These tools allow rollback to a previous version in case of failure. - Flyway, for example, has a `migrate` and `undo` feature, and Redgate provides a schema comparison to reverse changes. - **Rolling Back DDL Changes:** If a DDL (e.g., table alterations) fails, reverting to the previous schema version can be handled by the version control tool, though this is complex and requires careful planning. - **Rolling Back DML Changes:** For DML changes (e.g., data modification), compensating transactions or rollback scripts can be included to reverse any data modifications made in case of a failure. ### 3. **Handling Failures (DDL & DML)** - **DDL Failures (Schema Changes):** - Use **schema comparison tools** like **Redgate SQL Compare** or SSDT to identify and rollback changes if failures occur. - **Transactional Deployment**: If possible, wrap schema changes in a transaction and roll back the transaction upon failure. - In case of failure, either restore from a backup or use the rollback feature of tools like Liquibase or Flyway. - **DML Failures (Data Modifications):** - Include rollback scripts or compensating transactions to undo data changes in case of errors. - **Pre-checks:** Always run validation queries (e.g., SELECT statements) before applying DML to ensure the data consistency is maintained. - Use backup and restore techniques or employ log shipping to revert databases to a known good state if failures occur during DML changes. ### 4. **Tool Recommendations** - **Redgate SQL Change Automation:** Excellent for automating deployments and managing schema changes with a focus on safety and rollback mechanisms. It integrates well with Azure DevOps, Jenkins, and other CI/CD tools. - **Flyway:** A powerful open-source tool for database migrations with support for SQL Server. It handles versioned migrations (DDL and DML) and has rollback (`undo`) support. - **Liquibase:** Similar to Flyway, Liquibase tracks database schema changes and supports rollbacks. It integrates with various CI/CD pipelines. - **Azure DevOps Pipelines:** Native support for SQL Server database builds and deployments, integrates well with SSDT and Redgate tools. - **DbUp:** A lightweight .NET-based tool for managing database migrations. It's simple and easy to integrate into build pipelines. ### Best Practices: - Always use transactional DDL and DML scripts to ensure you can roll back in case of failures. - Implement automated database backups before applying updates. - Test deployments in staging environments thoroughly before pushing to production. - Ensure that all migrations and rollback scripts are version-controlled. This combination of tools and techniques ensures a robust, automated process for building, releasing, and rolling back changes in SQL Server databases.

See Full Discussion

19 Sep 2024610 Views1 Comment

SQL Server Reviews and Ratings

Recommended Gartner Insights

IT Analyst

Information Security Manager

See Full Discussion

19 Sep 2024610 Views1 Comment

10B+ USD

Banking

Review Source

Examining SQL Server Stability, Administration Features, and Scalability Challenges

It Security & Risk Management Associate

50M-1B USD

IT Services

Data Integration Tool Streamlines Workflows But Setup Remains Technically Challenging

Mar 31, 2026

Overall, the experience has been very good. it provides reliable tools for data integration, making it easier to extract, transform, and load data across systems, The integration capabilities are strong and support different data sources efficiently. it helps automate data workflows and improves data consistency. it has enhanced overall efficiency in managing data pipelines.

SOFTWARE DEVELOPER

<50M USD

Media

Comprehensive Database Platform With Notable Challenges in Cost and Query Optimization

4.0

Dec 2, 2025

It has been largely positive. It is a reliable and robust database platform with strong performance, good tooling and a wide range of features. Certain areas such as licensing costs, performance tuning complexity and occasional quirks with query optimization do add to the overall slowdowns of my process and limit what i can do. Overall, it remains dependable and well supported.

Scalable Database Platform Excels in Reliability But Demands Advanced Query Optimization

Overall, the experience has been very good. it provides a reliable and scalable database management system with strong performance. The integration with cloud environments makes it easy to manage and access data. it supports efficient querying, backup, and recovery processes. it has improves overall database management and operational efficiency.

CONTROL SYSTEM INTEGRATOR II

Services (non-Government)

Connecting SCADA Systems and Managing Alarms Made Possible With SQL Database

Dec 8, 2025

We were looking for a platform to store our Automation system data and SQL provided the perfect platform for this use case. We have been using SQL for multiple purposes for a long time, and it is really amazing.

Overview

Product Information on SQL Server

What is SQL Server?

SQL Server Pricing

Overall experience with SQL Server

“Examining SQL Server Stability, Administration Features, and Scalability Challenges”

“Navigating Through Complexities of SQL Server Integration Services”