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.