SQL Server Review

I've used SQL Server​ for most of the solutions I worked for, from web crawlers to logistic platforms and medical devices


What is most valuable?

Database Engine

Integration Services

Reporting Services

How has it helped my organization?

I am a Senior Software Engineer. I've used SQL Server for most of the solutions that I worked with, from web crawlers to logistic platforms and medical devices.

What needs improvement?

  • The Server Objects area of SQL Server Management Studio
  • The SQL Server Configuration Manager

For how long have I used the solution?

Over 10 years.

What do I think about the stability of the solution?

Yes, I encountered issues only when using the Express editions during the development. SQL Server, generally speaking, is stable also in high transaction environments.

What do I think about the scalability of the solution?

Yes, I encountered issues in the CPU intensive application, like web crawlers. It was difficult to reach the desired scalability through the fine tuning options available.

How is customer service and technical support?

The support is good. The knowledge base is very good.

Which solutions did we use previously?

I have experience with Sybase SQL Anywhere .

I switched mainly because the SQL Server is widely deployed and known, for better XML support, and for better integration with .NET framework and its related technologies.

How was the initial setup?

It was straightforward for most of the installation, thanks to the wizards.

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

I am not a direct purchaser, so I don’t know.

Which other solutions did I evaluate?

SAP/Sybase SQL Anywhere for the small footprint which makes it suitable for embedded solutions.

SAP/Sybase SQL Anywhere for the built-in synchronization technologies available.

What other advice do I have?

Improve the built-in database replication technologies.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Sign Up with Email