Microsoft SQL Server Reviews & Product Details

The best thing about Microsoft SQL Server is its reliability and powerful performance for handling structured data. It offers a robust set of tools for data management, querying, and reporting, making it easy to work with large databases efficiently. I also like its strong security features, seamless integration with other Microsoft tools, and user-friendly interface through SQL Server Management Studio, which simplifies database administration and development tasks. Review collected by and hosted on G2.com.

One of the main drawbacks is its high licensing and maintenance cost, especially for small businesses or individual users. It can also be resource-intensive, requiring strong hardware for optimal performance. Additionally, some advanced features have a learning curve, and it’s less flexible compared to open-source alternatives when it comes to customization and cross-platform support. Review collected by and hosted on G2.com.

This app is used for storing databases and working with MS SQL language databases. Here, we can create a database, and then within the database we can create tables and do many more related tasks. It provides a very good interface, along with helpful troubleshooting, error handling, and clear support when issues come up. In my organization, we are storing our DB in the SSMS platform, and every day we are using this product. It's easy to use and understand. It gives the perfect error handling with line state number and how to solve this error and why it comes, and also gives SQL Server Profiler for debugging, and also provides backups and restores databases. when i am strating then i got some problem to understand but when i am using it day to day is it easy to handle. easy to intergrate. we can also perform try catch and transaction in ms sql for error handling .its gives the best performance some times when we are use this tools it will slow down our system and some times we got stucked and also takes too much timme to start .. Review collected by and hosted on G2.com.

It takes too long to start, and sometimes using this product slows our system down. As an organization, we use this tool with Red Gate, and the Red Gate extensions are costly. Also, it doesn’t provide an AI interface like other tools do. Review collected by and hosted on G2.com.

I've always liked the UI/UX far more than my experience with the alternatives, and I much prefer Microsoft's version of SQL. This has really helped when I've had to integrate with other systems, and I've been really happy by how quickly it performs. Pricing is always tricky, we'd all like to pay less than we do but thankfully I don't have to pay personally! Support has always been first class and I've never not been able to successfully develop. Review collected by and hosted on G2.com.

Nothing really stands out and I cannot think of anything to suggest. Review collected by and hosted on G2.com.

Without a doubt, its simplicity in a large part of the tasks and operations on it. Robustness, the fact of supporting multiple workloads and types of data; constituting, along with Oracle, the best convergent databases. The family of advanced functionalities IQP (Intelligent Query Processing) has been introducing greater automation through the versions. Analytical functions for macro data environments and PSP (parameter-sensitive plans), which allows caching up to 3 plans per statement. Review collected by and hosted on G2.com.

Your TCO, the licensing costs, or even as a service. Review collected by and hosted on G2.com.

Overall experience with SQL server 2016 is very nice and excited in my perceptions due to Better support for memory optimzed tables, Built in JSON support, Stretch DB concepts, Query Store and dynamic temp db according to size and presence of CPU in the databases Review collected by and hosted on G2.com.

Only I know very least number of disadvantages this MS SQL server 2016 is having:

1. Enterprise pricing may be costly as some of the organisation cant afford for the count of data they are having.

2 With the performance tuning, Microsoft SQL Server will be having some gobble resources 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.

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.

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.