SQL Server Reviews

We use it for the banking database. It is for banking software, accounting software, and human resource software that we develop to run our bank.

In our production environment, we are using SQL Server 2014 Enterprise, but we also have an installation of SQL Server 2019 for our development environment.

It is secure, and it is fast. For our present database size, we are using the Always-On feature on SQL Server so that our transactions are replicated among three servers. If one server goes down, we can find the data from other servers. We have benefited from this feature.

We use SQL Server Reporting Services, and it is very good. We use scheduled jobs to transfer reports from one server to another server. 

It needs to be improved to handle big data for large volumes of transactions for big industries. As compared to Oracle Database, SQL Server is not suitable for big data or large organizations where the database size could be more than 100 GB or more. In our country, for a large database and a large volume of transactions, we normally use Oracle Database. Most of the large banks are shifting from SQL Server to Oracle Database because of its slowness. 

We have been using this solution since 2008.

For big organizations, like ours, SQL Server is very good in terms of reliability and security. It has the Always-On feature and many more features. I appreciate its reliability.

I don't know whether SQL Server can support large organizations where the database size is more than 100 GB. It might be because of SQL Server, or it might be because of the programming of the software vendor, but a lot of people think that it is a problem with SQL Server. It can't handle a large amount of data or large data size.

In terms of its usage, about 90% of our applications are running on the SQL Server database. We have around 1,600 users for our software, and all the applications are connected to the SQL Server database.

So far, we didn't ask for any technical support.

We used a flat-file database earlier, and since 2008, we have been using SQL Server. We started with SQL Server 2008 edition, and later on moved to 2012, 2014, and 2019.

We switched because there were many problems in the flat-file database. There was so much inconsistency. Some files were updated, and some files were not. There were big network issues. SQL Server has eliminated such issues, so either all transactions happen or nothing happens. This is a Relational Database Management System, and this is at another level compared to the flat-file database.

SQL Server is very user-friendly and very simple. It is very comfortable for us. We have been using it for a long time, so it is not a problem at all.

The deployment of our production server took less than 15 days.

It was done in-house with the help of our vendor. They have Microsoft-certified people. I have also worked on SQL Server for a long time, so we have an idea of how to migrate from one database to another. It was not a big issue for us.

At present, we have five people for its maintenance.

We are using licensed software for our environment. We have the Enterprise license, and we have a standard additional license.

As compared to Oracle Database, SQL Server is less expensive. For mid-sized organizations, SQL Server is completely all right, but people say it can't support large organizations with more than 2,000 users.

Before implementing SQL Server, you need to learn the concept, design, architecture, and data types of a relational database. You can learn it from YouTube. It is step-based, and you can install it. After that, you can migrate your existing SQL Server to the new SQL Server, depending on the size of the data, data architecture, and data type. 

I would rate it an eight out of 10 because I'm satisfied with SQL Server. It is working fine.

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 do data warehousing on it. We have databases on it. A lot of our applications use it for transactions and data.

We're using version 2019. We're trying to migrate to 2021 because 2023 is not yet that stable.

It works fine in terms of performance and stability.

I would like Microsoft to evolve SQL Server because stateful databases dying are in a way. We would like to find out if it can absorb Hadoop and other similar things. They should make it useful for data mining. Data is evolving forever, and how we store it is also changing constantly. So, SQL Server also needs to change.

I have been using this solution for two decades.

It works fine. There are no issues.

It is scalable. There are a lot of users. There are over 300 applications using this solution. Each application has its own users. In the technical team, there are about 13 people working with it.

I logged a ticket recently when I had an issue with the data manager. Their support wasn't that bad. I would rate them an eight out of 10.

I've used different solutions. There are times when I use Db2, and there are times when I use Oracle Database. Oracle beats SQL Server when it comes to procedures and process optimization.

The initial setup is easy. It takes 30 minutes at the most. What limits you is just your infrastructure in terms of:

• Do you have enough room on those servers to process that stuff?
• Do you have enough RAM resources?
• Do you have enough storage?
  

I can do it by myself.

It is annual.

I would recommend it to other users. I would rate it a nine out of 10.

The .NET applications use SQL Servers on a very large scale. Basically, about 80% or 90% of the database platform is on SQL Server.

We are working on version 2019, but we are also now working on the cloud databases. Our goal is to stay away from versions. We are going to go version-less and move to Azure SQL or managed instance, which is version-less. This way we won't need to worry about any upgrades or any version changes because Microsoft is going to take care of these things. We will always have the latest and greatest version.

