IT Developer at a financial services firm with 10,001+ employees
Real User
Performs well for our use case
Pros and Cons
  • "SQL Server's performance is fine."
  • "SQL Server could integrate better with other platforms."

What is our primary use case?

It's a normal DMS, so it can be used everywhere you want to use any RDBMS or relational database. It's for normal transactions.

What needs improvement?

SQL Server could integrate better with other platforms.

For how long have I used the solution?

I've been using SQL Server for the last six months. Earlier we used DB2, but now we use this one.

What do I think about the stability of the solution?

SQL Server's performance is fine.

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

How are customer service and support?

Microsoft support is fine.

How was the initial setup?

We don't deal with the setup because we are developers. The system or admin team does all those things. So I don't have any idea.

What other advice do I have?

I rate SQL Server eight out of 10. We haven't had any issues, but it depends on the use case. So I would recommend it depending on your use case.

Which deployment model are you using for this solution?

On-premises

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
ICT Consultant at a tech services company with 11-50 employees
Real User
Stable, easy to use, and simple to deploy
Pros and Cons
  • "The product can scale if a company needs it to."
  • "The solution could be more secure."

What is our primary use case?

We have used it in a variety of ways, including for e-commerce deployments. 

What is most valuable?

The solution is easy to use.

The deployments are very easy.

Technical support is very helpful.

The product can scale if a company needs it to.

The stability is quite reliable. 

What needs improvement?

The product can cost a bit, however, it depends on how you use it. 

The solution could be more secure.

For how long have I used the solution?

I've used the solution over a number of years. I may have started originally around 2000. It's likely been two decades or so.

What do I think about the stability of the solution?

The product is quite stable. there are no bugs or glitches. it doesn't crash or freeze. It's reliable. 

What do I think about the scalability of the solution?

You can scale this solution if you need to. It's not an issue. 

Everyone in our company is using the product. We have about 80 users on it currently.

How are customer service and technical support?

Technical support has been helpful and responsive. We have no complaints. We are satisfied with the level of service provided to our company.

How was the initial setup?

The solution is very easy to deploy. It's not a problem.

The amount of time it takes to deploy depends on what you want the solution to do for your company.

What about the implementation team?

We have an installer available to us that can guide us through the process and help us choose the right options. 

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

The solution can get expensive. You do need to pay a licensing fee in order to use it. I can't speak to the exact costs. There are different subscription types and the subscription a company needs depends on the deployment they have in mind.

What other advice do I have?

I've used the solution on a couple of deployments and also deploy patches. 

I'd rate the solution at an eight out of ten.

I would recommend the solution to other organizations and companies. 

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
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,334 professionals have used our research since 2012.
Operations Director at ALTERSIS Performance
Real User
Flexible and easy to use but the performance could be better
Pros and Cons
  • "It's a good option for those that have a lot of Microsoft solutions in use."
  • "The solution needs to be more secure. It's lacking, compared to, for example, Oracle."

What is our primary use case?

We use the product for information systems. This is a must both for us. We use it for our Enterprise Portal.

What is most valuable?

The solution has proven to be very flexible.

The product is quite stable.

Overall, we've found it to be extremely easy to use. 

The initial setup is pretty straightforward. It's not difficult to implement and the deployment doesn't take too long.

Technical support has been pretty good so far. They are helpful.

It's a good option for those that have a lot of Microsoft solutions in use.

What needs improvement?

The solution needs to be more secure. It's lacking, compared to, for example, Oracle.

The product needs to work on its scalability. Oracle can scale a bit more effectively.

Sometimes we have some performance issues. It's not like Oracle. Oracle is more powerful in terms of performance. 

For how long have I used the solution?

I've just been dealing with the solution for a few months. It hasn't been too long just yet.

What do I think about the stability of the solution?

We've had some performance issues overall. It's something that's a pain point for us. They need to work on their capabilities in this regard.

What do I think about the scalability of the solution?

The solution could be more scalable. Oracle scales better for companies that need to expand.

We have two to three customers that use the solution currently.

How are customer service and technical support?

We've used technical support in the past. They've been helpful and responsive. We haven't had any issues when we deal with them. We are quite satisfied so far with the level of service we receive when we reach out. 

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

I've also used Oracle in the past. From my side, Oracle is more technical and is more scalable, and more secure than the SQL server.

How was the initial setup?

