MohamedAfeilalGeneral Manager at New System Engineering
Anonymous UserInformation Systems Manager at a aerospace/defense firm
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"Every version is faster than the previous."
"This solution has made financial reporting possible by allowing financial people the opportunity to set Informix to "Auto Pilot" so that they can attend other duties."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"For IoT business cases, having Informix Enterprise Edition work on edge computers, like Raspberry Pi and using Informix replication, makes complex situations simple to build and maintain."
"The initial setup is pretty easy."
"So far, we do not have a lot of issues. It's pretty problem-free."
"The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations."
"The availability is the most valuable feature. It has high availability. It also has good performance."
"SQL is very easy to manage."
"It helps with moving the design of the database into reality."
"The feature that I have found most valuable is that it is easy to code."
"Very good security features."
"The features that we have found the most valuable are reliability, availability perspective, and current scalability."
"The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful."
"I really would love to have a QT plugin."
"This solution is in need of more current tools."
"There should be more intelligence surrounding discovering data to be able to automatically create indexes."
"Continue extending the SQL language for compatibility with the competition's language, including Stored Procedure Language."
"The pricing is a bit expensive."
"The solution really doesn't add new features very often."
"I would like to have more replication scenarios."
"In terms of improvement, it could use more integration with other products."
"Occasionally the performance, as good as it is, is a bit off. We sometimes experience memory spiking. If they could maybe fix that aspect of the solution, that would be quite helpful for our organization."
"The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient."
"In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages."
"Query optimitzer could be simplified."
"The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience."
"CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server."
"The free edition can be enough to handle moderate-size implementations, but you may want a pay for edition to benefit from more functionality, such as replication."
"SQL Server is a cost-effective solution for a small database."
"Pricing is reasonable for small organizations, but the scaling increases the price."
"We didn't have any licensing costs for SQL Server."
"We pay approximately $12,000 USD per month for both the server and the license."
"The price could be cheaper."
"Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."
"We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous."
"With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.
Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.
IBM Informix is ranked 8th in Relational Databases with 7 reviews while SQL Server is ranked 1st in Relational Databases with 49 reviews. IBM Informix is rated 9.0, while SQL Server is rated 8.2. The top reviewer of IBM Informix writes "Many embedded functionalities of the engine allow for significant savings on complex developments and maintenance". On the other hand, the top reviewer of SQL Server writes "A stable, scalable, and easy-to-deploy solution that pretty much covers everything". IBM Informix is most compared with Oracle Database, IBM Db2 Database, MySQL, Oracle Database In-Memory and Oracle Multitenant, whereas SQL Server is most compared with SAP HANA, Oracle Database, IBM Db2 Database, Teradata and IBM Netezza Performance Server. See our IBM Informix vs. SQL Server report.
See our list of best Relational Databases vendors.
We monitor all Relational Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.