It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale.

PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades.

Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching. 

There are a lot of improvements in the cloud space about which we open a case with Microsoft every now and then. These improvements are not in terms of features or functionality. They are more related to their own compatibility or connectivity on which they keep on working to improve the product.

I have been using this solution for 13 to 14 years.

In version 2019, they introduced a really good and stable environment. Bugs are there, but bug fixes are provided by Microsoft. We have premium support with Microsoft. If we find a bug, they work on it and provide a solution.

It is very scalable, but its scalability also depends on what you're using. If it is on-premise, you have to do everything on your own to scale it out. It is easy, but you have to get the infrastructure ready to scale it out. It is a manual process. If you're on a cloud, then it is pretty much easy and straightforward if your cloud has those availabilities. It also has a Hyperscale, where you can put the upper and lower limit, and it can scale up and down as per the use case and the compute that you need.

We have a lot of users. Everyone is connected to this. We have business users, technical users, application users, and integration users. We have 17,000 instances of SQL Server here with a lot of databases. 

We use Microsoft's Premium Support. They're good. I would rate them an eight out of ten. For on-premise, you design your infrastructure. When you change something or customize a few things, it is hard to get support because the issue can be from either side. When you have a critical issue, which is not straightforward, you have to go between two different vendors, and they start finger-pointing to each other. They say that the issue is not at their end, and there is nothing wrong with their configuration. The issue is because of storage or network. These are the few things for which you have to fight for support. I don't know how they will improve this. It only happens sometimes for an on-premise solution. We don't run into those issues on the cloud because it is their own setup.

A cloud solution is pretty much on their site. They are managing the infrastructure, so they have to provide the solution, and they are good at it, but when you have on-premise, you decide what storage to use. Sometimes, you ignore Microsoft's recommendation, and you don't want to use what they are suggesting. When we run into issues on the DB side or the application side, they can point out to different vendors or causes for issues. 

We also have Oracle, Db2, and MongoDB databases here. We also have some NoSQL apps, but comparatively, SQL Server has a bigger footprint, and it is better than the others. 

Other systems are more complex to configure. When you configure a cluster on the SQL itself, it is easy to configure because you've got more resources, whereas, when you have to configure Oracle or Db2, you have to have a SPEC process because they have to configure that on Red Hat Linux or Unix side. A few companies don't have special admins for Linux because the footprint is not that big. You might have two or three applications running on that system. When you run into a problem, you need to hire someone who can implement it for you, whereas most of the companies, almost 80%, are Microsoft shops. They already have the talent and resources available. You also have offline help and support. You have a lot of blogs or online help available when it comes to Microsoft, but when you go to other solutions like Oracle, sometimes it is a challenge. You really need the right person there, and not everyone will be able to do it. 

The capability of a solution also depends on your needs and configuration. If you configure things wrong, any system will fail. When I'm testing something, I always believe in the functionality because Microsoft and Oracle test their products thoroughly. I never question their functionality, but we also check it according to our plan. You have to customize things based on your needs. If you're not getting the results, you have to consult the tech support and bring them in to configure it. These are the things that you run into when you are in your own data center. If you are not getting the throughput from the storage itself, you need to get the storage admin or storage vendor in there. When you move to the cloud, everything is taken care of.

It is straightforward. There is no complexity. It is all automated, and we do un-attended install. We are not sitting and doing it. We just include it with the server build itself. When the server is built, we provide them the un-attended scripts to run, and everything is configured. They can use the media provided by Microsoft. Everything is done in one step. We just need to do auditing. We need to check at the right place, and we just keep checking it.

Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server.

You need to know the concepts and the business logic before using this solution. It is not straightforward. You need to know what your application needs are and only then you can work on it. You also need to know about the product and how it works.

I would probably advise others to move to the cloud version, which is a modern database. If you want to use SQL Server, Azure is the best because you get the hybrid benefits. You can bring your own license, and you can save costs. You can save 55% of the cost. With AWS, you have to buy your license, which makes it expensive. If you are using SQL Server and your company is more on the Microsoft side, Azure is easier, and there is no change in it. You can also get more out of it. You don't have to put a lot of complexity in supporting or administrating it because Microsoft does that for you behind the scenes. Therefore, it is good to move to Azure SQL or to manage instances where you have more control. Both of these are PaaS solutions. There is no need to go into IES. It is better to stay on-premise than on IES because it creates more complexity. This is because you still have to build the servers, and you have to still manage them. If your application is compatible to be used with PostgreSQL or MySQL, you can also move there.

