PeerSpot user
Pre-Sales/System Architect at a tech services company with 5,001-10,000 employees
MSP
Top 10
Provides many ways to help us organize data and process information.

What is most valuable?

The Microsoft SQL Server is a great and powerful data storage capable to provide many functionalities starts on free version until the power with BI resource and mirroring.

How has it helped my organization?

MS SQL is a recognized data tool, it provides many ways to help us organize data and process information.

What needs improvement?

MS SQL need to improve the big data functions and also own market share.

For how long have I used the solution?

since 1999

Buyer's Guide
SQL Server
March 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,886 professionals have used our research since 2012.

What was my experience with deployment of the solution?

few problems

What do I think about the stability of the solution?

no

What do I think about the scalability of the solution?

i didn't use it like admin, i don't know.

How are customer service and support?

great product

Which solution did I use previously and why did I switch?

Oracle, some times i used others solutions, but working by compatibility.

How was the initial setup?

easy.

What was our ROI?

never calculate.

What's my experience with pricing, setup cost, and licensing?

according you need

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
ASM at a healthcare company with 51-200 employees
Real User
A relational database management system that's easy to use, but performance could be better
Pros and Cons
  • "SQL Server is definitely easy to use, and with the volume that we have, it's also stable."
  • "Performance could be better. But I don't know if it's a problem with my application or with my database."

What is our primary use case?

It's a database that we use for our commercial applications, and our ERP sits on it.

What is most valuable?

SQL Server is definitely easy to use, and with the volume that we have, it's also stable.  Maintenance is much easier compared to other products. I may not be comfortable with Oracle because I don't have much experience with it. But in this case, SQL Server is much better for me. 

What needs improvement?

Performance could be better. But I don't know if it's a problem with my application or with my database. Maybe it can have the capability, but I may not be using it to the extent that it could be used, or the configuration is not as per the standard.

For how long have I used the solution?

I've been using SQL Server for over ten years.

What do I think about the stability of the solution?

SQL Server is a stable solution.

How was the initial setup?

The initial setup is very easy.

What about the implementation team?

I implemented this solution by myself.

What other advice do I have?

I would recommend this solution to potential users. If they have their own in-house team, they can manage it very easily. Microsoft is always easy to manage. It's a product where no expert is required for its maintenance.

On a scale from one to ten, I would give SQL Server a seven.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
SQL Server
March 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,886 professionals have used our research since 2012.
Project manager at a tech services company with 11-50 employees
Real User
A good choice in terms of price and quality, good speed, and good user interface
Pros and Cons
  • "Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better."
  • "There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented. Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version."

What is most valuable?

Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better.

What needs improvement?

There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented.

Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version.

For how long have I used the solution?

I have been using this solution for more than 15 years. Our clients are using its multiple versions, starting from SQL Server 2012.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

In general, it is scalable, but we are only using the single-server mode. We are not using any kind of clustering. Therefore, I cannot say anything from my personal experience about the scalability of Microsoft SQL Server.

How are customer service and technical support?

I do not have any experience with Microsoft support. We either use in-house knowledge professionals or third-parties for consulting services.

How was the initial setup?

Its initial setup is quite straightforward. A major upgrade is a bit more complicated. We had some issues with the upgrade.

What other advice do I have?

I would recommend this solution. It is a good choice in terms of price and quality.

I would rate Microsoft SQL Server an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
PeerSpot user
Management Trainee for Training at a tech services company with 11-50 employees
Consultant
It solved really complex situations

What is most valuable?

  • Net integration is best for me
  • Better optimizer
  • Ease of use (admin tools)

How has it helped my organization?

We used this to solve many complex problems.

What needs improvement?

Overall, trying to make over with Oracle, it can be improved in usage for high data migration companies of large scale.

For how long have I used the solution?

I have experience using both the versions of SQL Server 2008, 2012 for more than two years.

What do I think about the stability of the solution?

Never had issues with stability, may be we were handling structured data well.

What do I think about the scalability of the solution?

No, federal vs clusters approach explains you well that you can search for them.

How is customer service and technical support?

Technical support rating would be around a seven and a half out of 10.

How was the initial setup?

Setup is easy as what we want the database to do for our problems, compared to Oracle latest versions you need to spend more time on the initial setting up where these cannot go wrong with partitioning and indexing and it needs to be perfect.

What's my experience with pricing, setup cost, and licensing?

Go for SQL and compare it with pricing and stability with other Microsoft products.

Which other solutions did I evaluate?

Definitely yes, with Oracle only if the needed situations cannot be met, mostly it covers better.

What other advice do I have?

Best practices are the always a better choice for implementing the solution, hire a good expert and consult a better person with huge experience in architecting database systems for decades.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Web Content Editor at a consumer goods company with 501-1,000 employees
Vendor
The most valuable feature for us is SQL Server Migration Assistant for Access.

What is most valuable?

SQL Server Migration Assistant for Access (AccessToSQL).

How has it helped my organization?

We migrated loads of access database into large scale SQL server.

What needs improvement?

Access validation rules and expressions need improvement while converting into SQL Server.

For how long have I used the solution?

I've been using it for 10 years, and was using previously older versions and now I'm on the latest one.

What was my experience with deployment of the solution?

We just needed to upgrade Windows.

What do I think about the stability of the solution?

It was average.

What do I think about the scalability of the solution?

It was average.

Which solution did I use previously and why did I switch?

I previously used Oracle 11G, I switched because of less hardware resources were needed to run heavy software.

How was the initial setup?

It's straightforward to do providing you've read the manual.

What about the implementation team?

We did it in-house.