The installation is quite straightforward. It's not overly difficult or complicated. I found it to be quite simple.

The deployment is rather quick. It took us about one hour, from what I can recall.

We just need one technical person to handle the implementation and maintenance processes. 

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

Customers do have to pay to use the solution. They tend to pay on a yearly basis. 

What other advice do I have?

I'd rate the solution at a seven out of ten.

I'd recommend the solution to other customers, users, and companies. It's a good option of r many. Sometimes the customer is Microsoft-oriented and sometimes they are Oracle-oriented. If the customer is already using a lot of Microsoft products, SQL just makes sense. 

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: Integrator
PeerSpot user
Sr Tech Business Analyst, Group Data Projects & Ventures at a financial services firm with 10,001+ employees
Real User
Stable, flexible, and scalable
Pros and Cons
  • "The solution seems to be pretty flexible."
  • "Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools."

What is our primary use case?

Currently, I'm moving to another set of projects. One is for a small company that supports a client and is building on a different surface on the SQL server. The cloud that is used is essentially Amazon AWS.

What is most valuable?

SQL SSIS is the most useful aspect of the solution.

We find the product to be relatively stable.

The solution seems to be pretty flexible.

What needs improvement?

Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools. There are other tools on the market that are much more advanced. It would be better if they managed to give us a bit more of a user-friendly product with just a bit more meat on the bone. It's a bit basic.

There are a number of features that are lacking. Just recently I had to do something and it's not available on the SQL Server. However, it's available on another solution that's actually a much cheaper product. 

Some areas need improvement. For example, how you deal with the manipulation of data is probably not the best.

For how long have I used the solution?

While I haven't constantly used the product all of the time, overall, I've used it for over 10 years at this point. I have quite a few years of experience with it.

What do I think about the stability of the solution?

The solution is quite stable. It doesn't have issues with bugs or glitches. It doesn't crash or freeze. It's good.

What do I think about the scalability of the solution?

In general, the solution is scalable. Microsoft, compared to the others, tends to focus more on the programming ability of the solution rather than the user experience. Rather than making it more user-friendly, they tend to make it more program-friendly.

We have about 70 users on the solution currently.

It's my understanding that the client is planning to scale up to be able to take on more customers in the near future. They may therefore increase usage.

How are customer service and technical support?

Mostly, I personally am on the analytics and new project development side of things in our organization. Therefore, I typically don't deal with technical support. I can't speak to how supportive, knowledgeable, or responsive they are. 

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

I typically use SQL wherever I go, however, I don't necessarily use Microsoft all the time. I also occasionally use a solution called Teradata.

How was the initial setup?

I was not involved in the installation of the solution. I'm more on the side of creating metadata. Therefore, it would be difficult for me to comment on if the solution was easy or difficult to implement or how our team deployed it. I don't have any exact details on that front.

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

While there are costs involved in using the product, I'm not a part of the billing or payments team. I can't speak to how much the solution costs or how much our organization pays. I do not know if it's monthly or yearly and how long our contract is for, if we have one.

What other advice do I have?

I'm using the 2016 or 2017 version of the solution.

There are many SQL options. I'd only recommend this one if it made sense to the individual company and their requirements.

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

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Software Architect at a tech consulting company with 51-200 employees
Real User
Enabled us to use an Agile approach to the design and implementation of DW solutions.

What is most valuable?

  • SQL Server Integration Services tools
  • Data Quality Services tools
  • Master Data Services tools
  • SQL Server Reporting Services tools
  • Data Partitioning (Horizontal Partitioning) tools
  • ColumnStore Indices
  • In-Memory OLTP tables

How has it helped my organization?

We design and implement DW solutions with SS 2016 Dev Ed tools. This solution has given us high levels of productivity, which has allowed us to use an Agile approach to the design and implementation of DW solutions for our customers, and this Agile approach has in turn given us a competitive advantage in our market.

We have also started exploring the use of Microsoft R Client, MS R Services and MS R Server with SQL Server 2016 Dev Ed, which are part of the hosted Data Science package.

We are also looking forward the inclusion of Python support in SQL Server 2017 for said hosted Data Science package.

We are very interested in complementing DW solutions with Data Science and Machine Learning solutions, which could be a major plus for our existing DW customers, even though all hosted data science tools are only available in Enterprise Ed (for our customers), which again presents the same limiting factor (budget) already mentioned.

