SQL Server Reviews

We're using it for our on-premise servers, and we have the latest version of SQL Server.  

We use SQL Server for the database for Microsoft Navision. We also use it for the Track-It application that helps users in logging in their IT requests. We also manage all the IT inventory through Track-It. It does automatic auditing and traces online IT equipment.

We have end-computing devices with a server-client type of model. We have a server. All terminals are dumb terminals, but they get connectivity from SQL Server, and it has worked really well. We operate in difficult locations, such as Mombasa in Kenya and Mozambique in Maputo, where power is a big problem. Instead of desktop computers, we went for thin end-computing clients, and it worked really well with SQL Server.

It is a stable product, and it runs seamlessly. It is not complex.

It has been there for a long time, and they are doing whatever bug fixes they have to do. 

They have too many licensing options. They may want to simplify its licensing and bring it down to two, three, or four categories from ten to fifteen categories. Having so many different licensing options makes it difficult to decide which one to choose from. They can club things together. This is an area where they can make things easier for customers.

I have been using SQL Server for ten years.

It is a stable product.

It has pretty good scalability. In terms of usage, we have two different types of usage. For end-computing usage, we have about 600 or 700 students who use the media labs. For Microsoft Navision and Track-It, we have about 100 staff members as users. 

It is being used fairly extensively. Microsoft Navision is one of the core solutions of our business, and it is used on a daily basis. End computing is used by students. Because of the pandemic, for the last 14 months, everything is closed, and everybody is remote, so end computing has not been used, but Navision continued to be used. After the school reopens in each location, we will continue to use it even more. We definitely have plans for expansion.

Their response is fast.

Its initial setup is very straightforward. In case there is an issue, Microsoft's tech support people come online and help you.

For its deployment and maintenance, two people are required at each location. We have one database specialist and one IT service delivery engineer with networking knowledge.

It comes with the bundle package that we have. We have Microsoft Volume Licensing, so we don't have to pay for it separately. It is a part of the package.

I would definitely recommend this solution. I have nothing to complain about.

I would rate SQL Server a nine out of ten. 

We are primarily using the solution for pulling data and analysis.

In the auto industry, are the dealer management systems for which there is kind of portals from which the dealers are maintaining information can have access to retail data, bookings, and details surrounding individual customers.

We are fetching data and using it for analytics purposes, basically.

The basic features of the solution are excellent overall.

The initial setup isn't overly complex.

The pricing is reasonable.

The solution scales well.

The solutions very fast. It reads and writes six to eight times faster than any other tool.

The solution is very different from Oracle, which is a product we also use.

Mainly the data capacity needs to be improved. The data values are limited. They are smaller or medium scale. The MySQL is working fine, however, when it comes to large data sets or large data volumes, Oracle can handle them better. The backup capacity needs to be bigger.

When it's medium or small-scale data volume, people are referring to MySQL, however, when the data volume grows the people are referring to Oracle. In my estimation, the stability is fine.

The scalability of the product is pretty good. It can scale effectively and expands better than other options.

We have around 40 users on the solution currently.

Our main usage is not for the database and we simply use basic aspects of the platform.

Technical support isn't an aspect of the solution I know too much about. I've never been in direct contact with them. Therefore, I can't speak to how helpful or responsive they are. 

We also currently use Oracle. 

The initial setup isn't too complex or difficult. It's pretty straightforward. It's less complex of a process as compared to other solutions.

The cost isn't overly expensive. It's very reasonable. Our customers are happy with the price. It's in a good range.

We are partners with Microsoft. We use multiple deployment models, and typically those are private cloud or on-premises options.

Overall, I would rate the solution at an eight out of ten. We've been mostly very satisfied with the capabilities of the product. It's fast. It's our preferred product.

I'd recommend the solution to other users and organizations.

SQL Server is used as database software. People who are using .NET and Windows-oriented tools prefer SQL Server.

It is easy to manage for the administrator. It is also easy to use for applications that are Windows-based.

It is a very stable product, and it has got backup and recovery tools.

Its security can be improved. When you look at the Windows environment, it isn't the most secure environment. It is exposed to so many attacks. They continuously need to improve the security of the platform on which it sits.

I have been using this solution for more than ten years.

It is very stable.

It is pretty scalable. You can scale your machine and nodes. Instead of using just one node or one server, you can use multiple servers and then cluster them together for failover and performance. You can also do replication across sites. Currently, we have around 50 users.

We have got support from Microsoft. They are very quick at resolving issues. They are quite good.

We were using different products. 

It is easy to install. It might take 20 or 30 minutes to install.

I installed it myself.

Its price is fine. You have to buy the license and support.

We compared it with Oracle and MySQL. We got a lot of dev inputs, and we also looked at the vendors supplying the solutions. We found SQL Server to be the best and chose it because of the vendor.

I would recommend this solution to others. We would definitely keep on using this solution.

I would rate SQL Server an eight out of ten.

ERP Database.

Using the SQL queries, the user can quickly and efficiently retrieve a large number of records from a database. In standard SQL, it is very easy to manage the database system. It doesn't require a substantial amount of code to manage the database system. Long established are used by the SQL databases that are being used by ISO and ANSI. Using the SQL language, the users can make different views of the database structure.SQL has a difficult interface that makes few users uncomfortable while dealing with the database.

