We manage backups for our customers, so we are not developers and we don't use SQL to provide a service. We are a managed service provider focused more on IT support and SQL configuration. So we don't use SQL as a product by ourselves. Instead, we provide instructions for how to back up SQL and do maintenance on it for our customers who need a SQL server for their CRM and ERP products. Their products need to have a SQL server to use in order to use their services. So we handle the maintenance for our customers.
CEO at netison
Simple to use and in demand among our customers
Pros and Cons
- "SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer."
What is our primary use case?
What is most valuable?
Microsoft has a very broad landscape of products that they provide—almost everything that you need. SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer. And even if you don't like Microsoft, you should know how to use it because just about every customer uses Microsoft, so you have to use it. So it doesn't matter if I like it. It's everywhere, so you have to know how to use it.
For how long have I used the solution?
I've been using Microsoft SQL Server for 25 years now.
What's my experience with pricing, setup cost, and licensing?
We are a reseller of Microsoft. We also signed the SPLA agreement, which stands for Services Provider License Agreement. So we are able to use Microsoft products in our data center in order to provide cloud services to our customers.
Buyer's Guide
SQL Server
November 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,723 professionals have used our research since 2012.
What other advice do I have?
I rate SQL Server nine out of 10.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Pre-Sales/System Architect at a tech services company with 5,001-10,000 employees
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
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 technical 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.
Buyer's Guide
SQL Server
November 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,723 professionals have used our research since 2012.
Reliable and easy to use with good technical support
Pros and Cons
- "The solution is very common. It's easy to use."
- "The solution is expensive. The licensing costs are high."
What is our primary use case?
The solution is primarily used as a relational database. It's a great option for anyone who needs to still use a database.
What is most valuable?
The solution is very common. It's easy to use.
The product offers a lot of support. Technical support has been great.
It's a reliable solution currently in this space.
The solution doesn't take a long time to set up. It's pretty straightforward.
What needs improvement?
The solution is expensive. The licensing costs are high.
For how long have I used the solution?
I've been dealing with the solution for 20 years or so. It's been two decades. I've used it for a while.
What do I think about the stability of the solution?
The stability is pretty good. I find it to be reliable. There are no bugs or glitches. It doesn't crash or freeze. The performance is good.
What do I think about the scalability of the solution?
We have 150 users on the solution currently.
How are customer service and technical support?
I've contacted Microsoft technical support in the past and have been satisfied with the level of service I get. They're good.
How was the initial setup?
We have a special database team that is running. Except for the initial installation of the hardware, they are doing everything as it's an in-house solution.
It took a day or two to implement. It might have even taken less time.
What about the implementation team?
We have a team that can manage the implementation process.
What's my experience with pricing, setup cost, and licensing?
The licensing is a bit expensive. We'd like them to be more flexible in terms of costs.
We pay a yearly licensing fee.
Which other solutions did I evaluate?
We did not evaluate other solutions before implementing this solution.
What other advice do I have?
I'm using either the 2018 or 2019 version of the solution. I don' know the exact number off-hand.
I'd rate the solution at an eight out of ten. It's a very good solution and I've been pretty happy with its capabilities.
I would recommend the solution to other users.
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.
Project Manager at a comms service provider with 51-200 employees
Overall good functionality, scalable, and stable
Pros and Cons
- "In Poland, SQL Server is the most popular database engine, and overall, our customers like it."
- "For small-scale businesses, Microsoft could improve by removing some limits in SQL Express."
What is our primary use case?
SQL Server is our main database solution. For example, we use it for our contact center software.
What is most valuable?
In Poland, SQL Server is the most popular database engine, and overall, our customers like it.
What needs improvement?
For small-scale businesses, Microsoft could improve by removing some limits in SQL Express.
In the future, it would be a benefit to have web-based management capabilities.
For how long have I used the solution?
I have been using this solution for approximately five years.
What do I think about the stability of the solution?
Five years ago there were some stability issues but in the current version, the stability is good.
What do I think about the scalability of the solution?
The solution is scalable.
How are customer service and technical support?
We use the documentation provided online by Microsoft that has been helpful. We do not need to use technical support because we have many high-level technical staff who know how to use the solution.
How was the initial setup?
The initial setup is very simple.
What's my experience with pricing, setup cost, and licensing?
For smaller companies, they find this solution expensive.
What other advice do I have?
I rate SQL Server an eight out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: reseller
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.
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.
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Product Categories
Relational Databases ToolsPopular Comparisons
MySQL
Oracle Database
Teradata
MariaDB
SAP HANA
IBM Db2 Database
Amazon Aurora
CockroachDB
LocalDB
IBM Informix
Oracle Database In-Memory
Citus Data
YugabyteDB
SAP IQ
SAP SQL Anywhere
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?