Microsoft SQL Server BI Software


 

Microsoft SQL Server Business Intelligence (BI) Edition is a database management and BI software solution designed for companies of all sizes. The system offers relational database management, which allows users to access enterprise data using structured query language. The solution allows users to perform complex analysis on the database. The product also features a BI Semantic model that allows users to extract and analyze data from heterogeneous sources.

Microsoft SQL Server features “in-memory analytics,” which allows users to perform queries and analytics while the data is in the RAM, thereby improving the speed of access. The software has scalable and corporate reporting features that help management to make decisions that are more informed. Organizations can improve the data quality by using the organizational knowledge and third-party reference data providers to profile, clean, and match the data.

The IT department can manage data through a BI Semantic Model, which provides a consistent view across multiple data sources.

 

Microsoft SQL Server - BI Edition - Sales summary
 
  • Microsoft SQL Server - BI Edition - Sales summary
    Sales summary
  • Microsoft SQL Server - BI Edition - Buffer pool extensions
    Buffer pool extensions
  • Microsoft SQL Server - BI Edition - Query
    Query
  • Microsoft SQL Server - BI Edition - OLTP
    OLTP
Supported Operating System(s):
Windows 7, Windows Vista, Windows XP, Mac OS, Linux, HP-UX, AIX, Solaris, Unix, IBM OS/400, Web browser (OS agnostic), Windows 2000, Windows 8, Windows 10

358 Reviews of Microsoft SQL Server - BI Edition

 

Start your review of Microsoft SQL Server - BI Edition

Click to start
https://www.softwareadvice.com/bi/microsoft-sql-review/
Software Advice Reviews (39)
More Reviews (319)

Showing 1-20 of 39

Joshua from Education
Specialty: Software / Technology
Number of employees: 51-200 employees Employees number: 51-200 employees

July 2018

July 2018

SQL Server BI Addition

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

I would recommend this software. It is a little expensive, but if you have the capital to so do, invest in this. It is easy to use and does an exceptional job of analyzing data.

Pros

Nice Interface
Easy to Use
Great for data analytics
Great for Reporting
Great software for someone who isnt an expert

Cons

There are a lot of features, but theres so many its hard to find them all. Some features are hidden under drop down menus

Review Source
 
 

Brian from Mercy Health
Specialty: Healthcare / Social Services
Number of employees: 10,000+ employees Employees number: 10,000+ employees

June 2018

June 2018

Build more Powerful models with SSAS in Visual Studio for improved performance. Better tools and easier (but not easy) for the novice.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Really improved integration with other tools, especially Excel and Power BI. Also, somewhat more intuitive than more limited SSAS instances.

Pros

This is extremely useful software for data analytics and reporting, and the new interface with Microsoft Excel Power Pivot makes it much easier for a novice to pick up some useful tools. It's an especially nice product to set up a live connection with KPIs to Power BI which does not allow users to create KPIs independently.

Cons

Unless your data model is based on an organization server, modeling in SSAS will not help with much more than consolidating multiple sources into a single connection...in which case you either need to maintain a live connection or load into memory. So either keep your system running 24/7 triple your RAM.

Review Source
 
 

Kevin from UCLA
Specialty: Healthcare / Social Services
Number of employees: 10,000+ employees Employees number: 10,000+ employees

May 2018

May 2018

analytical tools like Microsoft SQL are the future of enterprise computing

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

Microsoft SQL is a versatile tool that can support organizational analytics and business intelligence

Cons

this product is rather complex and requires SQL experience in order to use. Some robust usability testing may reveal opportunities to enhance the queries to be more user-friendly.

Review Source
 
 

Maria Reena from PACE Sensors Limited
Specialty: Manufacturing
Number of employees: 11-50 employees Employees number: 11-50 employees

May 2018

May 2018

Simply Powerful

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

I would recommend this product even for small businesses.

Pros

Easy to manage database even if our databases are stored in different areas in the system, easy to navigate and to run queries.

Cons

A little expensive. It would help to improve user interface and make it easier for non technical users like me.

Review Source
 
 

Jasper from Per Expressie
Specialty: Non-Profit
Number of employees: 11-50 employees Employees number: 11-50 employees

May 2018

May 2018

Microsoft SQL Server - BI Edition

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

