Good robust software for handling complex datasets
April 08, 2021

Good robust software for handling complex datasets

Paul Nockolds | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft SQL Server

We use Microsoft SQL Server to store various databases that are used within both the whole company and also within certain departments. Data from these databases have front-end interfaces for easy editing by certain users and data also feeds into other systems and is merged with other data sources. It allows us to have a common silo for storing our data that helps developers and admin staff easily access the data for further use.
  • Good range of data types helps us store lots of diverse data
  • Easy administration helps us control who has access and what they can do with the data
  • Backup and restore processes are easy to manage and provide good security
  • Data can be easily replicated from Server to Server for use in other countries
  • The import/export process can be tricky to follow with lots of steps and could be better for importing flat files
  • Obtaining help from Microsoft is cumbersome and often other internet sources are better and quicker
  • The documentation is not great and again it's generally better to obtain help elsewhere if needed
  • Easy to use backup and restore processes
  • Sensible and easy to understand datatypes hand together well
  • Good management studio to help manage the system as a whole and also develop within it and needs arise
  • Aids swift system development for new systems to get them up and running quickly
  • Can administer quickly and easily to help the business keep up with changing requirements
  • Allows us to gain competitive advantages over other organisations to get a better foothold in our chosen markets

Do you think Microsoft SQL Server delivers good value for the price?

Yes

Are you happy with Microsoft SQL Server's feature set?

Yes

Did Microsoft SQL Server live up to sales and marketing promises?

Yes

Did implementation of Microsoft SQL Server go as expected?

Yes

Would you buy Microsoft SQL Server again?

Yes

Ultimately [Microsoft SQL Server] is fairly easy to set up and easy to use if you have knowledge of relational databases and how they work. Being from Microsoft it is a well known, widely used robust piece of software that is ever evolving and plenty of related information can be found all over the internet in various guises such as forums and blogs.