Microsoft database is very user friendly. This new version of SQL Server continues to meet these twin demands. It adds new features from the worlds of data science and NoSQL. It offers cross-platform capabilities and Docker container compatibility. But it also reinforces its investment in core database engine performance, ease of index maintenance, high availability, and data warehouse performance. That's a difficult balance and one that other database vendors don't have to meet. While this may be Microsoft's cross to bear, the company does pretty well with it, turning a formidable challenge into a positive market differentiator.

The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful. Two other new batch mode features, memory grant feedback, and adaptive joins will enhance SQL Server's performance and efficiency as well. It is good to move from Microsoft to deal with big data analytics

CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server. A SQL Server CAL is required for a user to access or use the services or functionality of either edition of SQL Server and frequent updates to the latest versions will lead to obsolete and discontinuing the security patches has to be improved.

Since two years

Very good stability with 250-300 users.

This product can withstand with 250-300 users.

Very good.

SQL standard 2008.

Straightforward - no complexity.

Vendor team with an in-house team.

2 years.

It is an overall very good product.

All our databases are using Microsoft SQL. It supports our application, such as HR and finance.

SQL Server could improve by being more user-friendly, it is still geared towards specialists. Additionally, the monitoring system is difficult to use, not everyone can use it well. The configuration should be able to be done through the GUI.

I have been using SQL Server for approximately 10 years.

SQL Server is highly stable.

SQL Server is very scalable because we use it across a couple of different types of applications, such as micro-infrastructure setup and server farm.

The solution is suitable for any environment, such as small, medium, and large enterprises. 

SQL Server support system is well-established. It's a Microsoft solution therefore you receive support very easily. It is the number one selling point of SQL Server. I have been highly satisfied with the support.

SQL Server's initial setup is simple. However, you must be a specialist to do it. That's the unfriendliness that I see about the solution. It has to be done by an engineer and not any engineer can do it, you have to be a specific Microsoft engineer.

My advice to others would be to create a standard for SQL Server to allow a high level of security. What we did is, we adopted CIS, which is the Center for Information Security, hardening standards and benchmarks to keep it secure. SQL Server out of the box comes with a lot of unnecessary services that can make you very vulnerable to any site attack.

I rate SQL Server an eight out of ten.

This application is used as a contact center and would be great for banks.

The backup capabilities are extremely good.

I would like to have the ability to restore backups in the next release.

I have been working with SQL server for the past ten years.

This solution is very stable from what we have seen.

This is a scalable solution.

Technical support is very good. I am able to easily contact them and they are very informative.

The initial setup was straightforward.

This is a great solution for anyone with basic knowledge of DNS who wants to build up a database. There are many videos to help you navigate the platform.

I would rate this solution a nine out of ten.

We are using it for storing important data. 

Its security is good. The GUI of SQL Server is also very good.

It is very costly, and that's the reason people are moving away from SQL Server. 

They have started using Linux, and Linux is the way forward for SQL Server. They have to invest a lot in that.

I have been using this solution for almost 10 years.

Its stability is good.

Its scalability is good.

I haven't spoken to their support team in the last three years, but prior to that, their support was good.

I also have experience with Postgres. The main difference between SQL Server and Postgres is that Postgres is open source. The Community version of Postgre is basically free. Postgres is very easy to set up and very easy to scale. It is quite a good database.

It is very easy.

It is expensive in terms of licensing costs and pricing. If you want to scale SQL Server, it is very expensive.

We probably have to pay extra for technical support. We also have to pay for the license of Windows on which the SQL Server resides, which is an extra cost.

I would recommend SQL Server for its stability, scalability, and ease of use. I would rate it an eight out of 10.

We use the product as a database, a data tool for everything. 

SQL Server, as a database, is great.

When it comes to the governmental sector, it is easily dealt with and can handle a big load of data. Specifically, after they added the capability of building a big data cluster from the SQL Server itself it's been great. 

If it was a database developer who was working with it or database admin, it provides a lot of tools and potential utilization that helps in doing the work in the right way.

Stability-wise, it's stable. 

If we want to expand to other servers and create an extra node, it's expandable. If you want to connect it with another, let's say, cloud node, it's also expandable with the cloud node. 

Security-wise, it provides most of the required security aspects in the market suchg as hashing, or encrypting, or hiding some data in tables (according to privileges and tools of the users). That can be done throughout it easily. 

It's an out-of-the-box solution. Lately, after they created the SQL Azure, if you use the Azure SQL Explorer, or SQL Server Management Studio, both of them can connect to the same database easily. It's natively built on the same core.

In my experience, while working with multiple sectors, such as banking, services, et cetera, there are some limitations for some sectors when dealing with the data.

It would be great if we were able to run it on multiple operating systems and not only stick with Windows. 

I've been using the solution for five or maybe six years. It's been a while. 

The stability is great. there are no bugs or glitches. It doesn't crash or freeze. Its performance is reliable. 

It's very easy to scale the solution in multiple ways. If a company needs to expand, it can do so easily.

I can't say it is easy to deploy as it depends on the admin, however, it is doable. Most of the databases, in general, require configuration. Therefore, if the admin knows what he's doing, then it's super easy.

A full deployment, depending on what is needed, might take anywhere from 15 to 30 minutes. It's fast.

I can't speak to the pricing. I don't have any information on that.

It's my understanding that we pay for licensing on a yearly basis. 

There is also another added product they created, called Synapse, Azure Synapse Analytics. Both of them are similar to Microsoft PowerBI on-prem with SQL Server on-prem.

I would rate the solution at an eight out of ten. There are other competitors that are also doing a very good job as well.