This is a great program, and deep down, it has all the functions and features you'd ever want from a program like this

Cons

A lot of features and functionality is hidden below loads and loads of dropdown menus and subfolders, which makes it hard to find sometimes

Review Source
 
 

Gregorio from SIMNSA
Specialty: Software / Technology
Number of employees: 11-50 employees Employees number: 11-50 employees

April 2018

April 2018

Sql is an excellent database engine, surpasses all my expectations.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

In general it is an excellent database engine from small to large companies.

Pros

It is a very versatile and functional tool, it is very robust, it is easily integrated to multiple platforms and other systems, the connection is very simple and you find many forums on the internet that help you make the most of it.

Cons

Multiple types of licenses, which in some cases becomes expensive when you must buy to comply with CALS depending on the number of users.

Review Source
 
 

Alonso from HealthCompany
Specialty: Healthcare / Social Services
Number of employees: 201-500 employees Employees number: 201-500 employees

April 2018

April 2018

Simple and Powerful

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Highly recommended

Pros

Easy to maintain, good reporting, good performance, third party integrations (source control, TFS). Simply one of the best database systems.

Cons

It is not the cheapest on the market, but it is one of the best and most powerful data base systems. Definitely worth it.

Review Source
 
 

Gregory from Infinity
Specialty: Healthcare / Social Services
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

April 2018

April 2018

A great SQL server solution with a great deal of features and support, but expensive

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

A very stable environment with clustering, replication, and everything you would expect from an enterprise level product.
Includes a huge number of tools for working with data including import, export, SSIS, SSMS, TSQL and more.
You can build your own custom modules that will integrate directly into the server.
Recent versions allow for installation on Linux.
There are user groups.

Cons

Not the most expensive, but still expensive, especially with free alternatives.
Some of the Microsoft nomenclature around TSQL can be annoying, such as square brackets.
Some features seem unnecessary and ponderous, like XML.

Review Source
 
 

Denis from DBI
Specialty: Software / Technology
Number of employees: 201-500 employees Employees number: 201-500 employees

April 2018

April 2018

MS SQL Server Perfect Database Management Solution

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

I would definitely recommend that you read the Windows administration book before you start exploring SQL server.

Pros

SQL server is a great database management product. This is a very fast and stable and at the same time cross-platform solution running on both Linux and Windows operating systems, the security of which is implemented at the highest level. It is also gratifying that SQL server works equally well on both physical and virtual servers, both on the ground and in the cloud. Since this product is produced by Microsoft, it integrates well with other products of this company, such as Power BI. This app can provide you with high availability and a wide selection of options available of your choice, though everything will depend on the edition. And most importantly, many features can be tested completely free using Developer Edition.

Cons

Although SQL server is easy to manage through the graphical user interface, but to understand how it works, to fix some problems you need to read a thick book, and even more than one and read ton of documentation. Does not have good monitoring tools out of the box. For some companies will not be a cheap solution.

Review Source
 
 

Halima from Veris
Specialty: Healthcare / Social Services
Number of employees: 501-1,000 employees Employees number: 501-1,000 employees

March 2018

March 2018

In love with SQL Server

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Just the best data base motor for me

Pros

Show you exactly where the error is
Has many foros of expert people for every error you can face
Have a really fast response
Multi user profiles

Cons

You need preview known of database coding
Depending on your configuration might need internet conection

Review Source
 
 

Kenatu from TPDCo
Specialty: Public Sector
Number of employees: 51-200 employees Employees number: 51-200 employees

March 2018

March 2018

Its Easy, Friendly and Familiar

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

My company is primarily a Microsoft shop, so why not MS BI. Our Govt. has an MOU with MS so we get all the tools and we are trained in most things MS so we are comfortable and satisfied with this product. Even our PeopleSoft solutions run on SQL Server.

Pros

1. Easy to use even by non-technical users
2. If you know what you are doing you can extend functionality and flexibility for almost anything you want
3. The above leads me to my next pro : stable IDE and flexible integration with SSAS

Cons

1. A common language to develop and make changes would be nice
2. Its expected that you are an excel expert - but then again who isn't
3. It uses a lot of hardware power - but we have the horses

Review Source
 
 

Brian from EDI Staffing
Specialty: Other
Number of employees: 51-200 employees Employees number: 51-200 employees

