Microsoft SQL Server Reviews & Insights

Score8.7 out of 10

1,672 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

6 Reviews

Engineering

Microsoft SQL Server is a great database solution!

Rating: 9 out of 10

Incentivized

August 8, 2021

Use Cases and Deployment Scope

We currently use Microsoft SQL Server as our database application for our applications. We are using the Microsoft SQL Server jobs, Analysis services, cubes, and many other features to help provide front end data solutions to our customers. Our instance of Microsoft SQL Server also allows for multi-database implementation with full backup capabilities. We also pair with the latest management studio to get the best UI experience.

Pros

Easy to use with Visual Studio and ASP projects
Multiple options for Data Security
Industry standard and easy to use
Easy to install and configure

Cons

Licensing can get complicated
Very very expensive
combability issues and dependencies with servers etc
Microsoft support....you know

Likelihood to Recommend

Microsoft SQL Server is best for enterprise-level databases for data management. If you need to scale easily there are other options like Azure SQL, etc, but this also works best on bare metals servers. The licensing can get a bit complicated so it is not good for small companies/applications. I also don't think it is the best for mobile applications, etc.

Pritesh Patel

Product Manager, Partnerships & Data Services in Engineering at ProfitSword, LLC (Hospitality, 51-200 employees)

Vetted Review

6 years of experience

View profile

Microsoft SQL Server for small and medium scale companies

Rating: 8 out of 10

Incentivized

October 4, 2019

Use Cases and Deployment Scope

Microsoft SQL Server is being used by the whole organization. Our core OLTP database system is on the MS SQL Server.

Pros

I think that Microsoft SQL Server is the best database software for small and medium-sized companies
Microsoft SQL Server has a user-friendly interface for the database admins.
Microsoft SQL Server is cheaper than other databases (like Oracle, etc.).

Cons

Microsoft SQL Server is not suitable for big companies.
Microsoft SQL Server has to improve with more transactions. If you have too many transactions on the database, there is no response from the database to the user.
Microsoft SQL Server has to improve its big data technologies.

Likelihood to Recommend

It is used for small businesses, but it is not suitable for big companies. Used for technologies on the Microsoft SQL Server. It becomes unavailable after a while, like CLR. It is bad for the database system.

Verified User

Professional in Engineering (Retail company, 10,001+ employees)

Vetted Review

8 years of experience

My opinion on using Microsoft SQL Server

Rating: 9 out of 10

Incentivized

January 21, 2019

Use Cases and Deployment Scope

Microsoft SQL Server is used as a relational database management tool by our organisation. It's mostly used by every department in our corporation to insert, update, delete, manage data and to provide various encryptions to it.

Pros

SQL Sever supports multiple users in one setup which make it a multiuser system.
SQL profiler tracks the background queries and helps with the debugging and management of SQL queries
By analysing estimated and actual test plans, it helps to make queries more optimized

Cons

Issues exist when restoring a database for low screen resolution system. This should be debugged and corrected.
Doesn't auto backup an unsaved query window. So when SQL server is restarted it [loses] previously unsaved work.
Hanging issues while booting SQL Server.

Likelihood to Recommend

If the user needs data management tool for development purposes of website or desktop applications then it's a good tool. It supports Microsoft Visual Studio well.

Simran Singh

Senior Software Engineer in Engineering at ToXSL Technologies Pvt Ltd (Computer Software, 51-200 employees)

Vetted Review

3 years of experience

View profile

Microsoft SQL Server Review

Rating: 8 out of 10

Incentivized

June 8, 2018

Use Cases and Deployment Scope

In our Organisation Microsoft SQL Server is widely used because SQL server is a very powerful tool for managing the database. Yes, it is used widely worldwide because it is a Microsoft product and is trustworthy. It has a lot of security features. We solve our many businesses related issues like database management, save time and reduce the paperwork and also the burden of an employee. We increase our customers and our profitability.

Pros

it has a lot of security feature, no one can access if they have no credentials.
easy to use and maintain the database
very flexible and easy to install and for new users it very easy to learn and implement.

Cons

it has little bit performance issue
output window panel is single if we run multiple select commands it shows all results in one after that so that is more clumsy
it goes hang in low System RAM configurations.

Likelihood to Recommend

it is useful where we use the same type of data and we can change databases very quickly and change the table name in no time. It is less appropriate where a huge amount of records are used and we cannot use and manipulate the unstructured database easily so that is not the good thing for big industries.

Verified User

Employee in Engineering (Computer Software company, 501-1000 employees)

Vetted Review

3 years of experience

MS SQL Server is my favorite DBMS for more than 13 years

Rating: 10 out of 10

Incentivized

February 23, 2016

Use Cases and Deployment Scope

We use MS SQL Server 2008R2-2012 as a data storage in our EDMS for our major client from the government.

Pros

Best out-of-the-box tools among enterprise scale DBMSs. SQL Management Studio is one of the best tools for almost all day-to-day tasks including deployment and support. In conjunction with other standard MS SQL Server tools it outperforms most other DBMSs I ever saw, including but not limiting Oracle and DB2.
Very powerful T-SQL.
Lots of data migration tools for easy integration with other data sources.
Great stability.
Native support by Visual Studio including database projects. You can deploy database updates even to production environment with literally 2-3 clicks. You may also generate diff script for manual analysis and deployment.

Cons

Price may seem tough.
Security model is a bit strange to get started but once you know a few particularities then nothing stops you from day-to-day tasks.

Likelihood to Recommend

Technically MS SQL Server suits almost all middle-to-large use cases. However, be careful with high load scenarios and big non-relational data - you may get stuck with huge backups.

Verified User

Team Lead in Engineering (Government Administration company, 501-1000 employees)

Vetted Review

16 years of experience

De Facto Standard for .NET Development

Rating: 9 out of 10

Incentivized

July 20, 2015

Use Cases and Deployment Scope

We use Microsoft SQL Server as the backend for our client's websites. These websites are a mix of custom implementations and sites built on various content management systems such as Kentico, Ektron, and Sitecore.

Pros

Integrates well with very nearly all the platforms we use
Natively supported by .NET, our typical environment of choice
Large community to ask questions of

Cons

Less advanced users can get into trouble easily
Big learning curve for people starting off

Likelihood to Recommend

MicroSoft SQL Server is clearly the de facto relational database server of choice for .NET projects. If you are not working in .NET, it immediately becomes a less desirable platform as that is generally an environment where it wouldn't make sense to run a Windows-based machine for a database.

Verified User

Engineer in Engineering (Marketing and Advertising company, 11-50 employees)

Vetted Review

8 years of experience

Loading Reviews List....