Overall Satisfaction with Microsoft SQL Server
Microsoft SQL Server is being used on different projects for different customers. I had a chance to use this software several times and it left a very good impression. Microsoft SQL Server has a good set of tools for developers, its T-SQL language is convenient. Microsoft SQL Server can be used both by medium and large size enterprise applications and is pretty easy to scale out using techniques like replication, clustering etc.
- Good query optimizer. For complex a query it provides helpful tools like Query Tuning Advisor.
- Reliable database engine.
- Many options for replications.
- Good additional out-of-box features like Integration services, Analysis services and Reporting services.
- No integration with source control like Microsoft TFS.
- Intellisense can be improved further.
- Positive user experience with software applications that use SQL Server - faster data retrieval.
- Positive development experience - easy to develop and maintain databases.
- Oracle Database, Oracle Data Warehouse and Oracle EBS Financials
SQL Server is better in some scenarios when all other software products are also from Microsoft.