March 2018

March 2018

SQL Server is the best all around relational database

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

SQL Server provides easy use for both end users and developers/administrators. It's ability to seamlessly blend in with the Microsoft infrastructure makes it a no brainer to purchase for most businesses.

Cons

It sometimes does not play nice with non-MS systems, but I think that's more to do with the quality of the work the developer does.

Review Source
 
 

Eric from Vision
Specialty: Software / Technology
Number of employees: 11-50 employees Employees number: 11-50 employees

March 2018

March 2018

The Leader!

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Value for Money

The best by far (obviously)

Pros

Enhancements to Intellisense have been remarkable. Also love that reporting services have been shifted to using Adobe. So clean and simple.

Cons

Only minor improvements. Maybe an automatic "Refresh Local Cache" after adding a table or column. Also, when using built in functions, the system doesn't see the FROM statement automatically.

Review Source
 
 

STENIO from Sogexpress
Specialty: Software / Technology
Number of employees: 2-10 employees Employees number: 2-10 employees

March 2018

March 2018

I have more than 3 years using this software, it always help me accomplish the tasks that I need.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

The "Job" feature. The reason I love this feature, is because it's allow you to schedule task that need to be performed without human intervention.

Cons

It's difficult to install. The installation and un-installation features are kind of difficult to perform.

Review Source
 
 

Tasleem from Q Soft
Specialty: Consulting
Number of employees: 11-50 employees Employees number: 11-50 employees

February 2018

February 2018

MS SQL server not a replacement for Oracle

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Its good for learners and beginners but not for professionals

Pros

Very easy to use as compared to oracle
Easy to manage and maintain with tools
easy to start work with

Cons

Performance is very poor as compared to other sql servers
not reliable for enterprise solutions
very expensive product

Review Source
 
 

Brett from KVC
Specialty: Healthcare / Social Services
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

February 2018

February 2018

The Standard in Server Technology

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Pros

The SQL Server solution is a very robust solution with lots of features that make managing your data much easier.

Cons

The cost of maintaining the solution can get pricey if you try to add components individually. The best is to use it within a Microsoft shop solution.

Review Source
 
 

Andrey from DBI
Specialty: Software / Technology
Number of employees: 201-500 employees Employees number: 201-500 employees

February 2018

February 2018

Tha most advanced relational database solution on market today

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

Easy to deploy and provide basic configuration, rich set of data management and performance tuning tools comes out of a box. Linux support started with SQL 2017. High Availability and disaster recovery solutions are great

Cons

Complex query language, lack of analogue of Oracle RAC with true load balancing between nodes. Polybase requires java

Review Source
 
 

Jian from CAMH
Specialty: Healthcare / Social Services
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

February 2018

February 2018

A popular BI platform that makes the implementation of integrated BI services easy.

Ease-of-use

Functionality

Product Quality

Customer Support

Overall Microsoft SQL Server BI would have a solution for most requirements of a typical BI solution. The look & feel, as well as how the tool interacts with its users can be improved.

Pros

Microsoft SQL Server BI offers a full set of tools and functionalities for different phases of a BI solution. Since it is a very popular and widely being used, there are a lot of resources available.

Moreover, Microsoft provides tools and services that serves both the upper stream and lower stream of BI services, making the adoption of Microsoft SQL Server BI seamless on existing Microsoft infrastructures.

Cons

A lot of tools are not smart enough and requires intense manual work. For example, SSMS can't recognize and auto-pop newly-created tables/views without restarting; SSIS is not able to refresh the metadata on its own when there is underlying table changes; SSRS offers very limited format control for Excel/PDF export.

Review Source
 
 

Jeff from Vertiv
Specialty: Software / Technology
Number of employees: 10,000+ employees Employees number: 10,000+ employees

February 2018

February 2018

SQL for Business Use

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Value for Money

I have had a few issues in the past when the intellisense feature did not work correctly but this was usually resolved with a simple restart of the program.

Pros

The functionality of this product and ability to analyze large sets of data to discover important trends helps dramatically in a business setting.

Review Source
 
 

Shashank from Revmax
Specialty: Engineering
Number of employees: 11-50 employees Employees number: 11-50 employees

January 2018

January 2018

