SQL Server Reviews

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.

We do backups or restore or query tables to create the views, create some triggers to send the attachment report files, and to report on data.

It makes managing the database easy. Backups are very quick.

Sometimes we experience issues with its stability.

I have experience with SQL Server for 3-4 years. 

Sometimes we experience issues with its stability.

Five thousand users are using the solution. 

The initial setup is easy. Fifteen twenty minutes required for deployment. 

Overall, I would rate the solution an eight out of ten. 

We use the product as a database for the applications. 

The tool helps us by being available always. 

We don't encounter any issues with the solution. 

The tool is expensive.

I have been using the product for the last ten years. 

The solution is stable. 

The tool is scalable. 

The tool is easy to install. 

We have seen ROI with the tool's use. 

I would rate the tool's pricing a six out of ten. It is not extremely cheap but also it's not the most expensive product. 

I would rate the product an eight out of ten. 

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.

We primarily use the solution mainly for databases on all types of applications.

SQL is the all around leading Database server

The solution is very stable. 

The scalability of the product is great.

We'd like the deployment process to be better in the future. 

The licensing is pretty expensive.

I've been using the solution for 20 years at this point. It's been two decades. We've used it for a while now.

The solution is stable and the performance is great. There are no bugs or glitches. It doesn't crash or freeze.

The product scales well. If you need to expand it, you can do so.

We have 900 to 1,000 people using it currently.

I'm more on the architecture side and therefore do not directly deal with technical support. I cannot speak to how helpful or responsive they are.

We also use Oracle. We've used it for over a decade already.

The deployment could be easier.

While the deployment only takes about 15 minutes, you have to follow up with a lot of configuration.

We handled the implementation ourselves. We did not enlist the assistance of any integrators or consultants. It was all handled in-house.

We're paying too much for licensing at this time. They need to work on the pricing. They could be cheaper, however, it's also difficult to run the licenses in the right way.

We pay licensing fees on a yearly basis. 

We're a customer and an end-user. We don't have a business relationship with SQL. 

While everything is currently on-premises, we're making moves to shift to the cloud. 

We're using the 2019 and 2016 versions of the product.

I'd rate the solution at an eight out of ten. In general, we've been quite happy with its capabilities.