Try our new research platform with insights from 80,000+ expert users
it_user280197 - PeerSpot reviewer
BI Solution Architect at a tech services company with 501-1,000 employees
Real User
The database engine is one of the most valuable components of the platform.

What is most valuable?

The database engine within SQL Server 2014 is one of the most valuable components of the platform to me.

The engine provides a solid and efficient database backend for any relational database requirement, performance is strong and there are options such as table, index partitioning and columnstore indexes that enhance the scalability of the platform.

In addition to the database engine, I would also highlight the built-in integration services platform (SSIS) for ETL purposes as well as the Reporting and Analysis Services functionality (SSRS and SSAS respectively).

One of the key features that I would use regularly to support the delivery of a Data Warehouse solution would be the Master Data Services (MDS). This is an extendable Master Data Management platform that works very well out-of-the- box.

How has it helped my organization?

As an IT Services organization, our companies have used this product in dozens of customer deliveries for solutions such as ERP applications, Data and Analytics solutions, and more. We also use the product internally as the backend for some of our most important operational systems.

What needs improvement?

The user interface to the web frontend of MDS could be more intuitive and the Analysis Services platform has not evolved much in recent times, these are the two things that come to mind.

For how long have I used the solution?

This specific version (2014), I have used for approximately three years. However, I use other versions of the software on a regular basis, such as 2012 and 2016.

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

What do I think about the stability of the solution?

There were no issues with stability.

What do I think about the scalability of the solution?

There were no issues with scalability.

How are customer service and support?

Microsoft has a solid support structure for the SQL Server platform and I’ve always been provided with a good service.

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

We used a combination of RDBMS platforms and we still do in addition to this solution.

How was the initial setup?

The installation and configuration was very straightforward. The full setup typically takes less than one day.

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

The Enterprise license includes features that enrich the product experience as well as performance and scalability options. Choose this over the standard license where possible.

Which other solutions did I evaluate?

We reviewed many RDBMS platforms for suitability depending on the requirements of the customers. We would also use the likes of Oracle 12c and Amazon RDS.

What other advice do I have?

Install a trial version as soon as you can and give it a try.

Disclosure: My company has a business relationship with this vendor other than being a customer: My company (Version 1) is a Microsoft Gold Partner. We are also an Oracle Platinum Partner as well as Amazon, etc.
PeerSpot user
PeerSpot user
Engineer at a hospitality company with 1,001-5,000 employees
Real User
The High Availability feature provides us with failover if a node becomes unavailable, but it lacks realtime data refresh in SSRS.

Valuable Features:

It's a solution that's always on.

Improvements to My Organization:

It has High Availability, therefore provides failover if a node becomes unavailable.

Room for Improvement:

  • Few in SSIS
  • Realtime data refresh in SSRS
  • More datasources in Power BI
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Albeez - PeerSpot reviewer
AlbeezIT Director at DAR AL ARKAN
Real User
Buyer's Guide
SQL Server
October 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,562 professionals have used our research since 2012.
PeerSpot user
Infrastructure Analyst / Engineer (24x7) at a tech services company with 501-1,000 employees
Consultant
The user interface can be improved but its always been reliable and consistent, providing tremendous functionality.

What is most valuable?

  • Reliability
  • Ease of use
  • Extensive Knowledge Base to improve and maintain the product

How has it helped my organization?

The majority of the software frameworks utilised by companies I have supported use SQL Server by Microsoft as the application's database management system. It always been reliable and consistent providing tremendous functionality for many years. 

What needs improvement?

The user interface can be improved through the adoption of the intuitive interaction design of the MS Office 2013 applications.

For how long have I used the solution?

 5 years

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

I previously used MongoDB before the stability of innovative products still remains questionable in both theory and practice. 

What was our ROI?

