Microsoft SQL Server BI Software

Pros

The Microsoft SQL server works perfectly well with the Sage Enterprise Resource Management (X3) software.

Cons

Sometimes the SQL server will get a random glitch that will cause an unwanted error. This sometimes messes with the X3 program too.

Pros

Is an excellent tool, easy to maintain and simple to create jobs, stored procedures, views, analysis of data.

Cons

The cost of the licensing is too much, this is the only downside I have found with Microsoft products but for everything else are great.

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

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.

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.

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.

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

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.

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.

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.

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.

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

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

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.

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.

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.

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

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.

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

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.