Simply powerful

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Overall its easy, fast and efficient

Pros

The auto fill feature is helpful and works well for digging through a lot of tables.
It works well for managing databases, controlling security for access to the SQL databases, setting up simple scheduled management tasks such as database backups (dumps), and it lets you generate and test queries.

Cons

Often it crashes and needs to be restarted.
Computationally intensive processes can take a long time relative to distributed systems.
Certain aspects such as managing security permissions and accessing logs are not fully intuitive and the location of these items are not accessible from the top level, requiring the user to dig deeper and find them

Review Source
 
 
 
Write a Review
Showing 1-20 of 319

Jorge from RINNOVO CORP
Number of employees: 11-50 employees Employees number: 11-50 employees

July 2018

July 2018

SQL is a good RDBMS solution for a comprehensive cost you can get a medium tool

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

A really good alternative with medium cost, efficient and a competitive management tool to perform the most of DBA tasks, including graphical tasks as building mirroring server for replication purposes

Pros

Oracle SQL Server Offers a really good set of features depending of the type of license (standard, Enterprise,etc)

I was worked with standard and enterprise, And my overall experience is SQL is a good database engine to cover the most of small and medium enterprise requerinment, it can cover OLTP and ODS databases.

SQL Server offers on standard version features such mirroring to replication sites. SQL provides a GUI interfaces called SQL Management Studio, it provides a comprehensive tool to do the most DBA responsabilities.

Cons

When you compare with other database engines like Oracle, then SQL doesn't look robust and the performance is a kind of limited.

No native perfomance (real time and graphic) tools came with the product.

Review Source: Capterra
 


July 2018

July 2018

Great data base! Recommended for bussiness or personal use.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Easy to use, secure, stable, good performance.

Pros

SQL Server is a data base that is increasing your functionality, features; has a great performance on Windows or Linux, is stable, secure. You can use it for big projects like SAP without any trouble. Highly recommended, you can do a test with the free version of SQL Developer - you will get all the features, but it is just for devoloping, not for production use. You can use the Express edition for free but with the limitation that the dabase file size is just of 10GB.

For example in a company that I give IT services they had SQL Server 2005 with Windows Server 2003 r2 for many years, they moved to SQL Server Standard 2014 with Windows Server 2012 in 2016 because they need to apply an update over a software. So, it is very stable and secure. We didn't have any issue or problem during all the years (and still).

Cons

I don't have any negative comment about SQL Server, because from my point of view it is a very good and stable data base. May the only one could be the price.

Review Source: Capterra
 

Yash from Panamax inc

July 2018

July 2018

It's good for managing db

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

MDX queries are really useful in SSAs queries.
Interesting to work with said, ssrs and power bi. Easy analytics tool.

Cons

Configuration is not good.
It's express version contains limitations.
Also database size is limited in express version

Review Source: Capterra
 


July 2018

July 2018

Solid Database.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

Microsoft SQL Server is a great product. It is very easy to use and the SQL syntax is very similar to other SQL languages. The database is scalable and speeds are great.

Cons

I wish SQL server was available on mac without having to use other programs like Docker to get it to work. Native apps always work better and it is a pain in a development environment. When you bring on new employees it is one more step to get the setup and ready to go.

Review Source: Capterra
 

Renny from Legendsoft

July 2018

July 2018

Great experience working with this database engine excellent to create a ERM from scratch in no time

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

I learned how to make an entity relationship model and working with sql sentences in no time learned new data types in this database engine to build data bases that fits properly

Pros

Great for working with .net framework and entity framework, haves many specific data types that helps you define a more efficient database

Cons

Sometimes i had to restart the database engine to make it function properly because the data it was showing was not updated

Review Source: Capterra
 

Steve from CarFinance 247
Number of employees: 201-500 employees Employees number: 201-500 employees

July 2018

July 2018

Great SQL solution for small to large applications

Ease-of-use

Functionality

Product Quality

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Pros

Easy to get started. SQL Server supports many features and is frequently getting updated with many more.

Cons

SQL Server can be quite resource heavy at times and the IDE can crash occasionally. intellisense is quite basic

Review Source: Capterra
 

Rahul Kumar from OATI
Number of employees: 501-1,000 employees Employees number: 501-1,000 employees

July 2018

July 2018

