We use SQL Server for collecting and storing our data.
IT Specialist at a government with 1,001-5,000 employees
A relational database management system that's relatively stable
Pros and Cons
- "I like that it's relatively stable."
- "It would be better if it had more integration with other systems."
What is our primary use case?
What is most valuable?
I like that it's relatively stable.
What needs improvement?
It would be better if it had more integration with other systems.
For how long have I used the solution?
I have been using SQL Server for over five years.
Buyer's Guide
SQL Server
December 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
830,596 professionals have used our research since 2012.
What do I think about the stability of the solution?
I think it's scalable.
What do I think about the scalability of the solution?
It's relatively stable.
How are customer service and support?
Technical support is good. When I have a problem, they're responsive.
How was the initial setup?
I've tried to do the initial setup, and I don't think it's that easy. But I think the configuration is normal.
What about the implementation team?
I set up and deployed this solution myself.
What other advice do I have?
I would recommend this product to new users.
On a scale from one to ten, I would give 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.
Chief of Information Technology at a manufacturing company with 201-500 employees
Review about SQL Server
Pros and Cons
- "We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use."
What is most valuable?
We have found there are many useful features such as the solution is continually being upgraded, ETL capabilities for extracting and transformation, and it is very easy to use.
What do I think about the stability of the solution?
The solution has been really stable in my experience.
What do I think about the scalability of the solution?
We have approximately 20 to 30 users of the solution in my organization here in Colombia, Mexico.
How was the initial setup?
The initial setup is simple.
What's my experience with pricing, setup cost, and licensing?
The price of the solution could be reduced, it is expensive.
What other advice do I have?
I rate SQL Server a nine out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
SQL Server
December 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
830,596 professionals have used our research since 2012.
Project manager at a tech services company with 11-50 employees
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
Management Trainee for Training at a tech services company with 11-50 employees
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.
Web Content Editor at a consumer goods company with 501-1,000 employees
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.
Cloud DBA at UNIT4
Its stability delivers performance and usability and it has good reporting services
What is our primary use case?
- Effectiveness in a production environment
- New features test
How has it helped my organization?
Besides that, SQL Server has become very expensive like Oracle. Its stability delivers performance and usability.
What is most valuable?
- SSMS
- SSIS
- Reporting services
- FCI clustering
- AlwaysOn
- Basic availability groups.
What needs improvement?
I would like a mature real-monitoring built in into SSMS, even a trace file analyzer.
For how long have I used the solution?
Less than one year.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Deputy Manager at a computer software company with 10,001+ employees
Helpful support, scales to our requirements, and handles our critical applications
Pros and Cons
- "I have contacted technical support, and overall my experience with technical support was okay."
- "I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements."
What is our primary use case?
We are business consults. We use SQL Server to ensure that critical applications remain operational by performing BCM activities across application and database servers.
What is most valuable?
SQL Server has scaled as per our requirements.
What needs improvement?
I would like to see improvements made to the stability of SQL Server, as well as more analytics requirements.
For how long have I used the solution?
From a restoration perspective, I have been working with SQL Server for a few years.
What do I think about the stability of the solution?
The stability of the SQL Server needs improvements.
What do I think about the scalability of the solution?
We have over 2,000 users in our organization.
How are customer service and support?
I have contacted technical support, and overall my experience with technical support was okay.
How was the initial setup?
The installation took a few days to complete.
We have a team of three or four admins to maintain this solution.
What about the implementation team?
We had assistance from an integrator.
What's my experience with pricing, setup cost, and licensing?
Licensing fees are paid on a yearly basis.
Which other solutions did I evaluate?
We were evaluating other solutions for a specific requirement in our organization. The requirement is now complete.
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.
Chief Technology Officer at a financial services firm with 11-50 employees
Stable, simple installation, but scalability could improve
Pros and Cons
- "The initial setup was straightforward."
- "I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server."
What is our primary use case?
The main use of this solution is to control and manage data storage information.
What needs improvement?
I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server.
For how long have I used the solution?
I have been using the solution for approximately two years.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
I find the solution not to be scalable.
There are approximately six people in our company using SQL Server.
How are customer service and support?
I have not needed to contact technical support.
How was the initial setup?
The initial setup was straightforward.
What about the implementation team?
I did the implementation of the solution myself, it does not require any consultants or integrators.
What other advice do I have?
I rate SQL Server a six out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
Product Categories
Relational Databases ToolsPopular Comparisons
MySQL
Teradata
Oracle Database
MariaDB
SAP HANA
IBM Db2 Database
Amazon Aurora
CockroachDB
LocalDB
IBM Informix
Oracle Database In-Memory
Citus Data
YugabyteDB
SAP IQ
SAP Adaptive Server Enterprise
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Microsoft sql2017 VS SAP Hana
- SQL Server 2005 vs. InfoBright - what are the pros and cons of these solutions?
- SQL Server 2012 - can I make OLTP transactions from my ERP run in memory?
- How does NuoDB compare to MySQL and SQL Server?
- What are the main architectural differences between Microsoft SQL Server and Oracle Multitenant?
- Would you say the price of SQL Server is high compared to that of similar products?
- Has using SQL Server helped your organization in any way?
- Which authentication mode is best for SQL Server?
- Which solution do you prefer: Microsoft SQL Server's enterprise edition or Oracle Database's enterprise edition?
- Which is better: SQL Server or SAP HANA?