Member of the Board & Co-Founder, Executive Manager at Networld Systems
Real User
Good replication and helps to reduce costs
Pros and Cons
  • "The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations."
  • "I would like to have more replication scenarios."

What is our primary use case?

We have a Windows Server environment.

This is a production system for secure document issuing in a government department.

How has it helped my organization?

It helped reduce licensing costs and also running costs, as well as the learning curve.

What is most valuable?

The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.

What needs improvement?

I would like to have more replication scenarios.

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

For how long have I used the solution?

I have been using this solution for twenty years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
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.

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 technical 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
Buyer's Guide
SQL Server
March 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,857 professionals have used our research since 2012.
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
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
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
    Enterprise Solutions Department Manager at Smart Vision
    Real User
    Top 20
    A stable solution for storing and retrieving data
    Pros and Cons
    • "The technical support is good."
    • "The user interface and the reporting could also be improved."

    What is our primary use case?

    We are a software development company. Most of our developers use SQL Server. We plan to continue using this solution in the future.

    We use SQL Server for relational database management.

    We have a variety of customers who use it in the government sector and in the tourism sector.

    What needs improvement?

    The time series database could be improved. There needs to be more storage space for large documents.

    The user interface and the reporting could also be improved. It's not bad, but it could be improved upon.

    For how long have I used the solution?

    I have been using this solution for 20 years.

    What do I think about the scalability of the solution?

    SQL Server is both scalable and stable.

    How are customer service and technical support?

    The technical support is good.

    How was the initial setup?

    Installation was very easy. We had it installed within one hour.

    What about the implementation team?

    One of our team members deployed it.

    What other advice do I have?

    I would definitely recommend this solution to others.

    On a scale from one to ten, I would give SQL Server a rating of eight.

    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
    CEO at a tech services company with 11-50 employees
    Real User
    Integrates well with Microsoft tools, but needs better stored procedures integration
    Pros and Cons
    • "It is integrated with Microsoft tools."
    • "The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control. In terms of new features, we don't have any feature requests. We are not focusing on the database."

    What is our primary use case?

    We are using it for accounts payable and accounts receivable automation. We make accounts payable and accounts receivable solutions, and we're using SQL Server as one of the building blocks.

    What is most valuable?

    It is integrated with Microsoft tools.

    What needs improvement?

    The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control.

    In terms of new features, we don't have any feature requests. We are not focusing on the database.

    For how long have I used the solution?

    I have been using SQL Server for 17 years.

    What do I think about the stability of the solution?

    Its stability is okay.

    What do I think about the scalability of the solution?

    Its scalability is okay.

    How are customer service and technical support?

    Their technical support is okay.

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

    It is something we have been using for a lot of years. If we're paying, it should be reasonable.

    What other advice do I have?

    I would recommend looking at other solutions. You can also look at the Azure SQL implementation because it is easier to start with.

    I would rate SQL Server a seven out of ten.

    Which deployment model are you using for this solution?

    Private Cloud
    Disclosure: My company has a business relationship with this vendor other than being a customer: partner
    PeerSpot user
    PeerSpot user
    Software Engineer at a tech services company with 10,001+ employees
    Real User
    Stable, user-friendly interface, and good community support
    Pros and Cons
    • "The interface is user friendly."
    • "Better integration with other platforms would be an improvement."

    What is our primary use case?

    We use SQL Server to store, retrieve, and manage data.

    What is most valuable?

    This product works well, serving as our operational database.

    The interface is user friendly.

    What needs improvement?

    Better integration with other platforms would be an improvement.

    For how long have I used the solution?

    I have been using SQL Server for almost two years.

    What do I think about the stability of the solution?

    We have had no issues with stability.

    What do I think about the scalability of the solution?

    This is a scalable product. It is being used in three or four projects with a total of between 50 and 100 people.

    How are customer service and technical support?

    I have not been in contact with technical support for this project, but we use the Microsoft communities to get answers to questions that we have. For example, we have checked the settings to make sure that we are safe.

    Overall, the support is pretty good.

    How was the initial setup?

    The initial setup is definitely straightforward and can be completed within a couple of minutes.

    What about the implementation team?

    The installation and initial setup were completed by our admin team. However, there are some drivers and additional components that I installed myself.

    What other advice do I have?

    We always like to work with the best products, we are happy with SQL Server, and I recommend it.

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