Try our new research platform with insights from 80,000+ expert users
reviewer1413750 - PeerSpot reviewer
Lead Data Architect at a financial services firm with 1,001-5,000 employees
Real User
Easy to use and integrates well with other Microsoft products, but the performance needs improvement, and there are many hidden costs at the enterprise level
Pros and Cons
  • "The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products."
  • "The performance needs some improvement and it needs more features integrated into it."

What is our primary use case?

We are using SQL server for both transactional and analytical purposes, and for storing the data.

How has it helped my organization?

We are familiar with Microsoft products and bringing another Microsoft product was a very easy transition.

What is most valuable?

The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.

What needs improvement?

The performance needs some improvement and it needs more features integrated into it.

Technical support could be better. 

Scalability could be less costly.

One of the conflicts with Microsoft is if you have an enterprise relationship, you have to deal with a third-party offering Microsoft solutions.

In the 2016 version, they don't have support for Python. It may be included with the 2019 version but if they don't, I would like to see support for Python implemented.

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.
824,067 professionals have used our research since 2012.

For how long have I used the solution?

The company has been using this solution for approximately 20 years. I was in contracting and now have been using it for approximately five years.

What do I think about the stability of the solution?

SQL Server is pretty stable.

What do I think about the scalability of the solution?

There is a concern with the scalability because it's an on-premise technology. 

Scaling always comes with more costs and also the licensing cost increase, which makes it complex, and more difficult.

We have backend developers, data engineers, data scientists, and analysts using this solution.

How are customer service and support?

Most of the time, technical support is not straightforward and it goes to a third party.

I wouldn't say that it is great, but okay.

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

Previously, we had not used any other solutions. We have been a Microsoft shop from the beginning.

How was the initial setup?

The initial setup was not easy but not complex. Rather, it was somewhere in between.

What about the implementation team?

We did not use an integrator or reseller to deploy this solution.

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

Pricing is reasonable for small organizations, but the scaling increases the price.

For larger organizations that would be using enterprise solutions, it contains some hidden costs.

What other advice do I have?

It's suited for small organizations, but if someone from a larger organization is looking for this, they might have some problems implementing enterprise-wide solutions. This is because of the integrations, as there would be hidden costs to it.

The best parts of this solution are the costs and that it is easy to use, but the cons would be with implementing an enterprise-wide solution. There are many hidden factors, such as costs. Also, you have to put more effort into integrating with other solutions across the enterprise.

I would rate this solution a six 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
System administrator at a mining and metals company with 10,001+ employees
Real User
Has high availability and good performance
Pros and Cons
  • "The availability is the most valuable feature. It has high availability. It also has good performance."
  • "In terms of improvement, it could use more integration with other products."

What is our primary use case?

My primary use case is for data mining and processing data from plants. It's normally just for databases for the systems.

What is most valuable?

The availability is the most valuable feature. It has high availability. It also has good performance. 

What needs improvement?

In terms of improvement, it could use more integration with other products.

For how long have I used the solution?

I have been using this solution for around ten years. 

What do I think about the stability of the solution?

The stability is good. We don't have any issues with stability or scalability. 

How are customer service and technical support?

We have contacted support when we had Windows issues. They are okay, not the best but not the worst. They know what they're doing but they take a little too long. The response time isn't so good. 

How was the initial setup?

The initial setup is mostly straightforward. The time it takes to deploy depends on the circumstances. It takes around three or four hours. 

What other advice do I have?

I would recommend this solution. It's a good product. I am satisfied with it. It's familiar, we've been using SQL for a while. 

I would rate it a nine out of ten. There's always room for improvement. 

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
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.
824,067 professionals have used our research since 2012.
reviewer1030020 - PeerSpot reviewer
Programmer Analyst at a tech services company with 10,001+ employees
Real User
Creating and implementing stored procedures is a valuable features

What is our primary use case?

Very pleasing and satisfying experience.

  • Used to create queries
  • Implemented store procedures
  • DBA can also use this effectively.

How has it helped my organization?

  • Used to create queries
  • Implemented store procedures
  • DBA can also use this effectively. 
  • Reduces other manual work.

What is most valuable?

  • Creating and executing SQL queries, transactions, ACID properties
  • Creating and implementing stored procedures.

What needs improvement?

Every good tool has its own limitations. 

  • First of all its cost. It is very high. 
  • We need a good amount of RAM to properly use this. 
  • Sometimes, query sticks in between. 

But our organization provides great RAM, so we don't have any issue with its speed.

For how long have I used the solution?

More than five years.

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

No.

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

It's good.

Which other solutions did I evaluate?

No.

What other advice do I have?