I am using SQL server from three years as I am a software developer.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

I am able to store thousands of users information in a arranged way.
I am able to analyse the data from different sources.
I am able to print report such as pdf file.
I am able to get backup of my data.
I can show the records in any form using SQL queries.
I can fetch details of any number of customer in just a second without going through the bunch.
I can update the data about my customer.
I can delete any unnecessary data.
I can send automatic mails using the sql job.
I can make my data easily accessible by using different index provided by SQL.
I can sort the data in ascending, descending or in alphabetical order.
So bottom line is I am making money by investing some money into SQL server.

Pros

1. The capability of extraction and manipulation of data. Using sql server you can fetch or gather data from different file system like excel file csv file etc and then manipulate them according to your need like sort them with name, make the first later of name in capital etc. And then you can print the manipulated data as well.
2. It provides backup for all your stored data into it, by this there is no worry of loosing your data.
3. After making backup obviously they provide the facility to restore those backups.
4. As I mentioned in first point report generation is also its one of the powerful feature.
5. It serves as back end for many programming language. When someone is maintaining his site.
6. Support of different tools like SQL profiler these tools will work as magic when you will be performing complex task.
7. Another tool is tuning adviser that can suggest you different ideas with which you can optimize your sql queries.
8.Gives you ability to run different instance of sql server in one system by this i mean one can have SQL server 2012 and then after that you can also have SQL server 2014 and 2016 parallaly.
9. Debugging tools like debugger.

Cons

There are very few things left about it as it has released its different versions.
1. It is paid
2. It is heavy sometimes it stucks.
3. Takes lot of resources like memory and space.

Review Source: Capterra
 


July 2018

July 2018

Easiest DB to use and well supported amongst many LOB Applications out there

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

Perhaps one of the better platforms to learn and apply query language due to the immense amount of supporting material, knowledge base articles and forum posts out there.

Cons

We've seen overall performance go down once the database size grows too large which taxes the processors a bit more that you would think a multi-core machine could handle.

Review Source: Capterra
 


July 2018

July 2018

It is so powerful and rich.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

What i like more is the diversity of the features within SQL, for most is the best option anytime and in any situation, anything related to Database!? You got to choose SQL. Microsoft products are always the best, i used all of their products and im always satisfied by the results.

Cons

Only one thing: the level of difficulty when using it the first times, but with so many hours of learning and training it gets better and better, easier and easier.

Review Source: Capterra
 

Chanuka from SLIIT
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

July 2018

July 2018

Best application to work with SQL queries so far.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Created many databases using this application.

Pros

The query execution in this application is smooth and very efficient. The speed of execution is useful in compiling a large amount SQL queries in one go. Overall this was nice to work with and didn't have any issues working with this application in my time working with SQL Server.

Cons

There is no feature to separately represent triggers, functions or procedures in a clear and a proper manner. That may not be bad part of the application but it is something that this application lacks. As well as the feature to create a DB Document. This is also m-not in this SQL Server application.

Review Source: Capterra
 

Madhur from Nagarro

July 2018

July 2018

SQL Server is one of the best software developed by Microsoft

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

A robust database management system that can integrate well with different ecosystems. It offers a wide set of features and is definitely a leader in its business. It is very fast and stable and it also provides one of the best data encryption and security solutions. It has a very intuitive UI that is best suited for both naive and expert database users.

Cons

The high price of SQL Server is a big drawback and is not suitable for small businesses. Also, it eats up the RAM while performing query extensive operations and thus requires good computing power.

Review Source: Capterra
 

Danish from SEO DISCOVERY
Number of employees: 201-500 employees Employees number: 201-500 employees

July 2018

July 2018

Best software to handle database even with the heavy databases and for the reporting tool.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

we can use this software for heavy database handling with ease. It is very useful for the analytics as well as the reporting tool. we can connect multiple databases at the and intelligence works very well in the latest version.

Cons

MS SQL server bit costly to maintain and we do have knowledge of SQL, I suggest it should have drag-drop functionality.

Review Source: Capterra
 

Aníbal from Banco Bicentenario, Banco Universal C.A.

July 2018

July 2018

My experience with sql Server has been satisfactory, I have done punctual work.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

