Overall Satisfaction with Microsoft SQL Server
The organization has implemented an ERP system that has a Microsoft SQL Server backend. We also use Microsoft SQL Server for business reporting, analytics and intelligence.
- The relational database management system is easy to use in designing database objects, including primary and foreign keys, constraints, default values, triggers, etc.
- Microsoft SQL Server is great at processing sets of data.
- Microsoft SQL Server's transactional structured query language (T-SQL) is very easy to use for ad-hoc queries as well as for designed database programs for database and application maintenance, operations and reporting.
- The cost of Microsoft SQL Server is often not feasible for smaller businesses.
- I'd like to see source control integrated into SQL Server, so that all changes to the database objects are automatically versioned and stored for reference or retrieval.
- Microsoft SQL Server is where I have earned my living for going on two decades.
- As previously stated, Microsoft SQL Server is not always affordable for small business.
Years ago I used Oracle and Oracle Data Integrator and I hated it. It was cumbersome and archaic and I couldn't believe the product could be so popular. Given a database related task and a choice between Oracle or Microsoft SQL Server, SQL Server wins hands down in ease of use, speed of design/development and maintenance.