Having said that, we see that the potential that the hosted Data Science tools offer to some of our customers is large enough to be explored and considered on a case by case basis, with proper ROI analysis.

What needs improvement?

We do not have much to complain about SS 2016 Dev Ed in itself, we do have some complaints regarding licensing for SQL Server 2016 Enterprise Ed. In an emerging market like Argentina, it is very steep for our customers to pay U$S 28,000 or more on licensing for an instance of SS 2016 Enterprise Ed, and this poses a limiting factor to our growth.

For how long have I used the solution?

We have been using SS 2016 Dev Ed for a few months so far, but have been using the previous version (SS 2014 Dev Ed) for more than two years.

What was my experience with deployment of the solution?

The deployment tools for DW solutions in both 2014 and 2016 editions of SQL Server are part of the SQL Server Data Tools (SSDT) package. As SSDT is based on Visual Studio, this toolset has been very stable since its inception, both in terms of performance as well as in terms of functionality, so, deployment in 2016 is done in the same way as in 2014, which translates into no issues during deployment.

What do I think about the stability of the solution?

There were no stability issues.

What do I think about the scalability of the solution?

There were no scalability issues, even though the Dev Ed does not offer the same level of performance and scalability that the equivalent Enterprise Ed offers.

Pertaining to the hosted Data Science package that we have been exploring, we have found an important increase in scalability when comparing the performance of a given solution running as hosted, and the same solution running on the same server with only client R tools.

This scalability advantage presents itself as an important reason to consider these tools as a viable solution to some of our DW customers.

How are customer service and technical support?

Customer Service:

As usual, MS offers a very good customer service. The amount of resources (self-study materials, online courses, tutorials) is huge, most of it is free.

Paid customer service is also very good.

Technical Support:

Paid tech support is very good and efficient.

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

I have always used DW tools from Microsoft since SQL Server 2000.

How was the initial setup?

If prior to the setup you do the proper training, there are no issues with setup, but the learning curve is wide and tall.

You could get started fast and sure if you stick to the many Wizards included with the tools, but the scope of said Wizards is limited.

What about the implementation team?

We did not have deployment/implementation issues.

What was our ROI?

Since SS 2014 Dev Ed, MS is offering these tools free of charge, ROI mainly is focused around training investment. As I have said, we do the training in-house. ROI is around one year (12 months).

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

No issues with pricing and licensing for SS 2016 Dev Ed, as it is free of charge, as mentioned above, the thorny issue with pricing and licensing is with customers. We do our best to design DW solutions that can cover reqs from our customers within the capabilities of SS 2016 Standard Ed.

Which other solutions did I evaluate?

The cost-benefit ratio offered by Microsoft's DW solutions is, by a long shot, much more convenient for our customers (small and medium companies) than solutions from other vendors, hands down.

What other advice do I have?

Consider the ROI (most training investment). If training is not in-house, only hire training from an official Microsoft Training Center in your region. Look for the best Training Center. Once you are done with the training, you can start taking customers for DW projects.

Disclosure: My company has a business relationship with this vendor other than being a customer: I teach MOC courses on the design and implementation of DW solutions with the aforementioned tools.
PeerSpot user
PeerSpot user
IT Consultant & IT Project Manager Assistant with 10,001+ employees
Vendor
SSIS, SSRS, and DB help in everything.

What is most valuable?

The SSIS, SSRS, and DB are the most valuable features because they help in everything.

How has it helped my organization?

There is improvement in the performances and stability.

What needs improvement?

SSIS needs improvement.

I think that it should be easier in managing SQL packages, especially when we have multiple environments. With Kerberos Authentication, we had different issues on this and sometimes, we needed Microsoft Support too. Thus, a better and an organized SQL package review is needed.

What do I think about the stability of the solution?

When using HA (high availability), we experienced some stability issues.

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and technical support?

Technical support is the best, I would give them a 10/10 rating.

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

We were using a few other solutions such as MySQL, Oracle and Pervasive PSQL.

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

It’s okay as compared to the features that it has.

Which other solutions did I evaluate?

We evaluated the Oracle solution.

What other advice do I have?

If you want stability, then choose the best.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Software Architect at a tech consulting company with 51-200 employees
Real User
Provides data quality services tools and In-Memory OLTP tables.

What is most valuable?

