Sundaresan Subramanyan - PeerSpot reviewer
Founder and Managing Director at Analytic Brains Technologies Private Limited
Real User
Feature-rich databases and user-friendly interface
Pros and Cons
  • "SQL Server's Management Studio is very user friendly. I like their database and the additional features it offers. It's also easy to integrate SQL Server with things like CLR, PowerShell, and command shell"
  • "I would like to see SQL Server add the ability to write to multiple sites or support replication between multiple sites at the transaction level."

What is our primary use case?

SQL Server can be useful for a lot of businesses and enterprise solutions. SQL Server is very powerful and useful when you need to store, retrieve, process, and analyze a large amount of data. In my organization, almost everyone uses SQL Server. That's about 10 people using it.

What is most valuable?

SQL Server's Management Studio is very user-friendly. I like their database and the additional features it offers. It's also easy to integrate SQL Server with things like CLR, PowerShell, and command shell

What needs improvement?

I would like to see SQL Server add the ability to write to multiple sites or support replication between multiple sites at the transaction level. If we can have data available on multiple sites as quickly as possible, that would be a great feature.

For how long have I used the solution?

I've been using SQL Server for around 10 years. I have 30 years of experience in the IT industry. In that time, I have worked on different kinds of databases, such as Oracle. Before that, I worked on FoxPro. I have also worked with PostgreSQL.

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

What do I think about the scalability of the solution?

It's absolutely scalable. 

How are customer service and support?

Our clients are the end-users of the SQL Server applications, and we do all the development and maintenance for them. So anything related to support, our clients take care of it.

How was the initial setup?

I work on the development and performance-tuning side, so I don't do the installation but my guess would be that it is pretty straightforward by now. 

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

I am not aware of the cost because our clients take care of them, but I think there are enterprise licenses. If you go for Azure Cloud databases, then you just can pay as you go.

What other advice do I have?

SQL Server is my favorite database. Because I've been working on it for so many years, I like it. I have only good things to say about it. I would rate SQL Server nine out of 10.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Managing Partner at Bizz Advisers SRL
Real User
Stores and retrieves data requested by other applications
Pros and Cons
  • "I haven't really experienced any issues that required the assistance of technical support."
  • "The ability to connect with other environments needs to be improved."

What is our primary use case?

We use this solution to manage our database and store information. I use another platform for more specific needs.

Within our organization, there are roughly 10-12 employees using this solution. 

What needs improvement?

SQL Server consumes a lot of resources. You need to keep an eye on the number of resources involved. It expands and uses all of the memory available on the server. For this reason, I install it on separate machines.

Also, the ability to connect with other environments needs to be improved. 

For how long have I used the solution?

I have been using SQL Server for nearly 10 years.

What do I think about the scalability of the solution?

Scalability-wise, it's okay.

How are customer service and technical support?

I haven't really experienced any issues that required the assistance of technical support. 

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

I also use MySQL — the open-source version. I started using SQL Server because we required some special functionality for a specific project. 

How was the initial setup?

The initial setup was not complicated. You can do it without any external support. 

What about the implementation team?

I installed the entire solution myself within 20-50 minutes.

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

The price could always be lower. 

Which other solutions did I evaluate?

I evaluated Oracle, but I didn't like it — I prefer Microsoft. 

What other advice do I have?

I would absolutely recommend this solution to others. Overall, on a scale from one to ten, I would give this solution a rating of eight. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
SQL Server
April 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,599 professionals have used our research since 2012.
Kevin Honde - PeerSpot reviewer
Data Solution Architect at Econet Wireless Zimbabwe
Real User
Top 5Leaderboard
Easy to manage, stable and scalable, and has backup and recovery tools
Pros and Cons
  • "It is easy to manage for the administrator. It is also easy to use for applications that are Windows-based. It is a very stable product, and it has got backup and recovery tools."
  • "Its security can be improved. When you look at the Windows environment, it isn't the most secure environment. It is exposed to so many attacks. They continuously need to improve the security of the platform on which it sits."

What is our primary use case?

SQL Server is used as database software. People who are using .NET and Windows-oriented tools prefer SQL Server.

What is most valuable?

It is easy to manage for the administrator. It is also easy to use for applications that are Windows-based.

It is a very stable product, and it has got backup and recovery tools.

What needs improvement?

Its security can be improved. When you look at the Windows environment, it isn't the most secure environment. It is exposed to so many attacks. They continuously need to improve the security of the platform on which it sits.

For how long have I used the solution?

I have been using this solution for more than ten years.

What do I think about the stability of the solution?

It is very stable.

What do I think about the scalability of the solution?