Go for it. Thumbs up.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user796899 - PeerSpot reviewer
Sr. Database and Application Administrator with 10,001+ employees
Real User
It will do clustering, so you can have two database servers looking at the same data simultaneously
Pros and Cons
  • "You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations."
  • "It is a simple query language. It is consistent across all versions. If you start with an older version, move to the newer version. The same code will still work."
  • "It can go easily on a virtual machine and be accommodated by a virtual machine easily. That is a plus, as not all databases can handle that."
  • "It will do clustering, so you can have two database servers looking at the same data simultaneously."
  • "It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it."

How has it helped my organization?

It allows me to obtain access to data that I would not otherwise obtain access to from different programs. It has helped pull statistics and data, then put it into a report form to do some Power BI on it. This really helps people above me to view what we are doing, how we are doing it, and how to improve it.

Overall, it just makes your job simpler.

What is most valuable?

  • Ease of installation.
  • Ease of creating your databases.
  • Ease of changing what your databases look like when you need to.
  • Creating tables is simple.
  • They have lots of different options that you can use for the fields within the tables. 

It is a simple query language. It is consistent across all versions. If you start with an older version, move to the newer version. The same code will still work.

It can go easily on a virtual machine and be accommodated by a virtual machine easily. That is a plus, as not all databases can handle that. It also will do clustering, so you can have two database servers looking at the same data simultaneously. 

You can always access the data. You could have an offsite and an onsite, and if the onsite goes down, the offsite picks it up. I like that flexibility to provide continuing operations.

What needs improvement?

Right now, the tool you use to query the system updates every month. It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it.

What do I think about the stability of the solution?

I have no problems with stability at all, even when they are clustered.

What do I think about the scalability of the solution?

Scalability depends on the version. I have to know ahead of time what version I need, but that is typical of all database software. However, as long as I build it correctly, it works great.

How are customer service and technical support?

I have not had support for the SQL Server product. 

This is Microsoft, so you just buy a ticket and they will just work with you until it is fixed. However, I have not had any issues where I needed to contact them.

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

We previously used MySQL, because it is a free product. It was just hard to operate, do backups, and make automated. Also, it was not scalable.

How was the initial setup?

Initial setup is real simple. Just install it. Though, I recommend for new users to at least look online for training or a manual.

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

It has the easiest licensing.

Which other solutions did I evaluate?

We are a Microsoft shop, so we use Active Directory. That integrates well with this product, but we did look at Oracle. We also looked at IBM. This was the best price point for us for what we were getting.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Info Sec Consultant at Size 41 Digital
Real User
Top 5
High availability/failover clustering makes DR straightforward.

Where to start?

Great range of admin tools (far outnumbers MYSQL) - I like the database tuning tools 
Nice BI tools and integration ability. 


Evolves quickly due to the monster support from MS
Integrates with the rest of MS products (this is a plus and a minus, of course)
Scalable - a few MBs up to petabytes. 
High availability/failover clustering makes DR straightforward.

Own reporting services - if you can't report on it, it's hard to manage. 

Problems include - is it an MS product? Then licensing can be a pain if they do an audit. 

Also, with AWS's offerings becoming so easy to set up, scale, and work at great speed, MS SQL probably needs to up its game massively if they are ever going to keep up, let alone fully compete with Amazon's database suite.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user158343 - PeerSpot reviewer
it_user158343Software Architect at a tech consulting company with 51-200 employees
Top 20Real User

I agree with the fact that the inclusion of AlwayOn tools (since SQL Server 2012) has somehow simplified the configuration of High Availability (HA) settings in SQL Server, in this sense, the HA part in HADR (High Availability - Disaster Recovery) is a little bit simpler than with previous versions of SQL Server.

But we have to realize that when you include an HA solution to an instance of SQL Server, you should previously conduct a proper analysis on HADR for said instance, and that analysis is more complex than a (simpler) Disaster Recovery Plan.

It will take more time to complete a proper HADR Plan for your instances at your site, once you have your HADR Plan approved, you have to design and plan the detailed implementation of said plan.

But then again, AlwaysOn simplifies the config of HA in SQL Server, and said AlwaysOn (HA) solutions in SQL Server are a great complementary solution to a DR solution in SQL Server, in particular, if you combine Failover Clustering and Automatic Failover DB Mirroring with a DR solution for a given database in a given instance, instance that is covered by Clustering.

Kind regards, GEN

See all 3 comments
PeerSpot user
Senior IT Consultant/Program Mgmt at Consultant
Consultant
Performance Monitoring

Valuable Features:

Activity Monitor and Dynamic Management Views

Improvements to My Organization:

