Microsoft SQL Server Manufacturing Reviews & Insights

Score8.7 out of 10

1,630 Reviews and Ratings

Community insights

TrustRadius Insights for Microsoft SQL Server are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Ease of Use and Integration: Users have consistently found the software easy to use, praising its simple design and common interface. They also appreciate its seamless integration capabilities with various frameworks and tools like Visual Studio, Dot Net, MSBI, PowerBI, Crystal Reports, etc.

Reliability and Performance: Reviewers have highlighted the software's reliability in handling high volume transactions and data staging operations. They also value its fast performance, intuitive SQL coding experience, efficient data table management, and quick information filtering capabilities.

Data Management Capabilities: Users have praised the software for its functionalities as a relational database server and its support for OEM applications. They particularly appreciate its features for data storage, manipulation, scalability options, quick data analysis abilities, troubleshooting tools availability, and maintenance procedures.

Microsoft SQL Server Reviews

8 Reviews

ManufacturingChemicals1Machinery1Mechanical Or Industrial Engineering1Industrial Automation1Pharmaceuticals2Textiles1Consumer Goods1

Microsoft SQL pricey but worth it

Rating: 8 out of 10

Incentivized

April 30, 2025

Use Cases and Deployment Scope

We use it to hold the databases that with use for our Apps. It gives us a efficient way to store all the data we have in order to make our apps works. Any business needs a database to store it's data and with Microsoft SQL things are easier to manage.

Pros

Data structure
Good documentation
Huge posibilities
Efficient querying

Cons

Easy issues management , like deadlocks and slow performance
Resource use , it's very memory hungry
Pricing

Likelihood to Recommend

With Microsoft SQL you will have a easier and faster deployment and work. It's true that you have other open sources options , like mysql for example but the learning curve and support it's harder. It's pricey but it's worth it. If you are a small organization you could try to use SQL Express but the database size is limited , in that scenario you might want to go with a open source option.

Verified User

Technician (Mechanical Or Industrial Engineering company, 51-200 employees)

Vetted Review

7 years of experience

Microsoft SQL Server: Perfect Data Manager for an Organization

Rating: 9 out of 10

Incentivized

March 7, 2025

Use Cases and Deployment Scope

Microsoft SQL Server is used in our organization by IT personnel to Store data, fetch data specific to requirements. For instance, in Sales Module SQL server is used to fetch data specific to a sales transaction and it helps to troubleshoot the errors reported by users. Similarly, it is used by IT technical team and other IT functional team to query the data stored in data server.

Pros

Data Storage,Data retrieval in conjunction with front-end software
Scalability to handle small-large database
SQL server available with different architectures under one umbrella

Cons

Nested queries are complex and need expertise - BI should be used to provide ease
Time and Space complexities - Can be improved
OLTP can be further enhanced
Cloud version can be improved

Likelihood to Recommend

1) We had a set-up where the ERP application and the servers were in-house and Microsoft SQL Server is perfect to query the data and troubleshoot the error reported by user. 2) The Microsoft SQL Server is taught to students from high school and this is like a baseline for students from IT. So it makes it easy to use at organization level since individual had already gained lot of experience in querying in previous projects at college level or otherwise. 3) In case of Cloud architecture, there is stiff competition and every software enterprise need to re-version itself for betterment. Otherwise, its- no less than any product out there.

varun kohli

Senior Executive in Information Technology at Vardhman textiles ltd. (Textiles, 10,001+ employees)

Vetted Review

19 years of experience

Verified on LinkedIn

SQL Server is a reliable, stable, and easy to use DBMS

Rating: 10 out of 10

Incentivized

April 8, 2021

Use Cases and Deployment Scope

Microsoft SQL Server is our organization's main Database Management System and is the primary back-end server for most of our critical business applications. It's a general requirement that any new application we implement has to operate on SQL Server, if it requires a database back-end. We have a great dependency upon SQL Server and it has not disappointed us.

Pros