I have worked several times with this software for different reasons I have been able to simplify developments thanks to the Transact-SQL so it has saved me programming time, the services that I have under my responsibility at work are stable, this gives confidence and tranquility for me and for my bosses, I made restorations in record time.

Pros

This software has as its first advantage that it is a Microsoft product and has the full support of the company and the stability of a well-tested product. At the basic level, I find it very efficient, the sql responses are fast and there are almost no service interruptions, which is a point in its favor when I use it, I find the Transact-SQL language that is used very powerful, I was able to assign commercial processes of the application in the database that allows multiple applications to use them and it is not necessary to program these functions in each application, the SQL server administration tools are very well thought to be all in a Microsoft environment, the integration is perfect, they are very intuitive to find new functions, they do not require prior knowledge, what is important to train new staff, another thing that I like about this software is the scalability that can start with a small database and grow, in A past project had transactional tables that inserted millions of records daily. I like security, it is possible to assign specific permissions to different users who perform different activities within the same database, this makes me trust the product.

Cons

The least I like is undoubtedly the cost SQL-Server does not have a good cost-benefit ratio, other brands offer better benefits in this regard, another point is the high consumption of RAM, it is necessary to allocate a large amount of resources for this And to guarantee the quality of the service, until now I have not found a hosting provider that offers me a PHP server with Sql-server. This stopped once a new development for a client was disappointing to me. It is difficult to learn in a particular way, the free versions of this software are very limited and the certifications are expensive, which reduces the interest when it is investigated.

Review Source: Capterra
 


July 2018

July 2018

Awesom experience after using it with visual studio.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

Its user friendly behaiour. Easily connectivity with visual studio. Able to debug the issues in sql server profiler tool. Good interface and intelligence feature.

Cons

Sometimes it got disconneted then again we need to provide mappings to it. Hangs too much sometimes. Every time if we change something in the database from visual studio using code first approach we need to refresh the database again to get the latest version.

Review Source: Capterra
 


July 2018

July 2018

It is a good database manager

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

Good product to educate users.

Pros

It is a very good software that serves as support in classes for my students and that follows the established standards.

Cons

It is payment and as a consequence you have to have money to be able to keep it updated and this for me is a limitation for its dissemination.

Review Source: Capterra
 

benjamin from NLS BANKING SOLUTIONS AFRICA

July 2018

July 2018

Great for security sensitive projects

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

MsSql is a great software to use especially for DR backups. It is easy to manipulate and it has a very innovative user interface

Cons

One has to have a prior understanding to SQL language in order to make use of MsSql. It is not just for anyone to install and manipulate without knowledge

Review Source: Capterra
 

Martin from OneSpace.com
Number of employees: 51-200 employees Employees number: 51-200 employees

July 2018

July 2018

Effortlessly house large data sets.

Ease-of-use

Functionality

Product Quality

Customer Support

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Support

Data manipulation, data base management, reporting

Pros

SQL server is a DB admin's best friend. We use it daily to brows large data sets and easily feed to external reports through SSIS/SSRS. SQL Server is responsive and stable enough to run huge data sets. It is easy enough to create new DB's and we especially like the online support available to us for SQL Server.

Cons

In the downside it is a little outdated in the UI and somewhat complicated to get used to at first. Further than that there is no downside as it does the job so well.

Review Source: Capterra
 

Gregor from gotosystem

July 2018

July 2018

The most important RDBMS for developers

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

It's a really reliable RDBMS to keep data, I use it for many asp and C# applications and never fails me. Replication it's easy to set up.

Cons

Can be resource consuming. Don't use an specific standard for tables or columns names and many developers use something different.

Review Source: Capterra
 


July 2018

July 2018

Excellent tool for Database administration

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

I have used various forms of database administration and SQL is by far the best! It works very well with different plug ins like SSIS if you are doing things like data warehousing.

Cons

It could be hard to install and you need to make sure that the versions are compatible with one another. For instance you have to make sure that Visual Studio is compatible with SQL.

Review Source: Capterra
 


July 2018

July 2018

It works. It's stable. That's about it.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Pros

It is a very stable system that keeps chugging for the most part. There are always updates and it is pretty easy to maintain.

Cons

Way more bloated than say SQLite or other alternatives. Pricing is high, especially when there are free alternatives

Review Source: Capterra
 
 
Write a Review