After reviewing a client's Microsft SQL environment, I have been able to setup specifics alerts and jobs in SQL Server Management Studio (SSMS) to definitely show them where they are experiencing network latency, disk latency, memory pressure, etc., etc.  I have done this type of performance review for over 20 clients in the last 5 years

Room for Improvement:

When reviewing SQL processes it would be great if all of the local processes on the SQL server were marshaled to a remote SSMS client.

Use of Solution:

I have been using Microsoft SQL Server since 6.0

Deployment Issues:

WMI configuration

Initial Setup:

Setting up Microsoft SQL server performance alerts and jobs on a single server or in a Cluster is very straightforward. I typically start off looking at the following:
  • Batch Request/Sec
  • Buffer cache hit ratio < 96%
  • CPU Utilization  > 80 % sustained
  • Compilation/Sec
  • Re-compilation/Sec
  • Page Life Expectancy (PLE)
  • User Connections
  • Lock Waits / Sec: _Total
  • Process Lock/Block By

My objectives are to provide a baseline to determine database growth pattern to ensure capacity planning, stability, bottlenecks, etc., etc.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1595568 - PeerSpot reviewer
Technical Content Writer at a computer software company with 51-200 employees
Real User
Reliable with a simple setup but requires a knowledgable user
Pros and Cons
  • "The solution is stable. It's reliable."
  • "The scalability could be better."

What is our primary use case?

We primarily use the solution to store databases. 

What is most valuable?

Since MongoDB, we have come up and there are lots of tools that do enhance the database management system or keep an eye on our data. People can easily access it. 

The solution is stable. It's reliable. 

The initial setup is simple. 

What needs improvement?

MongoDB is a bit better. A traditional database system, like the SQL Server, is failing to catch up.

You need an experienced person to use that piece of technology so that you can store everything in a logical manner. We'd like it to be easier to store in a logical manner.

The scalability could be better. 

For how long have I used the solution?

We've been using this solution since 2012. It's been a while at this point. 

What do I think about the scalability of the solution?

It's not scalable. It hinders your performance as it's slow in nature and you need experienced people to work on it. That is why it's not very scalable.

We currently have ten to 15 users on the solution. 

At this time, we have no plans to increase usage. We are focusing more on MongoDB.

How are customer service and support?

We don't have any experience with Microsoft technical support. Therefore, I wouldn't be able to rate how responsive or helpful they are.

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

We did not previously use a different solution. We are currently moving towards MongoDB, however.

How was the initial setup?

The installation is easy, especially since the new version has come up. Now, with the latest versions, installation is easy.

I cannot remember the time it took to complete the installation.

What about the implementation team?

Earlier, we had to bring in a technical team, however, our own technical team is quite experienced now. They can now do it themselves.

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

We pay a yearly subscription fee. 

What other advice do I have?

We use both cloud and on-premises deployment models. We're using the latest version of the solution. 

I'd recommend the solution to other users and organizations. If there are people who can't afford MongoDB or if an organization doesn't want to migrate to MongoDB, it's important to keep in mind the users would have to learn the fundamentals of the SQL server first. Knowledge of it is a necessity.

I'd rate the solution at a six 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
Veerender Kumar - PeerSpot reviewer
Product Owner at Software Technology
Real User
Top 20
Straightforward installation, easy database access, and scalable
Pros and Cons
  • "They have improved the UI and ease of accessing the database and server which is good. You can load it up and start using it from the very minute it is implemented."

    What is our primary use case?

    We use SQL Server to manage and store information.

    What is most valuable?

    They have improved the UI and ease of accessing the database and server which is good.
    You can load it up and start using it from the very minute it is implemented.

    For how long have I used the solution?

    I have been using SQL Server for two and a half years.

    What do I think about the stability of the solution?

    SQL Server is stable. We have more resources that are using it, I am more familiar with SQL Server. I have been using it for a long time. Most of the time it has been stable.

    What do I think about the scalability of the solution?

    The solution is scalable.

    We have approximately 30 people in my organization using this solution.

    How are customer service and support?

    The technical support is okay.

    How was the initial setup?

    The installation is straightforward.

    What about the implementation team?

    We have administrators and engineers that do support the solution.

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

    We are on a monthly subscription and the price could improve. However, the price has worked out well in some deployments. The problem is you never know what kind of services have been installed and you have to be in touch with many people, such as which servers are active or which are not. I did face a couple of issues in terms of subscriptions and the pricing model. They have improved over time.

    What other advice do I have?

    I would recommend this solution to others. My advice to others wanting to implement this solution is you have to consider the industry demand and the benefits or advantages of a solution before you choose, for example, Oracle or Microsoft.

    I rate SQL Server an eight 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.
    PeerSpot user
    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 Tools
    Buyer's Guide
    Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.