Easy to use to set up databases
Reliable clustered instances
Maintenance plan wizards
Good UI with Management Studio
Good BI tools out of the box with SSIS, SSAS, and SSRS

Cons

It could use more/better templates in SQL Server Profiler
Lacks error avoidance tools when working in different environments (DEV/TEST/PROD). That is, preventing some code execution against PROD, for example.

Likelihood to Recommend

I have used Microsoft SQL Server in one flavor or another for two decades. It has always been a reliable database management system for running anything from custom, in-house applications to business critical Enterprise Resource Planning systems. There is also a broad SQL Server ecosystem available on the internet, which is helpful for development tasks, training and troubleshooting.

Verified User

Supervisor in Information Technology (Chemicals company, 51-200 employees)

Vetted Review

21 years of experience

Microsoft SQL Server Review

Rating: 7 out of 10

Incentivized

May 29, 2018

Use Cases and Deployment Scope

We use Microsoft SQL server to perform analytics with a large set of data from different kinds of clients. All the data preparations are done with SQL server. It is being used by everyone in our service line. also, most of our client uses SQL server as well. Using SQL Server to process unstructured data is not very effective.

Pros

It's fairly quick to manipulate large sets of data
Quick and easy to learn
Cost efficient

Cons

Implement features to process unstructured data easier
Increase performance speed
Add multiple results table in the same window

Likelihood to Recommend

It is well suited to manipulate mid-sized datasets (rows less than 2M). It can quickly change existing data or add new data to the existing data. SQL server cannot manipulate or clean unstructured data quickly when the unstructured large data sets do not have any pattern or rules.

Darren Deng

Analyst at Golden Qi Holdings (Pharmaceuticals, 501-1000 employees)

Vetted Review

3 years of experience

View profile

Microsoft SQL Server - Stores your Gold

Rating: 10 out of 10

Incentivized

July 21, 2017

Use Cases and Deployment Scope

We use SQL Server to data mine and report on data for all departments including finance, production, shipping/receiving and purchasing. We are constantly studying our data trends to help us run our business proactively. Many other departments request data trends, etc., that may not be available in the ERP application. We are able to retrieve this data using SQL Server.

Pros

Excellent Speed
Backup/Restore fast
Automated processes work well

Cons

Data encryption
Security
Fuzzy SQL logic

Likelihood to Recommend

Well suited for an environment where data integrity and reporting are significant parts of your business. The ability to data mine for specific scenarios is excellent. Also being able to design reports after finding the data is another excellent tool.

Don Johnson

ERP Manager in Information Technology (Machinery, 501-1000 employees)

Vetted Review

15 years of experience

View profile

Business level data storage and reporting

Rating: 9 out of 10

Incentivized

March 28, 2017

Use Cases and Deployment Scope

We use Microsoft SQL server as a base platform for our enterprise resource program. Not only is it the data warehouse but it also serves as the SSRS report server so we can use SQL views and stored procedures to create SSRS reports more effectively based on the user needs. The tools in SQL Server allow for all maintenance to be scheduled, simplifying maintenance.

Pros

Backing up databases both full and differential as well as transaction logs so data recovery is simple.
Database cleanup and maintenance tools that can be scheduled to keep the database running at optimal performance.
The performance monitor allows you to track query performance so you can maintain the best user experience and tune the server for optimal usage.

Cons

A better way to remotely connect to the database to maintain and review current transactions is needed.
SSRS report designer needs better tools to build the reports you need. Too many workarounds due to limitations in SSRS.
Logs need to be less cryptic and more meaningful at times so that diagnosing problems can be done quicker.

Likelihood to Recommend

Storing data in tables SQL does well for major programs where data integrity is needed. It's less appropriate when using the data storage in a smaller format that you are only accessing thru Excel or Access.

Verified User

Employee in Information Technology (Industrial Automation company, 201-500 employees)

Vetted Review

5 years of experience

SQL Server for quick and easy wins

