Most Helpful Review
View all the numbers through one single platform to make business decisions, but pay for the privilege
Easy to use and integrates well with other Microsoft products, but the performance needs improvement, and there are...
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"For planning, forecasting, in-boxing, modeling in general and for predicting numbers and doing work analysis, they are excellent."
"The most valuable features are Report Development (Functionality) and Information Distribution (Flexibility)."
"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."
"I have experience with this product for many years. I never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient."
"It is one of the most stable relational databases out there."
"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 charts and graphics are weak."
"This product could use improvement in terms of usability for those with less technical know how."
"They were lacking in the initial phases of development in the area of big data, and they still need to improve that aspect of the product."
"It would be nice if there was a feature to search for a specific value across multiple tables. This would save a lot of time for its users."
"I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins."
"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."
Pricing and Cost Advice
"Pricing should be improved."
"It is expensive, but you get what you pay for."
"Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can typically sell from around $1000 dollars a month, which is not cheap. Then, there is an additional one-time Windows cost, based on the code, which can go anywhere from $30,000 to $40,000 for the license."
"SQL Server is a cost-effective solution for a small database."
"Pricing is reasonable for small organizations, but the scaling increases the price."
Questions from the Community
Ask a question
Earn 20 points
Question: What do you like most about SQL Server?
Top Answer: The availability is the most valuable feature. It has high availability. It also has good performance.
Question: What needs improvement with SQL Server?
Top Answer: In terms of improvement, it could use more integration with other products.
out of 57 in Business Intelligence (BI) Tools
Average Words per Review
out of 34 in Relational Databases
Average Words per Review
Compared 20% of the time.
Compared 15% of the time.
Compared 9% of the time.
Compared 6% of the time.
Compared 4% of the time.
Compared 17% of the time.
Compared 14% of the time.
Compared 13% of the time.
Compared 10% of the time.
Compared 3% of the time.
Also Known As
|Cognos, Cognos Analytics, IBM Cognos Analytics||Microsoft SQL Server, MSSQL, MS SQL|
Cognos Software is IBM's Business Intelligence and Performance Management solution, offering BI, strategy management, financial performance, and data analytics applications. Cognos caters to all levels in an organization with products designed for individuals, workgroups, departments, mid-size companies, and big enterprises.
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.
Learn more about IBM Cognos
Learn more about SQL Server
|More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.||Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.|
Computer Software Company8%
Financial Services Firm8%
Computer Software Company36%
Comms Service Provider9%
Computer Software Company13%
Financial Services Firm10%
Computer Software Company34%
Comms Service Provider13%
See our list of .