It also depends on the kind of talent you have in your company. You have to consider the talent that you have. You can choose other technologies, but you need support from your teams. If they're .NET developers and you have to build the knowledge base, it is smoother to stay with SQL Server because you have to change less on the coding side.

I would rate SQL Server a ten out of ten.

There are certain shortcomings in the scalability of the product, making it an area where improvements are required.

From an improvement perspective, the price of the product needs to be reduced.

I have been using SQL Server for more than ten years. My company is a gold partner of Microsoft.

It is a stable solution. Stability-wise, I rate the solution a seven or eight out of ten.

It is quite a scalable solution. Scalability-wise, I rate the solution a seven out of ten.

My company's clients who use the solution are mostly enterprise businesses.

I rate the technical support a seven out of ten.

Neutral

I am using Amazon Cognito for the first time in my company.

I rate the product's initial setup phase a seven to eight on a scale of one to ten, where one is difficult, and ten is easy.

The solution is deployed on the cloud and on-premises models.

The solution can be deployed in a few minutes.

The product is expensive.

In our company's daily operations, we use SQL Server for our enterprise applications.

Speaking about how SQL Server played a critical role in a recent project, I would say that in my company, we used it for full management since we had a three-tier architecture and an enterprise application.

SQL Server was beneficial for data management needs, considering the fact that it was used as a part of SSIS packages, which was helpful for importing the data from legacy software.

The performance of the solution was good.

Though I can't elaborate on the valuable security features, I can say that I did not face any security concerns when using the product.

In SQL Server, I manage data recovery and backup with the help of database mirroring.

I recommend the product to those who plan to use it since it is easy to use.

I rate the tool a seven out of ten.

The solution is used as our backend database for our in-house applications. 

It's consolidated all of our Microsoft Access databases.

Having everything in one centralized set of databases is the most valuable feature.

Over the years additional features, data warehousing, cubing, just better performance and better manageability in terms of the actual Microsoft SQL Server AppLINK console.

I have experience with SQL Server. 

It is a highly stable solution. It was our database of choice because of its reliability. It just does what it says on the tin. We've never experienced any issues with it. I've never experienced any issues with it crashing or anything like that. 

The solution is very scalability. I rate the scalability a ten out of ten. 

Their technical team is very efficient. 

Positive

We switched to SQL for the reliability and scalability.

The initial setup is cumbersome as it's very menu-driven. The deployment takes half a day's time. We run it on a virtual machine or virtual service. We build a virtual server. We downloaded the ISO from Microsoft's licensing website.

I rate the setup an eight out of ten. 

The deployment was done by a single person, in-house. 

The SQL server is affordable. I rate the pricing a five out of ten. 

I rate the overall solution a ten out of ten. 

We use SQL Server for tuning data transactional language.

The product helps me tune the transactional language with the databases of our organization.

The product’s most valuable features are flexibility and scalability.

SQL Server could be more robust than Oracle.

I have been using SQL Server for ten years.

The product could be more stable than Oracle.

It is a scalable product.

The technical support services need improvement in terms of communication. It is difficult to understand the accents of the executives from different countries.

The initial setup is easy. The deployment services cost around $2000 to $3000.

SQL Server generates more return on investment than Oracle servers.

The product’s price depends on the specific server requirements.

I rate SQL Server an eight out of ten. It is easy to learn Microsoft products. There is a lot of information available about it on the internet.

I use SQL Server for my SharePoint environment.

It offers exceptional performance and robust stability, ensuring a highly secure environment.

The most valuable feature of SQL Server is that it is easy to set up.

There is room for improvement in terms of pricing for SQL Server.

I have been working with SQL Server for ten years.

I am working on the most updated version.

I would rate the stability a nine out of ten.

I would rate the scalability a nine out of ten.

I plan to increase my usage in the future.

I would rate the technical support a ten out of ten.

The initial setup is straightforward.

It is easy to install.

There is a return on investment. The cost benefits are good.

The cost associated with SQL Servers is on the higher side.

While there are other options available such as Oracle Database, Firebird, and MySQL, we specifically chose SQL Server to fulfill our needs for Microsoft services.

We opted for SQL Server as our scalable server solution to meet the requirements of our Microsoft services.

It's a good solution.

I would rate SQL Server a nine out of ten.