Rating: 8 out of 10

Incentivized

June 6, 2016

Use Cases and Deployment Scope

Microsoft SQL Server is being used extensively in my organization. It is the default database for SharePoint sites and also the default choice for custom database applications. SQL Server Database is very commonly used in the IT department since it is well suited with the Microsoft umbrella of products. Other departments also use SQL Server for self-served Microsoft Business Intelligence reports and SharePoint. Analytics is one of the main business problems that SQL Server handles efficiently and effectively. SQL Server Reporting Services, PowerPivot, Power BI, SharePoint rely heavily on SQL Server engine and database in the back-end.

Pros

SQL Server handles a relational database very well. The fundamental logic for Extract, Transform and Load (ETL) hasn't changed much for a long time, so there is no learning curve if you upgrade from older versions to new ones.
One of the strong advantages of using SQL Server is its better compatibility with Microsoft product suites. Choosing Microsoft SQL server is the first choice if your organization relies on other Microsoft products.
It is very stable, fast, affordable, and extremely popular. There is an easy learning curve to acquire SQL Server skills. Microsoft SQL Server Management Studio is very graphical and requires very little programming to achieve basic tasks.

Cons

SQL Server is only operable on the Windows platform. It should support the Unix platform too.
There are a few object types missing in SQL Server, e.g. no packages (collection of procedures and functions), no "before" event triggers.
SQL Server doesn't support partitioning.

Likelihood to Recommend

I prefer SQL Server for SharePoint applications. There are SSIS data sources, destinations that can be used to sync data between SharePoint lists and SQL Server tables. SQL Server is a good choice if you are looking for a solution with quicker time to market. It is simple to use and administer. However, I would prefer something else (like Oracle) for enterprise solutions.

Ved Mishra

SharePoint/MS Project Server Engineer in Information Technology at Merck (Pharmaceuticals, 10,001+ employees)

Vetted Review

10 years of experience

View profile

MS SQL server

Rating: 9 out of 10

Incentivized

February 15, 2016

Use Cases and Deployment Scope

It is used across the whole organization to build analytical tools for the business users to best analyze the sales data.

Pros

Sql Server Integration services is a a great tool for ETL needs
SQL Server Analysis Services is a great tool to build data marts and data cubes.
SQL Server Reporting Services is a great reporting tool.

Cons

SQL server installation always takes long time, that can be definitely improved.
The Management Studio front end still needs work as does Indexing.
Few in SSIS Realtime data refresh in SSRS More datasources in Power BI

Likelihood to Recommend

Volume of the data, it cannot store as much data as Oracle or Teradata does.

Srikanth S

Sr MS SQL BI Developer in Sales at Georgia-Pacific LLC (Consumer Goods, 1001-5000 employees)

Vetted Review

7 years of experience

View profile

Loading Reviews List....

SQL Server for quick and easy wins

Rating: 8 out of 10

Incentivized

June 6, 2016

Use Cases and Deployment Scope

Pros

SQL Server handles a relational database very well. The fundamental logic for Extract, Transform and Load (ETL) hasn't changed much for a long time, so there is no learning curve if you upgrade from older versions to new ones.
One of the strong advantages of using SQL Server is its better compatibility with Microsoft product suites. Choosing Microsoft SQL server is the first choice if your organization relies on other Microsoft products.
It is very stable, fast, affordable, and extremely popular. There is an easy learning curve to acquire SQL Server skills. Microsoft SQL Server Management Studio is very graphical and requires very little programming to achieve basic tasks.

Cons

SQL Server is only operable on the Windows platform. It should support the Unix platform too.
There are a few object types missing in SQL Server, e.g. no packages (collection of procedures and functions), no "before" event triggers.
SQL Server doesn't support partitioning.

Likelihood to Recommend

Ved Mishra

SharePoint/MS Project Server Engineer in Information Technology at Merck (Pharmaceuticals, 10,001+ employees)

Vetted Review

10 years of experience

View profile