It is pretty scalable. You can scale your machine and nodes. Instead of using just one node or one server, you can use multiple servers and then cluster them together for failover and performance. You can also do replication across sites. Currently, we have around 50 users.

How are customer service and technical support?

We have got support from Microsoft. They are very quick at resolving issues. They are quite good.

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

We were using different products. 

How was the initial setup?

It is easy to install. It might take 20 or 30 minutes to install.

What about the implementation team?

I installed it myself.

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

Its price is fine. You have to buy the license and support.

Which other solutions did I evaluate?

We compared it with Oracle and MySQL. We got a lot of dev inputs, and we also looked at the vendors supplying the solutions. We found SQL Server to be the best and chose it because of the vendor.

What other advice do I have?

I would recommend this solution to others. We would definitely keep on using this solution.

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
Girish Vijay - PeerSpot reviewer
Deputy Manager IT at Carl Bechem Lubricants India Pvt. Ltd.
Real User
Top 5
Users can quickly and efficiently retrieve a large amount of records from a database
Pros and Cons
  • "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."
  • "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."

What is our primary use case?

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.

How has it helped my organization?

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.

What is most valuable?

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

What needs improvement?

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.

For how long have I used the solution?

Since two years

What do I think about the stability of the solution?

Very good stability with 250-300 users.

What do I think about the scalability of the solution?

This product can withstand with 250-300 users.

How are customer service and technical support?

Very good.

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

SQL standard 2008.

How was the initial setup?

Straightforward - no complexity.

What about the implementation team?

Vendor team with an in-house team.

What was our ROI?

2 years.

What other advice do I have?

It is an overall very good product.

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
Chief ICT Officer at Barbados Public Workers Cooperative Credit Union Ltd
Real User
Top 5
A scalable and stable solution that works as a database for applications
Pros and Cons
  • "The tool helps us by being available always."
  • "The tool is expensive."

What is our primary use case?

We use the product as a database for the applications. 

How has it helped my organization?

The tool helps us by being available always. 

What is most valuable?

We don't encounter any issues with the solution. 

What needs improvement?

The tool is expensive.

For how long have I used the solution?

I have been using the product for the last ten 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?

The tool is scalable. 

How was the initial setup?

The tool is easy to install. 

What was our ROI?

We have seen ROI with the tool's use. 

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

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. 

What other advice do I have?

I would rate the product 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
Miyoba Sichimwi - PeerSpot reviewer
Information Technology Security Officer at South African National Accreditation System (sanas)
Real User
Top 10
Beneficial support system, highly scalable and reliable
Pros and Cons
  • "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."
  • "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."

What is our primary use case?

All our databases are using Microsoft SQL. It supports our application, such as HR and finance.

What needs improvement?

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.

For how long have I used the solution?

I have been using SQL Server for approximately 10 years.

What do I think about the stability of the solution?

SQL Server is highly stable.

What do I think about the scalability of the solution?

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. 

How are customer service and support?

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.

How was the initial setup?

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.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
General Manager IT at a manufacturing company with 10,001+ employees
Real User
Top 20
User-friendly database with excellent backup features
Pros and Cons
  • "The backup capabilities are extremely good."
  • "I would like to have the ability to restore backups in the next release."

What is our primary use case?

This application is used as a contact center and would be great for banks.

What is most valuable?

The backup capabilities are extremely good.

What needs improvement?

I would like to have the ability to restore backups in the next release.

For how long have I used the solution?

I have been working with SQL server for the past ten years.

What do I think about the stability of the solution?

This solution is very stable from what we have seen.

What do I think about the scalability of the solution?

This is a scalable solution.

How are customer service and support?

Technical support is very good. I am able to easily contact them and they are very informative.

How was the initial setup?

The initial setup was straightforward.

What other advice do I have?

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.

Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
PeerSpot user
Ashif  Shaikh - PeerSpot reviewer
Senior Database Administrator at a tech services company with 501-1,000 employees
Real User
Secure, good GUI, and easy to use
Pros and Cons
  • "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."

What is our primary use case?

We are using it for storing important data. 

What is most valuable?

Its security is good. The GUI of SQL Server is also very good.

What needs improvement?

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.

For how long have I used the solution?

I have been using this solution for almost 10 years.

What do I think about the stability of the solution?

Its stability is good.

What do I think about the scalability of the solution?

Its scalability is good.

How are customer service and support?

I haven't spoken to their support team in the last three years, but prior to that, their support was good.

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

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.

How was the initial setup?

It is very easy.

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

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.

What other advice do I have?

I would recommend SQL Server for its stability, scalability, and ease of use. I would rate it an eight out of 10.

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.
PeerSpot user
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 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.