100%.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1614828 - PeerSpot reviewer
Chief Information Officer at a tech consulting company with 51-200 employees
Real User
Easy to use, scalable, and reliable
Pros and Cons
  • "The main feature of this solution is ease of use."

    What is our primary use case?

    We use SQL Server for database management.

    What is most valuable?

    The main feature of this solution is ease of use.

    For how long have I used the solution?

    I have been using SQL Server within the past 12 months.

    What do I think about the stability of the solution?

    The solution is stable and reliable.

    What do I think about the scalability of the solution?

    SQL Server has been very scalable.

    We have approximately 200 users using the solution in my organization.

    How are customer service and technical support?

    We are satisfied with the technical support.

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

    I previously used a different solution in the other company I worked for.

    What about the implementation team?

    We have a hardware support partner who does the implementation.

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

    The price of the solution could be cheaper.

    What other advice do I have?

    I rate SQL Server a 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
    reviewer1362969 - PeerSpot reviewer
    IT Specialist at a government with 1,001-5,000 employees
    Real User
    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?

    We use SQL Server for collecting and storing our data.

    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.

    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 technical 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.
    PeerSpot user
    Managing Partner at Veribir Ltd
    Real User
    Easy to manage, stable and scalable
    Pros and Cons
    • "SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based."
    • "The solution could improve by being more user-friendly."

    What is our primary use case?

    We are using SQL Server for internal development projects.

    What is most valuable?

    SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based.

    What needs improvement?

    The solution could improve by being more user-friendly.

    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?

    The solution is stable.

    What do I think about the scalability of the solution?

    The solution is scalable, we have found it to be vertically scalable, but horizontal scaling, we have not used it for this purpose.

    We are mostly using this solution for internal use, not for public services. We have approximately 10 developers using it.

    How are customer service and technical support?

    My experience with technical support has been an average level of satisfaction.

    How was the initial setup?

    The installation is easy.

    What about the implementation team?

    We have one individual that is managing the solution at this time.

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

    For our purpose, we are not required to have a license for what we are using it for.

    What other advice do I have?

    I would recommend this solution to developers who are familiar with Microsoft's platform. However, for others who work with Linux-based solutions, I could recommend something else.

    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
    Anteneh Asnake - PeerSpot reviewer
    Modern Data Center and Cloud Engineer II at IE Network Solutions PLC
    MSP
    Easy to use, scalable, and good technical support
    Pros and Cons
    • "The solution is easy to use."
    • "The performance could improve."

    What is our primary use case?

    We use the solution for managing our database functions.

    What is most valuable?

    The solution is easy to use.

    What needs improvement?

    The performance could improve.

    For how long have I used the solution?

    I have been using the solution for approximately four years.

    What do I think about the stability of the solution?

    I have found SQL Server stable.

    What do I think about the scalability of the solution?

    I have found it to be scalable.

    How are customer service and technical support?

    The technical support is good from Microsoft. We have four people that do the maintenance of the solution.

    How was the initial setup?

    The initial setup is straightforward, it took approximately one hour.

    What about the implementation team?

    I did the implementation myself.

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

    There is a license required for this solution.

    What other advice do I have?

    I would recommend this solution to others.

    I 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
    reviewer1489908 - PeerSpot reviewer
    Systems Engineer at a tech services company with 11-50 employees
    Real User
    Stable, easy to use, and offers a quick deployment
    Pros and Cons
    • "The installation is pretty straightforward."
    • "The pricing of the product could be better."

    What is most valuable?

    Right now, we are using DB2 and the SQL Server. It's really helpful for the replication of data. It's real-time and very easy to use.

    The product is very stable. We find it to be reliable.

    The scalability is okay. 

    The installation is pretty straightforward.

    What needs improvement?

    For now, we've found the features to be sufficient. I cannot recall feeling anything is actually missing.

    The pricing of the product could be better. They could make it more reasonable or more competitive.

    Microsoft's technical support could be better.

    For how long have I used the solution?

    We've been supporting these servers for a couple of years at this point. It's likely been about two or so years. We've worked with them for a while. 

    What do I think about the stability of the solution?

    The solution is very stable and reliable. There are no bugs or glitches. It doesn't crash or freeze. We're happy with it.

    What do I think about the scalability of the solution?

    The scalability potential depends on the resources. If the resources are enough, we can scale it. For us, it's already enough. However, if a company plans to expand, it should be prepared for that beforehand. 

    We have more than ten users on the solution currently.

    How are customer service and technical support?

    Microsoft technical support could be improved upon. They aren't the best. They could always be better.

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

    We also use IBM DB2. We support it for our customers.

    How was the initial setup?

    We have found the solution to be straightforward. It's not overly difficult or complex. A company shouldn't have any issue with implementation.

    The product implementation process depends on the needs of the client. For us, deployment was around 30 minutes to one hour. It's pretty quick.

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

    The solution could be priced more competitively. We'd, of course, like it to be lower. Microsoft can sometimes be expensive.

    Each customer needs their own license.

    What other advice do I have?

    We use the solution both on the cloud and on-premises. 

    I'd rate the solution at a nine out of ten. We've been pleased with its capabilities overall.

    I would recommend the solution to other users and companies. They should know that it is very easy to use. 

    We had two people that handled the initial setup - an engineer and a manager. It's pretty easy to handle if an engineer is doing the setup.

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