MS SQL as seen by UI developer
December 14, 2015

MS SQL as seen by UI developer

Marko Večko | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

We are using MS SQL Server to manage the database of our product. We have some inquiries - that we need in our software implemented as stored procedures on the server, but the core of our business logic is done through LINQ to SQL in the "engine" part of our solution. It is used only by the programming team.
  • Quick backing up and restoring of databases. Particularly useful when testing.
  • I find triggers useful to keep the integrity of business logic.
  • Tools that come with it.
  • Easy installation process and setting up new databases.
  • Managing user roles and security could be clearer.
  • Cost of the Enterprise version.
  • We are just about to ship our first MS SQL Server based product, so the ROI remains to be seen.
I used mySQL for some smaller web projects. I liked the open source part of it, but the development tools were not on par with those of MS SQL Server. I've only dabbled a little bit with Oracle at my university but my career path led me into the Microsoft environment.
I find its capabilities helpful in keeping the business logic integrity, but would not depend on having all that logic on the server side. I think many smaller businesses could greatly benefit from migrating their many Excel documents to MS SQL Database.