Microsoft SQL Server Reviews & Product Details

I appreciate how Microsoft SQL Server securely consolidates our application data and delivers unmatched reliability. It also makes complex database administration and troubleshooting feel seamless and straightforward. The initial setup was easy, which was a real advantage for us. Review collected by and hosted on G2.com.

I’m not a fan of the licensing costs or the portability limitations around SSMS. In my view, Microsoft SQL Server would be better if it offered truly cross-platform capabilities and did away with the restrictive 128 GB memory cap. Review collected by and hosted on G2.com.

Microsoft SQL Server is easy to use, even for beginners. The interface in SSMS is simple, and implementation is straightforward with clear setup steps. It offers many useful features like views, stored procedures, and strong security. I also use it frequently because it feels reliable and stable. Another big advantage is how well it integrates with Excel, Power BI, and other Microsoft tools, which makes reporting and analysis much easier. Review collected by and hosted on G2.com.

One downside is that SQL Server can feel heavy during installation and requires a good system to run smoothly. Some features are only available in higher paid versions, which may not be ideal for small teams. Integration with non-Microsoft tools can sometimes need extra steps. Also, customer support can be slow unless you are on an enterprise plan. Overall, while it works well, the setup and advanced features can be a bit challenging for beginners. Review collected by and hosted on G2.com.

Once everything is up and running it is extremely stable and performance is excellent. Review collected by and hosted on G2.com.

Cost, user CALs can get expensive, but so are other database servers. Review collected by and hosted on G2.com.

In my opinion, I used SQL Server’s inbuilt stored procedures to parse XML files, and they are very good at handling missing tags in xml files Review collected by and hosted on G2.com.

When we query a table with a huge volume of data, it takes a long time to retrieve the results and can cause deadlocks on the table unless we use NOLOCK. Review collected by and hosted on G2.com.

It’s fast, easy to use, and the performance is good. Review collected by and hosted on G2.com.

It’s very costly, and the support for NoSQL features is limited. Review collected by and hosted on G2.com.

I like how it integrates with other Microsoft products. Also, at least in Latin America, it’s basically the standard—if you literally don’t know SQL Server here, it feels like you’re not in tech, not in IT, and not a software engineer. Review collected by and hosted on G2.com.

nothing really, it's my favorite product of yours, I love it that from a couple of years ago it can be used on linux as well, and you can have a pretty good stack, lightweight, and then microsoft sql server on top of that Review collected by and hosted on G2.com.

The truth is, what I like most about Microsoft SQL Server is how practical and intuitive it is to use. I think the performance panel is wonderful, as it shows real-time metrics about the server's status. I also greatly value the SQL agent, which allows me to execute pre-configured tasks like table backups. I use the activity monitor a lot, as it helps me detect when there is a query that is stuck and causing slowness for users. Review collected by and hosted on G2.com.

Well, I recently upgraded to SQL Server 22.1.0 and sometimes when I try to check the performance panel, the application closes unexpectedly. It doesn't happen all the time, but it has happened to me a couple of times. I think the main thing is to make the application more stable, since the problem is that it consumes a lot of computer resources. Review collected by and hosted on G2.com.

I like Microsoft SQL Server's built-in functions and the possibility to write stored procedures and triggers. These features help me automate many processes and get relevant data on a daily basis, which is crucial because we update data and calculate metrics every day. I also appreciate that Microsoft SQL Server is more up to date compared to our previous solution. Review collected by and hosted on G2.com.

There are fewer code updates than in other databases. Some basic built-in functions are missing, like a delete duplicates function, and the ability to group by values calculated in the same select statement. Review collected by and hosted on G2.com.

Microsoft SQL Server offers reliable data storage, robust security features, and excellent performance for both transactional and analytical workloads, along with seamless integration with Microsoft tools. It also supports advanced querying, reporting, and business intelligence capabilities, while providing the scalability needed to meet growing business demands. Review collected by and hosted on G2.com.

SQL Server licensing can be costly, especially for enterprise editions. Managing large-scale deployments may require experienced administrators, and resource usage can be high. Some advanced configurations and performance tuning can also be complex for new users. Review collected by and hosted on G2.com.

I like that with Microsoft SQL Server, I can get any table data easily and perform any query effortlessly, whether it's a select, stored procedure, view, or function. The connection is good with no lag or discrepancy in the system. I appreciate having the backup and storage area available, which makes my work more reliable. The initial setup was also very easy if you know the credentials to your database. I find it helpful and even teach my colleagues how to use it. Review collected by and hosted on G2.com.

If I execute any query, it would be helpful if there is an option for rollback if I run the query by mistake. Sometimes, after reopening my application, the query page is lost. Review collected by and hosted on G2.com.