SQL Server integration services tools

Data quality services tools

Master data services tools

SQL Server reporting services tools

Data partitioning (horizontal partitioning) tools

ColumnStore indexes

In-memory OLTP tables

How has it helped my organization?

We design and implement data warehouse solutions with SQL Server 2016 Developer Edition tools. This solution has:

Given us high levels of productivity

Allowed us to use an agile approach to the design and implementation of data warehouse solutions for our customers

Given us a competitive advantage in our market

What needs improvement?

We do not have much to complain about SQL Server 2016 Developer Edition in itself.

We do have some complaints regarding licensing. In an emerging market like Argentina, it is very steep for our customers to pay USD 28,000 or more on licensing for an instance of SQL Server 2016 Enterprise Edition. This poses a limiting factor to our growth.


For how long have I used the solution?

We have been using SQL Server 2016 Developer Edition for a few months so far. We have been using the previous version (SQL Server 2014 Developer Edition) for more than two years.

What was my experience with deployment of the solution?

We did not encounter any deployment issues.

What do I think about the stability of the solution?

We did not encounter any stability issues.

What do I think about the scalability of the solution?

We did not encounter any scalability issues. This is the case even though the Developers Edition does not offer the same level of performance and scalability that the equivalent Enterprise Edition offers.

How are customer service and technical support?

Customer Service:

As usual, Microsoft offers very good customer service. The amount of resources (self-study materials, online courses, and tutorials) is huge and most of it is free. Paid customer service is also very good.

Technical Support:

Paid technical support is very good and efficient.

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

I have used data warehouse tools from Microsoft since SQL Server 2000.

How was the initial setup?

If you do the proper training prior to the setup, there will be no issues. However, the learning curve is wide and tall.

You could get started fast and sure if you stick to the many wizards included with the tools. However, the scope of those said wizards is limited.

What about the implementation team?

We implemented with an in-house team only, with proper, prior training that was also done in-house.

What was our ROI?

Since SQL Server 2014 Developer Edition, Microsoft has been offering these tools free of charge. The ROI is mainly focused around training investment. We do the training in-house, so the ROI is around one year.

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

We have no issues with pricing and licensing for SQL Server 2016 Developer Edition, as it is free of charge. The thorny issue is with pricing and licensing with customers.

We do our best to design data warehouse solutions that can cover requirements from our customers within the capabilities of SQL Server 2016 Standard Edition.

Which other solutions did I evaluate?

The cost-benefit ratio offered by Microsoft's data warehouse solutions is, by a long shot, much more convenient for our customers, small and medium sized companies, than solutions from other vendors.

What other advice do I have?

My advice is focused on companies that develop and offer data warehouse solutions for customers that use SQL Server. Consider the ROI, which is mostly training investment (for the Developer Edition). If training is not done in-house, only hire training from an official Microsoft training center in your region. Look for the best training center. Once you are done with the training, you can start taking customers for data warehouse projects.

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
Real User

@KathyC, I really appreciate your thoughtful remarks on my review. Feedback is always welcome, as it helps all reviewers to focus on what is important to our peers.

Kind regards, GEN

See all 2 comments
Admin at IEC (Electoral Commission of South Africa)
Real User
Top 5Leaderboard
Stable and scalable data storage for enterprise applications
Pros and Cons
  • "SQL is stable."
  • "SQL could be improved by making all features available on the on-premise version of the product as well as the cloud version. When you buy the on-premise version, it's sort of an inferior product compared to the cloud version, which seems to get most of the latest and greatest features."

What is our primary use case?

SQL is our main data store for enterprise applications, all applications that we have in the organization.

What needs improvement?

SQL could be improved by making all features available on the on-premise version of the product as well as the cloud version. When you buy the on-premise version, it's sort of an inferior product compared to the cloud version, which seems to get most of the latest and greatest features.

For how long have I used the solution?

I've been using this solution for a few years.

What do I think about the stability of the solution?

SQL is stable.

What do I think about the scalability of the solution?

This solution is scalable.

How are customer service and support?

I am satisfied with Microsoft's technical support.

How was the initial setup?

The initial setup was ok, it met our requirements.

What about the implementation team?

We implemented SQL ourselves, and it took around a week to install.

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

Subscriptions are available on a yearly basis.

What other advice do I have?

I would give SQL a score of nine 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: 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.