What was our ROI?

It's beneficial in terms of what the business gains from it.

What's my experience with pricing, setup cost, and licensing?

It's average to purchase.

Which other solutions did I evaluate?

We also looked at Oracle 11G.

What other advice do I have?

First look into scalability issues before adopting the right product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Information Security Engineer at a security firm with 11-50 employees
Real User
User-friendly interface, stable, and easy to install
Pros and Cons
  • "The most valuable feature is easy installation. It was very easy to install."
  • "I would like to see more integration with other products and it needs to be more secure."

What is most valuable?

The most valuable feature is easy installation. It was very easy to install.

The interface is very user-friendly.

What needs improvement?

I would like to see more integration with other products and it needs to be more secure.

For how long have I used the solution?

I have been using SQL Server for two months and I believe that we are using the latest version.

What do I think about the stability of the solution?

It's a stable solution. It's very stable.

What do I think about the scalability of the solution?

It is a scalable solution.

My installation requires SQL Servers, so I have to continue using them.

How are customer service and technical support?

I have not contacted technical support.

Which solution did I use previously and why did I switch?

Previously, we did not use another product.

How was the initial setup?

The initial setup was straightforward. The installation was easy.

It took two hours to deploy.

What about the implementation team?

I completed the implementation myself.

What other advice do I have?

I would recommend this solution to others who are interested in using it.

I would rate SQL Server an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Architect at a computer software company with 10,001+ employees
Real User
A user-friendly relational database management system
Pros and Cons
  • "It's more user-friendly than most databases."
  • "The performance could be better."

What is our primary use case?

Our server projects are mostly related to SQL Server, and we're using it. All our healthcare projects are using the SQL Server, and we're able to load millions of data without any issues.

What is most valuable?

It's more user-friendly than most databases. If we don't have to use the command mode, it's very easy.

What needs improvement?

The performance could be better. When we pump in millions of records, we start struggling, and that's why we want improvement in those areas.

For how long have I used the solution?

I have been using SQL Server for more than ten years.

What do I think about the stability of the solution?

In the past, it wasn't stable compared to other products like Oracle Db2, but it has improved, and now it's stable. 

How was the initial setup?

The installation is easy, and performance-wise it's okay now.

What about the implementation team?

SQL Server installation is easy, and we did it by ourselves.

What other advice do I have?

I would recommend this product to new users.

On a scale from one to ten, I would give Microsoft SQL Server an eight.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Programmer at a tech services company with 51-200 employees
Real User
Easy to set up with good scalability and extensive online documentation
Pros and Cons
  • "The product has very good online documentation that can be used for troubleshooting."
  • "The licensing costs are very high."

What is our primary use case?

We primarily use the solution as a database for business operations.

What is most valuable?

I personally work with Microsoft products and therefore I like the continuity it provides. I like sticking with the brand.

The solution is very stable.

The product has very good online documentation that can be used for troubleshooting.

The solution can scale as necessary.

We've found the setup to be quick and relatively easy.

What needs improvement?

The licensing costs are very high.

I would like the scaling process to be more transparent and obvious.

There's a lot of documentation on the web, and it is quite extensive, and yet it isn't very well organized which makes it hard to find items often.

For how long have I used the solution?

I've been using the solution for a very long time. It's been around ten years or more. I'd say it's been at least a decade at this point.

What do I think about the stability of the solution?

The stability of the solution is quite good. We don't have issues with it. It doesn't crash or freeze. We don't experience bugs or glitches. It's reliable.

What do I think about the scalability of the solution?

While I personally haven't gone beyond 50 or so users, it's my understanding that as long as you pay for the licensing, you can grow as much as you need to. There would be costs involved, however, the solution can scale if a company needs it to. 

I'd love to have Microsoft explain to me the scaling process so that I could better understand it. Right now, I'm in the dark.

How are customer service and technical support?

In terms of technical support, I can say that sometimes I need them. However, it's very difficult to contact Microsoft support for anything. 

In general, they have none. I wouldn't know how to reach them directly for help if I needed it.

Right now they have good support for their Azure product, in the cloud. However, this is not the case for on-premise products. That means, as an on-premise user, I have a problem. That said, since their product is well-known, there's a lot of documents on the web. If I try to search online I will typically find the answers I need. 

How was the initial setup?

The initial setup is not complex. It's pretty straightforward. It takes an hour or less to set everything up. Some people may need a few hours, however, for me, less than an hour was enough. That said, the Windows Server would also take an hour or two to set up as well.

What's my experience with pricing, setup cost, and licensing?

The solution certainly comes at a cost, however, for me, it's an acceptable cost. I find it acceptable due to the fact that it would be free if I use MySQL on-premise, however, then it would be hard to hire people to maintain it. It's a give and take. That said, the license cost is very very high. I'm afraid if I use it on a larger scale it will cost a lot.

What other advice do I have?

Currently, we're just Microsoft customers, although we would like to have a partnership with the company in the future.

I haven't done the HA for SQL server yet, therefore, I'm not sure how hard it is and how difficult it would be to implement, or how stable and how scalable it is.

There are two markets really. It's Microsoft and non-Microsoft. If anyone is familiar with Microsoft products, then they should go with this, however, they should bear in mind that it comes at a cost. The SQL cost is quite high if a company is using it at a large scale.

That said, if a company is looking at something small scale, there is a free edition. I use the standard edition, and it won't cost too much. 

In any case, for those that aren't tied to Microsoft options, there are a lot of products out there that might be suitable with very little overhead.

In general, I would rate the solution at an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2024
Product Categories
Relational Databases Tools
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.