Microsoft SQL Server: Perfect Data Manager for an Organization
March 07, 2025

Microsoft SQL Server: Perfect Data Manager for an Organization

varun kohli | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

Microsoft SQL Server is used in our organization by IT personnel to Store data, fetch data specific to requirements. For instance, in Sales Module SQL server is used to fetch data specific to a sales transaction and it helps to troubleshoot the errors reported by users. Similarly, it is used by IT technical team and other IT functional team to query the data stored in data server.

Pros

  • Data Storage,Data retrieval in conjunction with front-end software
  • Scalability to handle small-large database
  • SQL server available with different architectures under one umbrella

Cons

  • Nested queries are complex and need expertise - BI should be used to provide ease
  • Time and Space complexities - Can be improved
  • OLTP can be further enhanced
  • Cloud version can be improved
  • Its definately value for money product and 2 generations are using it with easy in our office environment.
  • The reliability and trust associated with this query tool is unparallel and since the old techies are also well versed with Microsoft SQL Server, the guidance required at times is easily available.
  • ROI is uncountable - There is no comparison and positive return trajectory is going up by each year.
The DDL,DML and DCL part takes the usability to next level ensuring data integrity, parallel transactions, high availability and thus, robust architecture. Data warehousing, data security are some of the key take aways of the product for the IDE associated and the concerned user. The in-memory related techniques used in the product makes it a sophisticated product.

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

1) We had a set-up where the ERP application and the servers were in-house and Microsoft SQL Server is perfect to query the data and troubleshoot the error reported by user. 2) The Microsoft SQL Server is taught to students from high school and this is like a baseline for students from IT. So it makes it easy to use at organization level since individual had already gained lot of experience in querying in previous projects at college level or otherwise. 3) In case of Cloud architecture, there is stiff competition and every software enterprise need to re-version itself for betterment. Otherwise, its- no less than any product out there.

Comments

More Reviews of Microsoft SQL Server